DS0-001 Practice Questions

Which of the following is an advantage of creating indexes?

Which of the following is most likely to prevent tampering with server hardware that houses data?

Which of the following describes the purpose of a snapshot?

Which of the following is a typical instruction that is found on a Linux command-line script and represents a system shell?

Which of the following is a characteristic of all non-relational databases?

Which of the following is used to hide data in a database so the data can only be read by a user who has a key?

A server administrator wants to analyze a database server's disk throughput. Which of the following should the administrator measure?

Which of the following have data manipulation and procedural scripting power? (Choose two.)

Which of the following database instances are created by default when SQL Server is installed? (Choose two.)

Which of the following services is responsible for assigning, managing, and reclaiming IP addresses on a TCP/IP-based network?

Which of the following is an attack in which an attacker hopes to profit from locking the database software?

Which of the following cloud storage options provides users with endpoints to retrieve data via REST API?

Which of the following is used to write SQL queries in various programming languages?

Which of the following best describes a collection of data that shares the same properties or attributes?

Which of the following sets the age requirement for data that should be recovered after a major disaster?

Which of the following is part of logical database infrastructure security?

Which of the following database structures is a type of NoSQL database?

Which of the following NoSQL database types best categorizes MongoDB?

Which of the following tools is used for natively running a Linux system in Windows?

Which of the following constraints is used to enforce referential integrity?

Which of the following NFs is considered the most preferable for relational database design?

Which of the following indexes stores records in a tabular format?

Which of the following resources is the best way to lock rows in SQL Server?

Which of the following commands is part of DDL?

Which of the following best describes the category of SQL commands required to revoke access to database objects?

A company's backup plan includes only running full backups for its small database. Which of the following frequencies would be most appropriate in this situation?

What technology may be used to perform disk-to-disk backups with systems designed to work only with tapes?

Which of the following qualifiers removes duplicate records from a SQL SELECT statement when included in a query?

Brad is helping to design a disaster recovery strategy for his organization and is analyzing possible storage locations for backup data. He is not certain where the organization wi...

Howard is a database designer for an e-commerce website working on creating a table to store customer information. He wants to ensure that each customer can be uniquely identified...

What combination of backup strategies provides the fastest backup restoration time?

Which of the following best describes the policy/and or procedure that ensures records are kept in a database for a period of time and not deleted?

Which of the following ORM tools enables developers to work with a database using .NET objects?

Gary is logging into a system and is providing his fingerprint to gain access. What step of the IAM process is he performing?

Several users received a message from the Chief Executive Officer asking them for their bank account details. Which of the following types of attacks is taking place?

A database administrator would like for users to be able to access resources remotely from home. Which of the following best describes how the administrator can enable this access...

A database administrator wants to create a database that does not have a predefined schema. Which of the following tools should the administrator use to create this type of databas...

A business analyst queries the same few tables every quarter and does not want to write new SQL code every time. Which of the following would best support the business analyst's ne...

Which of the following is a tool for preventing data loss?

Which of the following transactions is allowed in a shared lock?

A database administrator would like to extract a sales performance report from more than one database instance. Which of the following keywords should the database administrator us...

Given the following value from a VARCHAR column that is used to store integer values: 12A Which of the following is the best way for a DBA to increase the data quality for this col...

A database manager would like to reduce the overhead caused by log-based recoveries. Which of the following should the manager use to best mitigate the situation?

Which of the following outlines why replication is important during database management?

Which of the following commands when executed will rebuild statistics against user-defined tables in a database?

Which of the following are ORM tools? (Choose two.)

During a routine audit, a database administrator discovers that the department manager's birthday is next week. The database administrator decides to plan a birthday party for the...

Which of the following database instances are initiated by default when a database administrator installs a SQL Server instance for the first time? (Choose two.)

A database administrator has configured a Resource Governor with three resource pools. The first resource pool is assigned a minimum CPU and memory value of 25%. The second resourc...

An e-commerce website that resides in the cloud is lagging due to high traffic following the launch of a promotional offer. Which of the following should the IT manager do to impro...