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

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 3

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 4

Given the following customer table:

Which of the following ORM snippets would return the ID, state, and country of all customers with the newest customers appearing first?

Options :

A :

B :

C :

D :

Answer: B

Question 5

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?

Options :

A : Circuit-level

B : Stateful

C : Proxy

D : Packet

Answer: B