CompTIA DS0-001 - CompTIA DataSys+ Exam
Page: 3 / 29
Total 144 questions
Question #11 (Topic: Exam A)
A database administrator manages a database server that is running low on disk space. A lot of backup files are stored on the server's disks.
Which of the following is the best action for the administrator to take?
Which of the following is the best action for the administrator to take?
A. Move all the backup files to external disks.
B. Delete all the backup files containing data that is rated as classified.
C. Delete all the backup files that are not required by the backup retention policy.
D. Delete all the backup files except for the most recent one.
Answer: C
Question #12 (Topic: Exam A)
A business analyst is using a client table and an invoice table to create a database view that shows clients who have not made purchases yet. Which of the following joins is most appropriate for the analyst to use to create this database view?
A. INNER JOIN ON Client.Key = Invoice.Key
B. RIGHT JOIN ON Client.Key = Invoice.Key WHERE BY Client.Key IS NULL
C. LEFT JOIN ON Client.Key = Invoice.Key
D. LEFT JOIN ON Client.Key = Invoice.Key WHERE BY Invoice.Key IS NULL
Answer: D
Question #13 (Topic: Exam A)
A database administrator would like to create a table named XYZ. Which of the following queries should the database administrator use to create the table?
A. 
B. 
C. 
D. 
B.
C.
D.
Answer: B
Question #14 (Topic: Exam A)
A database administrator needs to provide access to data from two different tables to multiple group users in order to facilitate ongoing reporting. However, some columns in each table are restricted, and users should not be able to see the values in these columns.
Which of the following is the best action for the administrator to take?
Which of the following is the best action for the administrator to take?
A. Create a stored procedure.
B. Create a view.
C. Create a .csv export.
D. Create a trigger.
Answer: B
Question #15 (Topic: Exam A)
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
