Microsoft DP-900 Practice Test 76
Question 750
Fraud investigators need to follow relationships between accounts and devices. If the relevant Cosmos DB API for Apache Gremlin graph safeguard is skipped, which failure is MOST directly associated with that omission?
- Choosing serverless without checking workload scale constraints may be costly.
- Flattening graph traversal into independent key point reads may be awkward.
- Only replicating the latest share state may not recover accidental overwrites.
- Treating LRS as automatic cross-region replication can leave regional exposure.
Explanation
Correct Answer
B:Flattening graph traversal into independent key point reads may be awkward. Gremlin API models relationships as vertices and edges. A suitable check is to test multi-edge routes and direction filters on sample graph.
Incorrect Answers
A:Choosing serverless without checking workload scale constraints may be costly. This failure is associated with Cosmos DB serverless versus provisioned throughput; it is not the primary failure in the stated Cosmos DB API for Apache Gremlin graph scenario. Gremlin API models relationships as vertices and edges.
C:Only replicating the latest share state may not recover accidental overwrites. This failure is associated with Azure Files snapshots and backups; it is not the primary failure in the stated Cosmos DB API for Apache Gremlin graph scenario. Gremlin API models relationships as vertices and edges.
D:Treating LRS as automatic cross-region replication can leave regional exposure. This failure is associated with Azure Storage LRS ZRS GRS distinctions; it is not the primary failure in the stated Cosmos DB API for Apache Gremlin graph scenario. Gremlin API models relationships as vertices and edges.
Question 751
A migration keeps an existing shared folder API without rewriting apps for object endpoints. Which principle BEST explains the correct Azure Files SMB shared directories design decision?
- Analytical history and mutable operational attributes have different retention semantics.
- OLTP emphasizes short consistent transactions whereas OLAP emphasizes aggregated analytical reads.
- ELT shifts transformation to the destination processing platform.
- Azure Files exposes managed file shares distinct from Blob REST object storage.
Explanation
Correct Answer
D:Azure Files exposes managed file shares distinct from Blob REST object storage. In this case the applicable decision is to use Azure Files shares with suitable SMB access and identity configuration.
Incorrect Answers
A:Analytical history and mutable operational attributes have different retention semantics. That concept explains Historical dimensions versus current operational truth; the situation instead concerns Azure Files SMB shared directories. Choosing only Blob REST storage breaks an application requiring SMB file operations.
B:OLTP emphasizes short consistent transactions whereas OLAP emphasizes aggregated analytical reads. That concept explains OLTP relational versus OLAP analytical store; the situation instead concerns Azure Files SMB shared directories. Choosing only Blob REST storage breaks an application requiring SMB file operations.
C:ELT shifts transformation to the destination processing platform. That concept explains ELT load then transform in engine; the situation instead concerns Azure Files SMB shared directories. Choosing only Blob REST storage breaks an application requiring SMB file operations.
Question 752
Analysts need a workflow when a real-time condition persists. Select TWO statements that correctly describe the Fabric Activator rule-triggered action implementation and how it can be verified.
- Separate raw bronze validated silver and curated gold layers with lineage.
- The configured alert fires only for matching test conditions.
- Configure Fabric Activator rules over a supported event or query signal.
- Name a dashboard Alert and assume it sends notifications without an Activator rule.
- Use inactivity-based session windows to group related event sequences.
Explanation
Correct Answers
B:The configured alert fires only for matching test conditions. This is directly observable success evidence for Fabric Activator rule-triggered action.
C:Configure Fabric Activator rules over a supported event or query signal. This is an appropriate action for the Fabric Activator rule-triggered action case. Activator turns detected data conditions into governed actions.
Incorrect Answers
A:Separate raw bronze validated silver and curated gold layers with lineage. This implements Bronze silver gold medallion design instead of the required Fabric Activator rule-triggered action function. Activator turns detected data conditions into governed actions.
D:Name a dashboard Alert and assume it sends notifications without an Activator rule. This is not a safe or appropriate Fabric Activator rule-triggered action implementation. Without a rule/action connection monitoring does not imply automatic response.
E:Use inactivity-based session windows to group related event sequences. This implements Session windows of event activity instead of the required Fabric Activator rule-triggered action function. Activator turns detected data conditions into governed actions.
Question 753
A bursty shopping app receives HTTP 429 from Cosmos DB. Which choice BEST meets this requirement?
- Choose access tiers based on expected retrieval latency transaction costs and retention.
- Treat every 429 as proof that the user password is invalid.
- Use a supported retry-after/backoff strategy and scale throughput if justified.
- Configure supported time to live settings for eligible items or containers.
Explanation
Correct Answer
C:Request-rate limits protect provisioned throughput and require graceful client handling.
Incorrect Answers
A:Choose access tiers based on expected retrieval latency transaction costs and retention. That action primarily handles Hot cool cold and archive blob tiers; the given requirement is Cosmos DB 429 throttling retries. Request-rate limits protect provisioned throughput and require graceful client handling.
B:Treat every 429 as proof that the user password is invalid. It does not implement Cosmos DB 429 throttling retries. Immediate unbounded retries can increase pressure and latency.
D:Configure supported time to live settings for eligible items or containers. That action primarily handles Cosmos DB TTL document expiration; the given requirement is Cosmos DB 429 throttling retries. Request-rate limits protect provisioned throughput and require graceful client handling.
Question 754
A report shows part-to-whole shares for a small set of groups. Select TWO statements that correctly describe the Pie donut chart proportion caution implementation and how it can be verified.
- Slices sum to the intended whole and readers can compare shares.
- Use a pie chart to display overlapping groups that together exceed the whole.
- Use a pie or donut only when meaningful proportions have few categories.
- Apply staged ETL validation and standardization ahead of curated storage.
- Use Power Query transformations with explicit type conversion and reusable steps.
Explanation
Correct Answers
A:Slices sum to the intended whole and readers can compare shares. This is directly observable success evidence for Pie donut chart proportion caution.
C:Use a pie or donut only when meaningful proportions have few categories. This is an appropriate action for the Pie donut chart proportion caution case. Pie-like charts express part-to-whole composition.
Incorrect Answers
B:Use a pie chart to display overlapping groups that together exceed the whole. This is not a safe or appropriate Pie donut chart proportion caution implementation. Many similar tiny slices make comparisons difficult.
D:Apply staged ETL validation and standardization ahead of curated storage. This implements Batch ETL staging and cleansing instead of the required Pie donut chart proportion caution function. Pie-like charts express part-to-whole composition.
E:Use Power Query transformations with explicit type conversion and reusable steps. This implements Power Query shaping transformation instead of the required Pie donut chart proportion caution function. Pie-like charts express part-to-whole composition.
Question 755
A client must upload a file without receiving the storage account key. Which principle BEST explains the correct Blob SAS delegated access design decision?
- Append blobs optimize appending data rather than random page modification.
- Cassandra API exposes a compatible wide-column model distinct from document NoSQL.
- Cosmos DB consistency levels trade freshness availability latency and throughput.
- Shared access signatures grant bounded access without broad permanent account credentials.
Explanation
Correct Answer
D:Shared access signatures grant bounded access without broad permanent account credentials. In this case the applicable decision is to issue a limited SAS or supported delegated access scoped by operation resource and expiry.
Incorrect Answers
A:Append blobs optimize appending data rather than random page modification. That concept explains Append blob sequential logging; the situation instead concerns Blob SAS delegated access. Overly long or permissive SAS tokens expose data if forwarded.
B:Cassandra API exposes a compatible wide-column model distinct from document NoSQL. That concept explains Cosmos DB API for Apache Cassandra; the situation instead concerns Blob SAS delegated access. Overly long or permissive SAS tokens expose data if forwarded.
C:Cosmos DB consistency levels trade freshness availability latency and throughput. That concept explains Cosmos DB consistency choices; the situation instead concerns Blob SAS delegated access. Overly long or permissive SAS tokens expose data if forwarded.
Question 756
A workload requires custom OS access unlike another fully managed database. If the relevant SQL deployment choice by control plane safeguard is skipped, which failure is MOST directly associated with that omission?
- Filtering individual rows cannot replace a condition on group totals.
- Selecting PaaS for unsupported low-level dependencies breaks the app.
- Logging without access control still permits overprivileged changes.
- Relying solely on application checks allows races that create duplicates.
Explanation
Correct Answer
B:Selecting PaaS for unsupported low-level dependencies breaks the app. Deployment models trade managed convenience for operating-system and instance control. A suitable check is to map required features to each documented service model.
Incorrect Answers
A:Filtering individual rows cannot replace a condition on group totals. This failure is associated with SQL HAVING after grouping; it is not the primary failure in the stated SQL deployment choice by control plane scenario. Deployment models trade managed convenience for operating-system and instance control.
C:Logging without access control still permits overprivileged changes. This failure is associated with Azure SQL auditing and least privilege; it is not the primary failure in the stated SQL deployment choice by control plane scenario. Deployment models trade managed convenience for operating-system and instance control.
D: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 SQL deployment choice by control plane scenario. Deployment models trade managed convenience for operating-system and instance control.
Question 757
An ingest activity must finish before a transform notebook starts. Which choice BEST meets this requirement?
- Use a calculated column for row-derived stored values and a measure for dynamic aggregations.
- Set three tasks to 01:00 and claim they automatically wait for one another.
- Use Fabric Data Factory pipelines with ordered activities and retry/error handling.
- Define fact grain and descriptive dimension keys before analytical modelling.
Explanation
Correct Answer
C:Use Fabric Data Factory pipelines with ordered activities and retry/error handling. Orchestration manages data movement and execution dependencies. In the stated case, verification should show that dependency stages run in the intended order and failures are visible.
Incorrect Answers
A:Use a calculated column for row-derived stored values and a measure for dynamic aggregations. That action primarily handles DAX calculated column versus measure; the given requirement is Fabric Data Factory pipeline orchestration. Orchestration manages data movement and execution dependencies.
B:Set three tasks to 01:00 and claim they automatically wait for one another. It does not implement Fabric Data Factory pipeline orchestration. Starting every activity simultaneously may publish partial outputs.
D:Define fact grain and descriptive dimension keys before analytical modelling. That action primarily handles Analytical fact and dimension grain; the given requirement is Fabric Data Factory pipeline orchestration. Orchestration manages data movement and execution dependencies.
Question 758
A team builds separate SQL calculations for every visual and gets mismatched results. Which principle BEST explains the correct Semantic model over curated analytics design decision?
- Power Query-based dataflows provide reusable low-code preparation of data.
- Power Query handles data acquisition and shaping before semantic modeling.
- Scatter charts show relationships between two quantitative variables.
- Semantic modeling makes reusable business meanings above source tables.
Explanation
Correct Answer
D:Semantic modeling makes reusable business meanings above source tables. In this case the applicable decision is to publish a governed semantic model with shared dimensions and measures.
Incorrect Answers
A:Power Query-based dataflows provide reusable low-code preparation of data. That concept explains Fabric Dataflow Gen2 transformations; the situation instead concerns Semantic model over curated analytics. Duplicated ad hoc measures create contradictory dashboards.
B:Power Query handles data acquisition and shaping before semantic modeling. That concept explains Power Query shaping transformation; the situation instead concerns Semantic model over curated analytics. Duplicated ad hoc measures create contradictory dashboards.
C:Scatter charts show relationships between two quantitative variables. That concept explains Scatter chart relationship; the situation instead concerns Semantic model over curated analytics. Duplicated ad hoc measures create contradictory dashboards.
Question 759
A business wants disposable exports deleted automatically after approved retention. During testing, the team observes this specific failure: A broad delete condition may remove records under legal hold. Which corrective check should be performed FIRST?
- Denormalize bounded related data for common access and reference independent unbounded entities.
- Rename a container Old and assume object lifecycle transitions begin.
- Check rule filters and retention interaction before enabling.
- Select an appropriate redundancy option based on local zone and regional failure requirements.
Explanation
Correct Answer
C:Check rule filters and retention interaction before enabling. A successful correction should demonstrate that test objects change tier or expire according to the approved rule.
Incorrect Answers
A:Denormalize bounded related data for common access and reference independent unbounded entities. It serves Cosmos DB document embedded versus referenced data, not the diagnosed Blob lifecycle management rules problem. A broad delete condition may remove records under legal hold.
B:Rename a container Old and assume object lifecycle transitions begin. This reinforces the error rather than addressing the Blob lifecycle management rules failure. Lifecycle management automates object policy based on supported filters and timing.
D:Select an appropriate redundancy option based on local zone and regional failure requirements. It serves Azure Storage LRS ZRS GRS distinctions, not the diagnosed Blob lifecycle management rules problem. A broad delete condition may remove records under legal hold.
Question 760
Two workspaces need a shared reference rather than repeated manual copies. Which principle BEST explains the correct OneLake shortcut referencing existing data design decision?
- Shortcuts reference data locations and do not necessarily copy the bytes.
- Facts record events/measures while dimensions describe entities and context.
- Tumbling windows have contiguous nonoverlapping time intervals.
- Real-time anomalies require context quality and sensitivity tuning.
Explanation
Correct Answer
A:Shortcuts reference data locations and do not necessarily copy the bytes. In this case the applicable decision is to configure an eligible OneLake shortcut and access to its target.
Incorrect Answers
B:Facts record events/measures while dimensions describe entities and context. That concept explains Analytical fact and dimension grain; the situation instead concerns OneLake shortcut referencing existing data. Revoking source permissions may break dependent analyses.
C:Tumbling windows have contiguous nonoverlapping time intervals. That concept explains Tumbling time windows; the situation instead concerns OneLake shortcut referencing existing data. Revoking source permissions may break dependent analyses.
D:Real-time anomalies require context quality and sensitivity tuning. That concept explains Streaming anomaly detection and false positives; the situation instead concerns OneLake shortcut referencing existing data. Revoking source permissions may break dependent analyses.