Question 1

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

Options :

A : Hierarchical

B : Key-value stores

C : Cloud

D : Object-oriented

Answer: B

Question 2

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 3

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?

Options :

A : Text editor

B : UML editor

C : Word processor

D : SQL query

Answer: B

Question 4

(A database administrator wants users to be able to access resources remotely from home. Which of the following best describes how the administrator can enable this access without compromising the security of the stored data?)

Options :

A : Implement a virtual private network.

B : Implement strong passwords polices.

C : Configure and deploy a firewall.

D :

Implement a perimeter network for internet-facing database applications.

Answer: A

Question 5

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

Free DS0-001 Mock Exam – Practice Online Confidently

Buying Options: