cert
cert-1
cert-2

Pass Microsoft DP-900 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers to Pass the Actual Exam!
30 Days Free Updates, Instant Download!

cert-5
cert-6
DP-900 Exam - Verified By Experts
DP-900 Premium Bundle
$29.98

DP-900 Premium Bundle

$79.99
$109.97
  • Premium File 332 Questions & Answers. Last update: Nov 13, 2026
  • Training Course 32 Video Lectures
  • Study Guide 672 Pages
 
$109.97
$79.99
accept 21 downloads in last 7 days
block-screenshots
Purchase Microsoft DP-900 Exam Training Products Individually
Microsoft DP-900 Premium File
Premium File 332 Q&A
$76.99$69.99
Microsoft DP-900 Video Training Course
Training Course 32 Lectures
$21.99 $19.99
Microsoft DP-900 PDF Study Guide
Study Guide 672 Pages
$21.99 $19.99
Microsoft DP-900 Practice Test 98

Question 970

A sales director wants to filter a report by region interactively. Which choice BEST meets this requirement?

  1. Edit a visual title to Europe and assume it filters source data.
  2. Use Power Query transformations with explicit type conversion and reusable steps.
  3. Use a slicer configured with the intended field and report interactions.
  4. Use OneLake as the shared logical data-lake foundation for supported Fabric workloads.

Explanation

Correct Answer

C:

Slicers provide user-driven data filtering rather than changing source rows.

Incorrect Answers

A:

Edit a visual title to Europe and assume it filters source data. It does not implement Slicer interactive filter. Incorrect interactions can leave some visuals unaffected.

B:

Use Power Query transformations with explicit type conversion and reusable steps. That action primarily handles Power Query shaping transformation; the given requirement is Slicer interactive filter. Slicers provide user-driven data filtering rather than changing source rows.

D:

Use OneLake as the shared logical data-lake foundation for supported Fabric workloads. That action primarily handles Microsoft Fabric OneLake unified storage; the given requirement is Slicer interactive filter. Slicers provide user-driven data filtering rather than changing source rows.

Question 971

Data engineers need repeatable notebooks for a cleansing workflow. After selecting the proper Databricks collaborative notebooks approach, which observation gives the clearest evidence of success?

  1. Scheduled runs repeat the transformation outside an author's interactive session.
  2. Separate bursts form distinct sessions after gaps exceed policy.
  3. Consumers read partitioned event streams with tracked sequence and retention.
  4. Separate reports calculate the same KPI under equivalent filters.

Explanation

Correct Answer

A:

Scheduled runs repeat the transformation outside an author's interactive session. This is the directly observable result for Databricks collaborative notebooks; notebooks can combine code documentation and analytical results but require governed execution.

Incorrect Answers

B:

Separate bursts form distinct sessions after gaps exceed policy. This supports Session windows of event activity, not confirmation of Databricks collaborative notebooks. The relevant evidence is that scheduled runs repeat the transformation outside an author's interactive session.

C:

Consumers read partitioned event streams with tracked sequence and retention. This supports Azure Event Hubs event ingestion, not confirmation of Databricks collaborative notebooks. The relevant evidence is that scheduled runs repeat the transformation outside an author's interactive session.

D:

Separate reports calculate the same KPI under equivalent filters. This supports Semantic model over curated analytics, not confirmation of Databricks collaborative notebooks. The relevant evidence is that scheduled runs repeat the transformation outside an author's interactive session.

Question 972

Security prohibits exposing a managed SQL endpoint to arbitrary public clients. Which principle BEST explains the correct Azure SQL firewall and private endpoint design decision?

  1. Atomicity is an ACID property of relational transactions.
  2. Database auditing provides evidence while database roles govern permissions.
  3. SQL authentication and network reachability are separate gates.
  4. Second normal form removes partial dependencies on a composite key.

Explanation

Correct Answer

C:

SQL authentication and network reachability are separate gates. In this case the applicable decision is to configure supported network access restrictions and private endpoint where appropriate.

Incorrect Answers

A:

Atomicity is an ACID property of relational transactions. That concept explains SQL COMMIT and ROLLBACK transaction; the situation instead concerns Azure SQL firewall and private endpoint. Granting public network access broadly increases exposure regardless of SQL login strength.

B:

Database auditing provides evidence while database roles govern permissions. That concept explains Azure SQL auditing and least privilege; the situation instead concerns Azure SQL firewall and private endpoint. Granting public network access broadly increases exposure regardless of SQL login strength.

D:

Second normal form removes partial dependencies on a composite key. That concept explains Second normal form partial dependency; the situation instead concerns Azure SQL firewall and private endpoint. Granting public network access broadly increases exposure regardless of SQL login strength.

Question 973

