Free CompTIA DS0-001 Exam Dumps Questions & Answers

Which of the following commands is part of DDL?

• A.INSERT
• B.UPDATE
• C.CREATE
• D.GRANT

Which of the following concepts applies to situations that require court files to be scanned for permanent reference and original documents be stored for ten years before they can be discarded?

• A.Data loss prevention
• B.Global regulations
• C.Data classification
• D.Data retention policies

Which of the following is recommended in order to provide encrypted data communication pathways for information as it is transmitted over a network?

• A.TCP/IP
• B.TLS
• C.NFS
• D.SMB

An automated script is using common passwords to gain access to a remote system. Which of the following attacks is being performed?

• A.Brute-force
• B.SQL injection
• C.DoS
• D.Phishing

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?

• A.Create a stored procedure.
• B.Create a view.
• C.Create a trigger.
• D.Create a csv export.