DS0-001 Practice Test 2 — 10 Questions

Question 1

To ensure non-repudiation in a database system, what must be captured for every transaction?

Accepted Answer

Audit Logs with Unique User IDs. Detailed audit logs including a timestamp, user ID, and the executed command provide the necessary evidence for non-repudiation.

Answer

Server Uptime

Answer

Data Compression

Answer

Database Versioning

Question 2

When troubleshooting a performance bottleneck in a visualization, which action is most effective if the data source is a large SQL view?

Accepted Answer

Materializing the view. Materializing the view (creating a physical table with indexes) or optimizing the view's underlying query is the most effective way to resolve performance issues.

Answer

Changing the chart color

Answer

Increasing the number of filters

Answer

Using a different visualization software

Question 3

Which THREE of the following SQL aggregate functions are commonly supported in most relational databases?

Accepted Answer

SUM. SUM, COUNT, and AVG are fundamental aggregate functions supported across virtually all SQL standards.

Answer

CONCAT

Answer

SUBSTR

Question 4

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 used in a Windows Server Failover Cluster (WSFC) environment?

Accepted Answer

Move-ClusterGroup. In a WSFC environment, the 'Move' command in the Failover Cluster Manager is used to manually move the role (including the database resource) to another node.

Answer

SHUTDOWN WITH NOWAIT

Answer

ALTER SERVER ROLE

Answer

RESTORE DATABASE

Question 5

Which SQL command is used to add new records to an existing table?

Accepted Answer

INSERT. INSERT INTO is the standard command for adding new rows to a database table.

Answer

UPDATE

Answer

SELECT

Answer

ALTER

Question 6

Which database object is specifically designed to enforce referential integrity between two tables?

Accepted Answer

Foreign Key. A Foreign Key constraint is designed to ensure that data in one table matches valid entries in another table, maintaining referential integrity.

Answer

Index

Answer

Primary Key

Answer

Unique Constraint

Question 7

Which tool provides a graphical interface for managing SQL Server instances, including configuring security and creating maintenance plans?

Accepted Answer

SQL Server Management Studio. SQL Server Management Studio (SSMS) is the standard GUI tool for SQL Server management.

Answer

Performance Monitor

Answer

SQL Server Profiler

Answer

SQL Server Configuration Manager

Question 8

Which TWO of the following can be used to prevent unauthorized access to sensitive database tables?

Accepted Answer

Row-level security. Implementing role-based access control (RBAC) and row-level security (RLS) are effective ways to secure access to data.

Answer

Add more CPU cores

Answer

Increase the backup frequency

Answer

Use the sa account

Question 9

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

Accepted Answer

To speed up data retrieval. Indexes are designed to speed up data retrieval by providing a faster lookup mechanism than scanning every row in a table.

Answer

To enforce data encryption

Answer

To reduce disk space usage

Answer

To manage user permissions

Question 10

Which THREE of the following are common types of database backups?

Accepted Answer

Full. Full, differential, and transaction log backups are the standard backup types used in professional database environments.

Answer

Snapshot

Answer

Hardware copy