DS0-001 Practice Questions

Over the weekend, a company's transaction database was moved to an upgraded server. All validations performed after the migration indicated that the database was functioning as exp...

A DBA is reviewing the following logs to determine the current data backup plan for a primary data server: Which of the following best describes this backup plan?

A database administrator needs to ensure that a newly installed corporate business intelligence application can access the company's transactional data. Which of the following task...

A database administrator is conducting a stress test and providing feedback to a team that is developing an application that uses the Entity Framework. Which of the following expla...

Which of the following is the correct order of the steps in the database deployment process?

A company wants to deploy a new application that will distribute the workload to five different database instances. The database administrator needs to ensure that, for each copy o...

A database administrator manages a database server that is running low on disk space. A lot of backup files are stored on the server's disks. Which of the following is the best act...

A business analyst is using a client table and an invoice table to create a database view that shows clients who have not made purchases yet. Which of the following joins is most a...

A database administrator needs to provide access to data from two different tables to multiple group users in order to facilitate ongoing reporting. However, some columns in each t...

Which of the following describes a scenario in which a database administrator would use a relational database rather than a non-relational database?

A database administrator set up a connection for a SQL Server instance for a new user, but the administrator is unable to connect using the user's workstation. Which of the followi...

A group of developers needs access to a database in a development environment, but the database contains sensitive data. Which of the following should the database administrator do...

A database administrator needs to aggregate data from multiple tables in a way that does not impact the original tables, and then provide this information to a department. Which of...

A database administrator is migrating the information in a legacy table to a newer table. Both tables contain the same columns, and some of the data may overlap. Which of the follo...

A company is launching a proof-of-concept, cloud-based application. One of the requirements is to select a database engine that will allow administrators to perform quick and simpl...

A database administrator needs to ensure database backups are occurring on a daily basis and at scheduled times. Which of the following actions should the administrator take?

Which of the following is a result of an on-path attack on a system?

Which of the following is the best way to migrate a large data load from one table to another, considering total time and blocking?

Following a security breach, a database administrator needs to ensure users cannot change data unless a request is approved by the management team. Which of the following principle...

A programmer wants to configure a database to only allow read or write access when requests are coming from specific IP addresses. Which of the following can be used to configure I...

A company needs to prepare a document that establishes the responsibilities, metrics, penalties, and other generalities that a provider would have to fulfill for customers to use i...

A DBA left the company, and the DBA's account was removed from the system. Soon after, scheduled jobs began failing. Which of the following would have most likely prevented this is...

A database is configured to use undo management with temporary undo enabled. An UPDATE is run on the table. Which of the following describes where the undo is stored?

Which of the following concepts applies to situations that require court files to be scanned for permanent reference and original documents be stored for ten years before they can...

Which of the following is a potential issue raised by enterprise database users?

A database administrator is new to a company and wants to create a document that illustrates the interaction between tables. Which of the following should the administrator create?

Which of the following can be used to protect physical database appliances from damage in a server room? (Choose two.)

A database administrator needs to ensure continuous availability of a database in case the server fails. Which of the following should the administrator implement to ensure high av...

A database's daily backup failed. Previous backups were completed successfully. Which of the following should the database administrator examine first to troubleshoot the issue?

A database administrator is updating an organization's ERD. Which of the following is the best option for the database administrator to use?

A database administrator needs a tool to document and explain the relationships between data in an organization's database. Which of the following is the best tool to accomplish th...

A database administrator has been asked to assign a user the ability to view a data set. Which of the following practices best describes this request?

Which of the following firewall types allows an administrator to control traffic and make decisions based on factors such as connection information and data flow communications?

A new retail store employee needs to be able to authenticate to a database. Which of the following commands should a database administrator use for this task?

A developer is designing a table that does not have repeated values. Which of the following indexes should the developer use to prevent duplicate values from being inserted?

Which of the following would a database administrator monitor to gauge server health? (Choose two.)

A database administrator is concerned about transactions in case the system fails. Which of the following properties addresses this concern?

Which of the following is a reason to create a stored procedure?

An on-premises application server connects to a database in the cloud. Which of the following must be considered to ensure data integrity during transmission?

Which of the following statements contains an error?

A database professional is considering denormalizing a database. Which of the following documents should be used to analyze the database's structure?

A company needs information about the performance of users in the sales department. Which of the following commands should a database administrator use for this task?

Which of the following are the best resources for monitoring potential server issues? (Choose two.)

An automated script is using common passwords to gain access to a remote system. Which of the following attacks is being performed?

Which of the following cloud delivery models provides users with the highest level of flexibility regarding resource provisioning and administration?

Which of the following should a company develop to ensure preparedness for a fire in a data center?

Which of the following is the deployment phase in which a DBA ensures the most recent patches are applied to the new database?

Which of the following computer services associates IP network addresses with text-based names in order to facilitate identification and connectivity?

Which of the following types of RAID, if configured with the same number and type of disks, would provide the best write performance?

Which of the following is recommended in order to provide encrypted data communication pathways for information as it is transmitted over a network?