Question 1

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

Options :

A : An organization wants to maintain consistency among the data in the database

B : An organization requires data encryption

C : An organization wants to process complex data sets

D : An organization wants to store a large number of videos, photos, and documents

Answer: A

Question 2

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 of the database, users are able to read and write data that will be synchronized across all of the instances. Which of the following should the administrator use to achieve this objective?

Options :

A : Peer-to-peer replicatio

B : Failover clustering

C : Log shipping

D : Availability groups

Answer: A

Question 3

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 issue?

Options :

A : Load balancing

B : Business continuity plan

C : Service accounts

D : Assigning a data steward

Answer: C

Question 4

Which of the following describes the purpose of a snapshot?

Options :

A : To create a dynamic data replication

B : To create a synonym

C : To create a tablespace

D : To create an image of a database

Answer: D

Question 5

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

Options :

A : WSL

B : Remote Desktop Protocol

C : SSH

D : Telnet

Answer: A

Free DS0-001 Mock Exam – Practice Online Confidently

Buying Options: