DS0-001 Dumps with Practice Exam Questions Answers [Q30-Q51]

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

NO.31 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 this task?

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

NO.33 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 explains the approach the administrator should use when conducting the stress test?

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

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

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

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

NO.38 Which of the following commands is part of DDL?

NO.39 Which of the following is an advantage of creating indexes?

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

NO.41 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 availability of the database?

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

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

NO.44 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?

NO.45 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 be discarded?

NO.46 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?

NO.47 Which of the following database structures is a type of NoSQL database?

NO.48 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?

NO.49 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?

NO.50 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?

NO.51 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 principles addresses this issue?