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?
- Edit a visual title to Europe and assume it filters source data.
- Use Power Query transformations with explicit type conversion and reusable steps.
- Use a slicer configured with the intended field and report interactions.
- 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?
- Scheduled runs repeat the transformation outside an author's interactive session.
- Separate bursts form distinct sessions after gaps exceed policy.
- Consumers read partitioned event streams with tracked sequence and retention.
- 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?
- Atomicity is an ACID property of relational transactions.
- Database auditing provides evidence while database roles govern permissions.
- SQL authentication and network reachability are separate gates.
- 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?
- Packing many values into one column creates update and search anomalies.
- Treating PostgreSQL as SQL Server may break functions and drivers.
- Relying solely on application checks allows races that create duplicates.
- 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?
- Events are assigned to nonoverlapping fixed-duration windows.
- Trend changes are visible in chronological order.
- A single event can contribute to overlapping eligible windows.
- 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?
- Reconcile known records and expected missing-value rates.
- Check cohort data and alternative explanations for the decline.
- Inspect sample paths and enforce expected object and array types.
- 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?
- Compare duplicates seasonal patterns and cohorts against the spike.
- Review extracted fields against original log samples and error cases.
- Review resource utilization and alert tests on realistic load.
- 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?
- Schema-aware serialization supports interoperability but still requires compatibility planning.
- Structured relational and semi-structured document models solve different shape and access needs.
- Data store suitability depends on workload access patterns not only data types.
- 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?
- Validate measure filter context and refresh timestamp.
- Put a large decorative number on a page and claim it is linked to the dataset.
- Verify Spark job execution and source-to-result reconciliation.
- 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?
- Deploy a Windows VM and claim it automatically becomes Azure SQL Database.
- Choose Azure SQL Database and size the individual database compute tier.
- Use IS NULL or IS NOT NULL and account for unknown values.
- 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?
- Audit records capture intended events and report users cannot change schemas.
- Each permitted pair is represented once and joins list associations.
- Both sides are committed together or no partial change remains.
- 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.