Free CompTIA DataSys+ Exam DS0-001 Exam Practice Test

Which of the following is used to hide data in a database so the data can only be read by a user who has a key?

• Data security
• Data masking
• Data protection
• Data encryption

Which of the following indexes stores records in a tabular format?

• Columnstore
• Non-clustered
• Unique
• Secondary

A database's daily backup failed. Previous backups were completed successfully. Which of the following should the database administrator examine first to troubleshoot the issue?

• CPU usage
• Disk space
• Event log
• OS performance

A group of developers needs access to a database in a development environment, but the database contains sensitive data. Which of the following should the database administrator do before giving the developers access to the environment?

• Audit access to tables with sensitive data.
• Remove sensitive data from tables
• Mask the sensitive data.
• Encrypt connections to the development environment.

Which of the following tools is used for natively running a Linux system in Windows?

• WSL
• [Remote Desktop Protocol
• SSH
• ITelnet

Which of the following sets the age requirement for data that should be recovered after a major disaster?

• MTBF
• RTO
• MTTF
• RPO

Which of the following best describes the category of SQL commands required to revoke access to database objects?

• DCL
• IDDL
• IDML
• TCL

Which of the following computer services associates IP network addresses with text-based names in order to facilitate identification and connectivity?

• LDAP
• NTP
• DHCP
• IDNS

A database administrator is new to a company and wants to create a document that illustrates the interaction between tables. Which of the following should the administrator create?

• Troubleshooting guide
• Entity relationship diagram
• Data dictionary
• Database reference manual

A database administrator is migrating the information in a legacy table to a newer table. Both tables contain the same columns, and some of the data may overlap.Which of the following SQL commands should the administrator use to ensure that records from the two tables are not duplicated?UNIONJOINIINTERSECTCROSS JOIN

• This command uses the UNION clause to combine the records from the legacy table and the newer table into a single result set. The UNION clause also eliminates any duplicate records that may exist in both tables, and sorts the result by default. The other options either do not produce the desired result or have syntax errors. For example, option B would join the records from the two tables based on a common column, but not remove any duplicates; option C would return only the records that are common to both tables, but not the ones that are unique to each table; option D would produce a Cartesian product of the records from the two tables, which would increase the number of duplicates.