DS0-001 Timed Practice Test 3 — 10 Questions

Question 1

An organization is deploying a new MySQL 8.0 database for an order-entry application. The team needs the database to enforce referential integrity so that an order row cannot reference a customer that does not exist. Which deployment step accomplishes this?

10 minute time limit — choose an answer to begin.

Accepted Answer

Create the orders table with an InnoDB FOREIGN KEY constraint referencing the customers table primary key.. Referential integrity is enforced when the child table carries a foreign key that names the parent table and column. The engine then validates every write against the parent and applies the configured action on parent deletion or update. Uniqueness, privileges, and range checks each constrain a different aspect of the data and none of them can detect a reference to a missing customer.

Answer

Add a CHECK constraint on orders.customer_id that verifies the value is greater than zero.

Answer

Grant the application account only SELECT and INSERT privileges on the orders table.

Answer

Create a unique index on the customer_id column of the orders table so duplicate references are impossible.

Question 2

What is the first step in a Data Governance program?

Accepted Answer

Data Classification and Inventory. A Data Governance program must begin with understanding what data exists, where it resides, and how sensitive it is — this is achieved through Data Classification and Inventory. Without knowing the data landscape, you cannot define policies, roles, or controls. Classification (e.g., public, internal, confidential, restricted) drives the governance rules that follow.

Answer

Hiring a network engineer

Answer

Writing SQL queries

Answer

Purchasing storage hardware

Question 3

Before finalizing a database deployment, the team must ensure high availability. Which configuration allows for automatic failover to a standby server with zero data loss in a SQL Server environment?

Accepted Answer

Synchronous-commit Availability Group. A Synchronous-commit Availability Group in SQL Server ensures zero data loss by committing transactions on the primary replica only after they are hardened on at least one synchronous secondary replica. This provides automatic failover with no data loss, meeting the high availability requirement. It is the correct choice for zero data loss with automatic failover.

Answer

Database Mirroring in High Performance mode

Answer

Log Shipping

Answer

Asynchronous-commit Availability Group

Question 4

In the context of data quality, what does 'Completeness' refer to?

Accepted Answer

The absence of missing values. In data quality, Completeness refers to the degree to which all required data values are present — i.e., the absence of missing values in a dataset. It measures whether records have all expected attributes populated, not whether those values are correct or consistent.

Answer

The consistency of data across sources

Answer

The timeliness of the data

Answer

The accuracy of values

Question 5

When using Python's 'Matplotlib' library, which function is used to add a new figure to the canvas?

Accepted Answer

plt.figure(). In Matplotlib, the plt.figure() function is used to create a new figure object, which serves as the canvas for plotting. Calling plt.figure() adds a new figure to the current pyplot state and returns a Figure instance that can be populated with axes and plots. Without calling plt.figure(), plotting functions like plt.plot() will draw on the current figure, or create one implicitly if none exists.

Answer

plt.axis()

Answer

plt.plot()

Answer

plt.show()

Question 6

A company is planning to migrate a legacy on-premises database to the cloud. Which assessment should be conducted to ensure the application compatibility with the target managed database service?

Accepted Answer

Database compatibility assessment. A database compatibility assessment evaluates whether the legacy database's schema, data types, stored procedures, triggers, and application dependencies will work on the target managed service. Managed cloud databases often lack certain features (e.g., SQL Server Agent, cross-database queries, CLR, or specific system stored procedures), so this assessment identifies incompatibilities before migration and informs remediation planning.

Answer

Network throughput analysis

Answer

Capacity planning report

Answer

Data integrity audit

Question 7

You are deploying a database that requires compliance with FIPS 140-2. What must be configured to ensure the database meets this security standard?

Accepted Answer

FIPS-mode encryption. FIPS 140-2 is a U.S. government standard for cryptographic modules, so compliance requires that the database use FIPS-validated cryptographic modules — typically enabled via a FIPS mode setting that forces all encryption operations through validated algorithms and libraries. Without FIPS-mode encryption, the database may use non-validated ciphers even if encryption is otherwise enabled.

Answer

Database hardening scripts

Answer

User password rotation policies

Answer

Multi-factor authentication (MFA)

Question 8

Which database backup strategy is recommended to ensure that you can restore a database to a specific point in time?

Accepted Answer

Full and Transaction Log backups. Point-in-time recovery requires a full backup as the base plus a continuous chain of transaction log backups. Restoring the full backup and then replaying transaction logs up to a specific timestamp (STOPAT) reconstructs the database to any moment within the log chain's coverage.

Answer

Differential backups only

Answer

Full backups only

Answer

Copy-only backups

Question 9

An administrator needs to restrict access to a specific S3 bucket so that only the Finance team can view files. Which configuration is the most effective approach?

Accepted Answer

Configure an S3 Bucket Policy. An S3 Bucket Policy is a resource-based IAM policy attached directly to the bucket that defines who can access it and under what conditions. By specifying the Finance team's IAM principals and granting only them s3:GetObject permissions, the administrator can effectively restrict access to the bucket.

Answer

Update the VPC Route Table

Answer

Enable Public Access Block

Answer

Enable S3 Versioning

Question 10

A cloud data platform team must prove to auditors that only approved personnel accessed a regulated dataset during a specific incident window. The platform uses role-based access control and stores query history in the warehouse. Which evidence source most directly demonstrates authorized access during that window?

Accepted Answer

The warehouse access history and query logs filtered to the dataset and incident window, correlated with role grants.. Auditors need object-level access evidence tied to identities and time. Warehouse access history and query logs filtered to the dataset and incident window, correlated with the role grants in effect, show exactly which principals read the regulated data and whether each read was authorized, which is the most direct and defensible proof.

Answer

The change management tickets approved during the incident window for the platform team.

Answer

The data catalog's lineage graph showing which downstream reports consume the regulated dataset.

Answer

The identity provider's sign-in logs showing which users authenticated and from which IP addresses.