DP-700 Practice Test 1 — 10 Questions

Question 1

You are using Dataflow Gen2 to ingest data from multiple sources. You need to perform a complex transformation that involves merging data from a SQL database and a flat file based on a common key. Which step should you take to achieve this efficiently?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Use the Merge transformation. In Dataflow Gen2, the 'Merge' transformation allows users to join tables from different sources within the Power Query interface. By selecting the common key, you can combine datasets into a single model for downstream processing. This approach is highly efficient as it leverages the underlying mashup engine to perform the heavy lifting, ensuring the transformation is processed in a unified, maintainable data pipeline.

Answer

Write a custom Python script

Answer

Create a temporary SQL view

Answer

Export both to CSV first

Question 2

You are auditing data access in a Microsoft Fabric workspace and notice unexpected 'Access Denied' errors in the OneLake logs for a service principal that should have read-only access. The service principal has the 'Viewer' role in the workspace. What is the most likely cause?

Accepted Answer

OneLake data access control (preview) is restricting specific folders.. OneLake security is governed by both workspace roles and item-level permissions. If 'OneLake data access control' is enabled for a Lakehouse, the 'Viewer' role alone may not be sufficient if specific folder-level permissions have not been granted. Understanding the intersection of these security layers is critical for troubleshooting access issues in complex environments.

Answer

The service principal needs the 'Contributor' role to read data.

Answer

The service principal has exceeded its OneLake throughput quota.

Answer

OneLake does not support service principal authentication.

Question 3

You are managing a Microsoft Fabric capacity. You need to identify which users are consuming the most compute resources and determine if any throttled requests are occurring. Which TWO tools should you use?

Accepted Answer

Fabric Capacity Metrics app. Monitoring capacity health requires a combination of real-time metrics and long-term diagnostic logs. The Fabric Capacity Metrics app provides granular visual insights into capacity utilization and throttling, while the Log Analytics workspace offers detailed diagnostic logs for query-level analysis. Using both tools allows engineers to correlate high-level capacity health with specific user-driven workloads that may trigger system-wide throttling or degradation.

Answer

Microsoft Purview

Answer

Service Health Dashboard

Answer

Power BI Desktop Performance Analyzer

Question 4

You need to quickly identify all failed Data Factory pipeline runs and Spark jobs across multiple workspaces in your Microsoft Fabric environment. Which TWO actions should you perform in the Fabric Monitoring Hub?

Accepted Answer

Apply a filter for the 'Failed' status.. The Fabric Monitoring Hub acts as a centralized dashboard for tracking the health of all activities. It allows users to filter by status and item type across the entire environment. This centralized view is essential for data engineers who need to manage multiple pipelines and notebooks without navigating to each individual workspace to check logs.

Answer

Export the logs to an Azure Log Analytics workspace.

Answer

Schedule a daily refresh for the Monitoring Hub dashboard.

Answer

Configure an alert in the Capacity Metrics app.

Question 5

You are troubleshooting a slow-running Power BI report connected to a Fabric Semantic Model. What is the most effective way to identify the bottleneck?

Accepted Answer

Use the Power BI Performance Analyzer. Performance analysis in Power BI involves tracking how long each visual, DAX query, and storage engine operation takes. By using the Performance Analyzer, you can pinpoint exactly which visual or measure is causing the delay. This allows you to focus on optimizing specific DAX measures or data model relationships rather than guessing, which is vital for maintaining responsive reports in production environments.

Answer

View the workspace storage metrics

Answer

Check the Fabric capacity SKU settings

Answer

Rebuild the semantic model from scratch

Question 6

Refer to the exhibit. You are reviewing the configuration for a Fabric Spark Environment. A job is failing with an 'OutOfMemoryError' during a large shuffle operation. Based on the configuration, which change would most likely resolve the issue?

Accepted Answer

Increase 'spark.executor.memory' to 8g or higher.. OutOfMemoryErrors during shuffle operations often indicate that the executor memory is insufficient for the volume of data being processed per task. While dynamic allocation helps with the number of executors, it does not increase the memory available to each individual executor. Increasing 'spark.executor.memory' provides the necessary headroom for complex joins and aggregations.

Answer

Increase 'spark.dynamicAllocation.maxExecutors' to 20.

Answer

Decrease 'spark.executor.cores' to 1.

Answer

Set 'spark.dynamicAllocation.enabled' to 'false'.

Question 7

Refer to the exhibit. You are reviewing pipeline logs and notice the 429 error. What is the most appropriate long-term action to prevent this?

Accepted Answer

Analyze query patterns and optimize resource-heavy jobs. A 429 error indicates that the request was throttled because the capacity reached its compute limit. While immediate scaling might fix the current issue, long-term stability requires identifying the root cause of the spike in resource usage. Optimizing the code, adjusting concurrency, or smoothing out scheduled job times ensures the capacity operates within its allocated limits without requiring constant upgrades.

Answer

Increase the Fabric capacity SKU immediately

Answer

Configure retry policies with exponential backoff

Answer

Disable monitoring to reduce overhead

Question 8

You manage a Microsoft Fabric workspace containing a critical lakehouse and multiple downstream semantic models. You need to configure item-level permissions to ensure that specific business analysts can refresh the semantic models without being able to view or query the underlying tables in the lakehouse storage. Which permission level should you assign directly to the analysts on the semantic model?

Accepted Answer

Assign Build permission specifically on the semantic model to enable reporting and refresh capabilities.. Assigning the Build permission directly to the semantic model grants users the ability to create new reports based on the model and refresh it if configured, without granting access to the underlying lakehouse tables or workspace artifacts. This principle of least privilege ensures analysts can execute operational refreshes without exposing raw data layers.

Answer

Assign Admin permission on the semantic model to grant full control over the artifact settings and refresh history.

Answer

Assign Contributor permission on the workspace containing the semantic model and the lakehouse storage.

Answer

Assign Write permission on the semantic model to allow data modifications and structural definition updates.

Question 9

Refer to the exhibit. An administrator is reviewing the properties of a Lakehouse via the Fabric REST API. The property 'hasManagedPrivateEndpoint' is set to true. What does this indicate about the security configuration for this specific item?

Accepted Answer

The Lakehouse uses a private link to connect to its underlying data source.. Managed Private Endpoints in Fabric allow for secure communication between Fabric and other Azure services without exposing data to the public internet. This is a key feature for high-security environments. When this property is true, it signifies that the Lakehouse is configured to use a private connection to its data source, enhancing the overall security posture.

Answer

The Lakehouse is only accessible from within a specific Azure VNET.

Answer

The Lakehouse has been shared with an external guest user.

Answer

OneLake shortcuts are disabled for this specific Lakehouse.

Question 10

Refer to the exhibit. Which command would be most effective for improving query performance on this table if you frequently filter by TransDate?

Accepted Answer

OPTIMIZE SalesData ZORDER BY (TransDate). Partitioning or Z-Ordering by a date column is highly effective when queries frequently filter on that specific column. By organizing the data based on the transaction date, the Delta engine can skip large chunks of irrelevant files, significantly reducing the I/O required for queries. This is a critical performance tuning technique in Fabric for handling time-series data efficiently at scale.

Answer

ALTER TABLE SalesData ADD COLUMN Location String

Answer

DROP TABLE SalesData; CREATE TABLE SalesData ... CLUSTER BY (ID)

Answer

VACUUM SalesData