Free CompTIA DataSys+ Exam DS0-001 Exam Practice Test

A database administrator needs to aggregate data from multiple tables in a way that does not impact the original tables, and then provide this information to a department. Which of the following is the best way for the administrator to accomplish this task?

• Create a materialized view.
• Create indexes on those tables
• Create a new database.
• Create a function.

Which of the following is an attack in which an attacker hopes to profit from locking the database software?

• Spear phishing
• Ransomware
• SQL injection
• On-path

A database administrator is concerned about transactions in case the system fails. Which of the following properties addresses this concern?

• Durability
• Isolation
• Atomicity
• Consistency

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

Which of the following should a company develop to ensure preparedness for a fire in a data center?

• Deployment plan
• Backup plan
• Data retention policy
• Disaster recovery plan

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 developer is designing a table that does not have repeated values. Which of the following indexes should the developer use to prevent duplicate values from being inserted?

• Unique
• Single column
• Implicit
• Composite

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

• TCP/IP
• NFS
• SMB
• TLS

Which of the following is a potential issue raised by enterprise database users?

• The need for multiple views or windows into the same database
• The need to manage long transactions
• The need for concurrent access and multiuser updates
• The need to manually transfer records to paper

Which of the following have data manipulation and procedural scripting power? (Choose two.)

• PQL
• PL/SQL
• Advanced
• SQL
• SQL
• T-SQL