Sample questions
CompTIA DataSys+ (DS0-001) (DS0-001) practice questions
You are reviewing a deployment plan for a multi-tenant database. To ensure security, you want to ensure that each tenant's data is logically isolated. Which strategy is most effect…
Which TWO of the following scenarios are best suited for using a 'View'?
Which SQL keyword is used to eliminate duplicate values from a query result set?
Which operator is used to search for a pattern in a string column?
Which TWO of the following are common database maintenance tasks?
An application is experiencing deadlocks. Which strategy would effectively reduce the frequency of deadlocks?
Which DML statement is used to update existing records in a database table?
Which TWO of the following are common types of NoSQL databases?
When performing sentiment analysis on customer feedback, which preprocessing step is most critical to ensure words like 'Running' and 'run' are treated as the same base concept?
Which technology provides the best protection against data exfiltration from an on-premises database by a rogue administrator?
To ensure non-repudiation in a database system, what must be captured for every transaction?
When troubleshooting a performance bottleneck in a visualization, which action is most effective if the data source is a large SQL view?
Which THREE of the following SQL aggregate functions are commonly supported in most relational databases?
A database is configured with a high-availability cluster. During a planned maintenance window, you need to fail over to the secondary node manually. Which command or action is use…
Which SQL command is used to add new records to an existing table?
Which database object is specifically designed to enforce referential integrity between two tables?
Which tool provides a graphical interface for managing SQL Server instances, including configuring security and creating maintenance plans?
Which TWO of the following can be used to prevent unauthorized access to sensitive database tables?
What is the primary function of an index in a database?
Which THREE of the following are common types of database backups?
A database is experiencing high I/O wait times on the log drive. What is the most effective configuration change to alleviate this bottleneck?
A database developer needs to combine the results of two different SELECT queries into a single result set. Which operator should be used?
Which THREE of the following are benefits of database indexing?
You are migrating an on-premises Oracle database to Oracle Cloud Infrastructure (OCI) using a tool that requires the least amount of downtime while keeping the source and destinati…