DS0-001 Practice Questions

Which of the following best describes the function of PowerShell in a database environment?

A database administrator must grant a manager access to all employee data but only grant employees access to their own information. Which of the following would best enable this re...

As part of an integrity check, a database administrator is creating both the primary and secondary snapshots. The database administrator notices the primary replica is failing over...

Which of the following is a best practice during the backup process?

Which of the following statements best classifies a rollback in a database?

Which of the following should be done before applying a patch to a database?

Which of the following characterizes the disruptive effects of a SQL injection and a denial-of- service attack?

A database administrator is assisting developers with finding the best tables and columns to include in an application. Which of the following resources is the most relevant for th...

Which of the following statements is TRUNCATE an example of?

Which of the following is the best alternative to control the temperature in a data center?

Which of the following database structures is designed to store images, records, video, and audio in a single repository?

Which of the following refers to the correctness and completeness of data in a database?

Which of the following best describes the function of a wildcard in the WHERE clause?

A database administrator needs to ensure data that is being migrated from a company's system to a third-party vendor is secure. Which of the following is the best security measure...

Which of the following is used to document the system catalog in a database?

Which of the following should be factored into the decision regarding storage when planning a new database? (Choose two.)

Which of the following cloud delivery models is typically used in environments where organizations delegate control of runtimes, middleware, and compute resources that focus mostly...

Which of the following describes a lock that allows concurrent transactions to access different records of the same table?

Which of the following is a characteristic of a multizone region in a disaster recovery policy?

An IT department needs to validate who signs in and has permissions to use the company's cloud resources. Which of the following can be used to accomplish this task?

Which of the following types of scripting can be executed on a web browser?

Which of the following is used to store product quantities on a table while ensuring the minimal amount of storage is consumed?

A database analyst notices a query statement is running slowly. Which of the following should the analyst review first?

Which of the following transaction isolation levels allows dirty reads?

A database system crashed during a routine migration process. Which of the following should the systems administrator refer to for guidance in this situation?

Which of the following are logical infrastructure security measures? (Choose two.)

A security auditor at an organization wants to compile a list of individuals who have access to the database and their roles. Which of the following is the best source of informati...

A systems analyst receives an error report and wants to quickly switch the rows to columns in order to match the format required for analysis. Which of the following spreadsheet fu...

A database administrator would like to address data inconsistencies, define conventions to be used across the organization, make data easier to analyze, and enforce the use of data...

Which of the following indicates why a data administrator would conduct a baseline configuration in a database?

Which of the following code snippets would allow a SQL injection?

An analyst shared a database directly from a workstation. A week later, users could not access the database, but could access other shared resources. Which of the following is the...

A database administrator executed multiple transactions and needs to finish the operations. Which of the following functions should the administrator use?

Which of the following DR techniques uses a disk to update content in parallel with the main disk so a real-time backup is available?

A database administrator should review the database disaster recovery documentation:

A data analyst would like to select only one copy of each of the duplicated regions in the chart below: Which of the following SQL commands should the data analyst use to complete...

A business wants to be notified when new clients are added to the client list that is stored in the client table. Which of the following SQL statements should the database administ...

A data scientist recently joined a company and needs to review the data before building models. Which of the following tools can the data scientist use to find the most extensive d...

A database administrator realizes that a database does not have the correct columns. The administrator needs to modify the structure using a DDL command. Which of the following sho...

A database administrator realizes that certain data was not captured correctly when it was imported. Which of the following commands should the administrator use to fix the issue?

Which of the following is the preferred data structure for storing hierarchical data models?

Which of the following offers a DBA the ability to gather important performance metrics to help optimize SQL queries and parameters for a database instance?

A database administrator needs to remove a redundant customer table from a database in order to streamline periodic reports. Which of the following commands is best for this task?

Which of the following does a database administrator need to know before planning the setup of a new server for a client?

Which of the following cloud delivery models has the most limitations for user access to the underlying infrastructure?

An account manager, who had employee ID number 0012, resigned from an organization. The account manager's view privileges need to be removed from the customer table. Which of the f...

Five minutes after a power failure occurred in a data center, a CO2 system was automatically triggered. Which of the following caused the CO2 system to start?

Which of the following involves executing code against a database?

Which of the following is the best to consult in order to start the recovery process after a disaster?