A contact table stores several email addresses in one comma-separated column. If the relevant First normal form atomic attributes safeguard is skipped, which failure is MOST directly associated with that omission?

  1. Packing many values into one column creates update and search anomalies.
  2. Treating PostgreSQL as SQL Server may break functions and drivers.
  3. Relying solely on application checks allows races that create duplicates.
  4. Blindly moving instance-specific code to Azure SQL Database can fail.

Explanation

Correct Answer

A:

Packing many values into one column creates update and search anomalies. First normal form favors atomic values in relational columns. A suitable check is to inspect the schema for repeated groups and test individual lookups.

Incorrect Answers

B:

Treating PostgreSQL as SQL Server may break functions and drivers. This failure is associated with Azure Database for PostgreSQL Flexible Server; it is not the primary failure in the stated First normal form atomic attributes scenario. First normal form favors atomic values in relational columns.

C:

Relying solely on application checks allows races that create duplicates. This failure is associated with Unique index versus primary key; it is not the primary failure in the stated First normal form atomic attributes scenario. First normal form favors atomic values in relational columns.

D:

Blindly moving instance-specific code to Azure SQL Database can fail. This failure is associated with Azure SQL Managed Instance compatibility; it is not the primary failure in the stated First normal form atomic attributes scenario. First normal form favors atomic values in relational columns.

Question 974

Operators need a ten-minute rolling total updated every two minutes. After selecting the proper Hopping sliding analytic windows approach, which observation gives the clearest evidence of success?

  1. Events are assigned to nonoverlapping fixed-duration windows.
  2. Trend changes are visible in chronological order.
  3. A single event can contribute to overlapping eligible windows.
  4. Drill-down shows consistent yearly quarterly and monthly slices.

Explanation

Correct Answer

C:

A single event can contribute to overlapping eligible windows. This is the directly observable result for Hopping sliding analytic windows; hopping windows allow overlapping periodic aggregation.

Incorrect Answers

A:

Events are assigned to nonoverlapping fixed-duration windows. This supports Tumbling time windows, not confirmation of Hopping sliding analytic windows. The relevant evidence is that a single event can contribute to overlapping eligible windows.

B:

Trend changes are visible in chronological order. This supports Line chart time-series selection, not confirmation of Hopping sliding analytic windows. The relevant evidence is that a single event can contribute to overlapping eligible windows.

D:

Drill-down shows consistent yearly quarterly and monthly slices. This supports Drill-down hierarchy for time, not confirmation of Hopping sliding analytic windows. The relevant evidence is that a single event can contribute to overlapping eligible windows.

Question 975

Revenue facts contain duplicate event IDs after a replay. What is the MOST appropriate next validation or correction?

  1. Reconcile known records and expected missing-value rates.
  2. Check cohort data and alternative explanations for the decline.
  3. Inspect sample paths and enforce expected object and array types.
  4. Declare a dataset accurate solely because it has millions of rows.

Explanation

Correct Answer

A:

Reconcile known records and expected missing-value rates. This tests the intended result: observed quality metrics identify incomplete or duplicate data before publishing.

Incorrect Answers

B:

Check cohort data and alternative explanations for the decline. It tests Descriptive versus diagnostic analytics rather than the critical Data quality completeness and accuracy behavior. Data quality requires explicit rules tied to business meaning.

C:

Inspect sample paths and enforce expected object and array types. It tests JSON arrays and nested objects rather than the critical Data quality completeness and accuracy behavior. Data quality requires explicit rules tied to business meaning.

D:

Declare a dataset accurate solely because it has millions of rows. This unsafe shortcut leaves the Data quality completeness and accuracy problem unresolved. A pipeline that merely completes does not prove data correctness.

Question 976

A production SQL server reports repeated connection saturation. What is the MOST appropriate next validation or correction?

  1. Compare duplicates seasonal patterns and cohorts against the spike.
  2. Review extracted fields against original log samples and error cases.
  3. Review resource utilization and alert tests on realistic load.
  4. Assume managed service billing automatically supplies incident response.

Explanation

Correct Answer

C:

Review resource utilization and alert tests on realistic load. This tests the intended result: threshold breaches trigger timely investigation before service outage.

Incorrect Answers

A:

Compare duplicates seasonal patterns and cohorts against the spike. It tests Data analyst anomaly interpretation rather than the critical DBA monitoring capacity and alerts behavior. Database operations require health monitoring and capacity planning.

B:

Review extracted fields against original log samples and error cases. It tests Log text extraction versus structured event fields rather than the critical DBA monitoring capacity and alerts behavior. Database operations require health monitoring and capacity planning.

D:

Assume managed service billing automatically supplies incident response. This unsafe shortcut leaves the DBA monitoring capacity and alerts problem unresolved. Ignoring resource trends can cause preventable unavailability.

Question 977

