Practice DS0-001 Exam Online

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?

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 database administrator wants to create a database that does not have a predefined schema. Which of the following tools should the administrator use to create this type of database? (Choose two.)

A : PostgreSQL

B : MariaDB

C : MySQL

D : SQL Server

E : MongoDB

F : Cosmos

Answer: E,F

Question 3

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

A : Biometric access systems

B : Database control systems

C : Fire suppression systems

D : Camera systems

E : Key card systems

F : Cooling systems

Answer: C,F

Question 4

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

A : Hierarchical

B : Key-value stores

C : Cloud

D : Object-oriented

Answer: B

Question 5

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?

A : DROP

B : UPDATE

C : DELETE

D : SELECT

Answer: D

Name:	CompTIA Data Systems Certification
Exam Code:	DS0-001
Certification:	CompTIA Data+
Vendor:	CompTIA
Total Questions:	94
Last Updated:	Apr 23, 2024

CompTIA DS0-001