DataSys+ Practice Test: Can You Pass DS0-001?

1. Which of the following is a NoSQL database model?

Relational

Document-based

Hierarchical

Network

2. What is the primary role of a database administrator in a data systems environment?

Writing application code

Managing database performance, security, backups, and user access

Designing user interfaces

Marketing data products

3. Which SQL aggregate function returns the number of rows that meet a condition?

SUM()

AVG()

COUNT()

MAX()

4. In database systems, what does sharding accomplish?

Encrypts data at rest

Distributes data across multiple servers to improve scalability

Creates backup copies

Compresses file sizes

5. What is a transaction log used for in database management?

Recording user login attempts

Tracking database changes and enabling recovery

Monitoring network traffic

Storing temporary query results

6. Which of the following best describes data quality in the context of data governance?

The speed at which data is processed

The accuracy, completeness, and consistency of data

The physical storage location of databases

The encryption level applied to files

7. What is the primary advantage of using views in a database?

To increase storage capacity

To provide simplified access and enhance security by restricting column visibility

To replace primary keys

To eliminate the need for backups

8. Which backup strategy involves copying only data that has changed since the last backup?

Full backup

Incremental backup

Differential backup

Snapshot backup

9. In SQL, what does the DISTINCT keyword accomplish?

Removes duplicate rows from query results

Sorts results alphabetically

Filters rows based on conditions

Combines multiple tables

10. What does CAP theorem state about distributed databases?

Systems can achieve all three properties: consistency, availability, partition tolerance

Systems can guarantee only two of three properties at any given time

Consistency is always prioritized over availability

Partition tolerance is impossible in distributed systems

11. Which of the following best describes the purpose of data normalization in relational databases?

To increase query execution speed

To reduce data redundancy and improve data integrity

To compress database file size

To enhance user interface design

12. What is the primary purpose of a data warehouse?

To process real-time transactions

To store and analyze historical data for business intelligence

To manage user authentication

To encrypt sensitive files

13. Which normalization form eliminates partial dependencies?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

14. In database design, what does a foreign key establish?

A relationship between two tables

A backup connection to another server

An encryption protocol

A user authentication method

15. Which join type returns only rows that have matching values in both tables?

LEFT JOIN

INNER JOIN

FULL OUTER JOIN

CROSS JOIN

16. What is a primary key in a relational database?

A field that references another table

A unique identifier for each row in a table

An encrypted password field

A temporary storage location

17. Which of the following is a characteristic of ACID properties in database transactions?

Atomicity ensures partial updates are saved

Consistency guarantees the database moves from one valid state to another

Isolation allows concurrent users to modify the same data

Durability permits temporary data storage

18. In the context of data governance, what does data lineage refer to?

The chronological order of data creation

The tracking of data origin, movement, and transformation

The physical location of stored data

The backup schedule for databases

19. Which SQL clause is used to filter rows after the GROUP BY operation has been applied?

WHERE

HAVING

FILTER

AGGREGATE

20. What is the primary function of an index in a database?

To store backup copies of data

To accelerate data retrieval operations

To encrypt sensitive information

To validate user permissions