An analytics project organizes large historical files by date and business domain. Which principle BEST explains the correct Azure Data Lake Storage Gen2 analytics landing design decision?

  1. Schema-aware serialization supports interoperability but still requires compatibility planning.
  2. Structured relational and semi-structured document models solve different shape and access needs.
  3. Data store suitability depends on workload access patterns not only data types.
  4. ADLS Gen2 adds data-lake semantics on Azure Blob storage.

Explanation

Correct Answer

D:

ADLS Gen2 adds data-lake semantics on Azure Blob storage. In this case the applicable decision is to use a hierarchical-namespace enabled storage account for data lake file organization.

Incorrect Answers

A:

Schema-aware serialization supports interoperability but still requires compatibility planning. That concept explains Avro schema-aware records; the situation instead concerns Azure Data Lake Storage Gen2 analytics landing. Assuming any flat blob container has identical POSIX-style directory operations can break workflows.

B:

Structured relational and semi-structured document models solve different shape and access needs. That concept explains Relational rows versus document attributes; the situation instead concerns Azure Data Lake Storage Gen2 analytics landing. Assuming any flat blob container has identical POSIX-style directory operations can break workflows.

C:

Data store suitability depends on workload access patterns not only data types. That concept explains Data platform read and write profiles; the situation instead concerns Azure Data Lake Storage Gen2 analytics landing. Assuming any flat blob container has identical POSIX-style directory operations can break workflows.

Question 978

A manager wants a prominent display of current customer satisfaction score. What is the MOST appropriate next validation or correction?

  1. Validate measure filter context and refresh timestamp.
  2. Put a large decorative number on a page and claim it is linked to the dataset.
  3. Verify Spark job execution and source-to-result reconciliation.
  4. Re-run transformations with new sample rows.

Explanation

Correct Answer

A:

Validate measure filter context and refresh timestamp. This tests the intended result: the headline number responds to intended filters and current refresh state.

Incorrect Answers

B:

Put a large decorative number on a page and claim it is linked to the dataset. This unsafe shortcut leaves the KPI card single metric problem unresolved. Showing a stale number without refresh context can mislead.

C:

Verify Spark job execution and source-to-result reconciliation. It tests Azure Databricks Apache Spark processing rather than the critical KPI card single metric behavior. Cards emphasize one important measure rather than complex multivariate trends.

D:

Re-run transformations with new sample rows. It tests Power Query shaping transformation rather than the critical KPI card single metric behavior. Cards emphasize one important measure rather than complex multivariate trends.

Question 979

A small SaaS needs a managed SQL database for each tenant. Which choice BEST meets this requirement?

  1. Deploy a Windows VM and claim it automatically becomes Azure SQL Database.
  2. Choose Azure SQL Database and size the individual database compute tier.
  3. Use IS NULL or IS NOT NULL and account for unknown values.
  4. Evaluate Azure SQL Managed Instance for compatible lift-and-modernize workloads.

Explanation

Correct Answer

B:

Azure SQL Database abstracts most server and engine patch operations.

Incorrect Answers

A:

Deploy a Windows VM and claim it automatically becomes Azure SQL Database. It does not implement Azure SQL Database single database PaaS. Assuming the app's schema is automatically redesigned causes migration surprises.

C:

Use IS NULL or IS NOT NULL and account for unknown values. That action primarily handles NULL and three-valued logic; the given requirement is Azure SQL Database single database PaaS. Azure SQL Database abstracts most server and engine patch operations.

D:

Evaluate Azure SQL Managed Instance for compatible lift-and-modernize workloads. That action primarily handles Azure SQL Managed Instance compatibility; the given requirement is Azure SQL Database single database PaaS. Azure SQL Database abstracts most server and engine patch operations.

Question 980

A transfer debits one balance but crashes before crediting another. After selecting the proper SQL COMMIT and ROLLBACK transaction approach, which observation gives the clearest evidence of success?

  1. Audit records capture intended events and report users cannot change schemas.
  2. Each permitted pair is represented once and joins list associations.
  3. Both sides are committed together or no partial change remains.
  4. Peak tenants borrow capacity while pool-wide utilization stays manageable.

Explanation

Correct Answer

C:

Both sides are committed together or no partial change remains. This is the directly observable result for SQL COMMIT and ROLLBACK transaction; atomicity is an ACID property of relational transactions.

Incorrect Answers

A:

Audit records capture intended events and report users cannot change schemas. This supports Azure SQL auditing and least privilege, not confirmation of SQL COMMIT and ROLLBACK transaction. The relevant evidence is that both sides are committed together or no partial change remains.

B:

Each permitted pair is represented once and joins list associations. This supports Many to many bridge table, not confirmation of SQL COMMIT and ROLLBACK transaction. The relevant evidence is that both sides are committed together or no partial change remains.

D:

Peak tenants borrow capacity while pool-wide utilization stays manageable. This supports Azure SQL elastic pool sharing, not confirmation of SQL COMMIT and ROLLBACK transaction. The relevant evidence is that both sides are committed together or no partial change remains.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests