DP-700 Implement and Manage an Analytics Solution Practice Test 3 — 15 Questions

Question 1

You have a Power BI report connected to a Fabric Lakehouse using DirectLake mode. Users report that the data in the report is not reflecting the latest changes made to the Delta tables in the Lakehouse. What should you check first to resolve this?

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

Accepted Answer

The 'Keep your Direct Lake data up to date' setting.. DirectLake mode relies on the semantic model being able to read Delta files directly from OneLake. However, for the model to see updates, it must be synchronized with the latest metadata of the Lakehouse. If 'Keep your Direct Lake data up to date' is disabled, the model will not automatically reflect changes until a refresh is triggered.

Answer

The SQL Analytics Endpoint connection string.

Answer

The Spark cluster's auto-termination settings.

Answer

The V-Order optimization status of the Delta tables.

Question 2

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 3

Your enterprise requires strict compliance tracking for all data pipeline executions inside a Microsoft Fabric workspace. You need to implement a monitoring solution that captures detailed activity logs, pipeline run statuses, and capacity consumption metrics over a 180-day retention period for auditing purposes. What is the most effective native mechanism to achieve this?

Accepted Answer

Configure a diagnostic setting in Azure to stream Fabric workspace logs and capacity metrics to a Log Analytics workspace.. Configuring a diagnostic setting in the Azure portal routes Fabric workspace logs and capacity metrics to an Azure Log Analytics workspace or Azure Storage account. This native integration enables long-term retention beyond the default Fabric limits and provides advanced querying capabilities via Kusto Query Language for rigorous compliance auditing.

Answer

Export the run history manually from the Fabric monitoring hub every thirty days into a shared SharePoint folder.

Answer

Rely solely on the default Fabric monitoring hub retention period to store pipeline execution telemetry.

Answer

Write custom Spark notebooks in a lakehouse to query the internal workspace metadata APIs and append logs to Delta tables daily.

Question 4

You are optimizing a Fabric Warehouse for complex analytical queries involving large fact tables. Which TWO actions should you perform to improve query performance?

Accepted Answer

Implement clustered columnstore indexes on the fact table.. Optimizing warehouse performance requires a combination of effective indexing strategies and data distribution management. By choosing the right clustering columns, you reduce data scanning requirements, while partition pruning ensures the engine only reads relevant segments. These techniques are fundamental for scaling analytical workloads in Microsoft Fabric, as they directly influence the amount of data processed during query execution and help maintain consistent performance under high concurrency.

Answer

Convert all tables to heap structures.

Answer

Increase the number of rows per file to 1 billion.

Answer

Disable statistics collection for all columns.

Question 5

Refer to the exhibit. An engineer receives this error when attempting to trigger a Fabric pipeline. What is the most likely cause?

Accepted Answer

The user lacks the appropriate workspace role.. This error indicates a workspace-level permission issue. In Microsoft Fabric, access is controlled via workspace roles, not just individual item permissions. If the service principal or user lacks the 'Member' or 'Admin' role, they cannot trigger pipelines or manage artifacts within that specific workspace. Understanding role-based access control is vital for securing data pipelines and ensuring that automated processes have the necessary authorization to execute successfully without unauthorized access.

Answer

The pipeline is missing a required input parameter.

Answer

The pipeline capacity is currently paused.

Answer

The pipeline is currently being updated by another user.

Question 6

Which component in Microsoft Fabric is primarily designed for data integration and orchestration of complex workflows?

Accepted Answer

Data Factory. Data Factory in Microsoft Fabric serves as the primary orchestration engine. It enables users to build pipelines that move data, transform it using data flows, and coordinate activities across different storage locations. Understanding the role of Data Factory is foundational for implementing automated data movement, which is a core requirement for building and maintaining robust analytics solutions within the Fabric ecosystem.

Answer

Power BI

Answer

KQL Database

Answer

Notebooks

Question 7

You need to monitor the performance of your Fabric SQL Warehouse. Which tool or feature should you use to identify long-running queries?

Accepted Answer

Fabric Query Insights. Monitoring performance is essential for optimizing query execution and managing resources effectively. In Fabric, the 'Query Insights' feature provides detailed telemetry on query duration, user activity, and resource usage. By identifying long-running queries, data engineers can pinpoint inefficient SQL code or missing indexes, which is vital for maintaining the overall stability and responsiveness of the analytical platform for end-users.

Answer

Azure Monitor Metrics

Answer

Data Factory Pipeline Monitor

Answer

Power BI Performance Analyzer

Question 8

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

Question 9

Your organization requires that all data stored in the Fabric Lakehouse must be encrypted at rest using a customer-managed key (CMK). What is the mandatory step to achieve this?

Accepted Answer

Configure the Fabric capacity to use an Azure Key Vault.. Implementing CMK in Fabric involves integrating with Azure Key Vault to manage the encryption keys. This provides organizations with full control over their data security posture, meeting strict compliance requirements. Understanding the configuration process for CMK is vital for data engineers responsible for enterprise-grade security and governance, as it impacts how the underlying storage and compute layers access protected data assets within the Fabric workspace.

Answer

Enable encryption in the Lakehouse property settings.

Answer

Rotate the encryption keys in the Power BI Admin portal.

Answer

Apply a Data Policy tag to the Lakehouse artifact.

Question 10

Which action must be taken to enable 'Time Travel' functionality on a Delta Lake table in Fabric?

Accepted Answer

Ensure data is stored in Delta format.. Time Travel in Delta Lake is a powerful feature that allows users to query past states of data for auditing or error recovery. It works by retaining history in the transaction log. Understanding how to manage this feature is vital for data engineers who need to ensure data resilience and recover from accidental deletions or corruption events within the production analytics pipeline.

Answer

Configure the 'Retention Period' in the workspace settings.

Answer

Enable the 'Time Travel' flag on the Lakehouse.

Answer

Create a secondary copy of the table manually.

Question 11

You are implementing a security model where users should only see rows matching their assigned department. Which Fabric feature enables this?

Accepted Answer

Row-Level Security (RLS). Row-Level Security (RLS) is essential for ensuring data compliance, especially when sharing reports across different organizational departments. By defining security predicates, data engineers can control access at the record level. This ensures that sensitive data is only accessible to authorized users, which is a fundamental requirement for secure data sharing and analytics governance in Microsoft Fabric.

Answer

Object-Level Security (OLS)

Answer

Workspace Permissions

Answer

Data Masking

Question 12

Which approach is most efficient for loading a large volume of historical data into a Fabric Lakehouse from an external source?

Accepted Answer

Use the Data Factory Copy activity.. Efficient data ingestion is critical for minimizing pipeline duration and cloud compute costs. Using the Copy activity in Data Factory, which is optimized for high-throughput, parallel data transfer, is the industry standard for this task. Understanding how to use the correct integration tools prevents performance bottlenecks and ensures that large-scale data migration projects remain within their performance and budget windows.

Answer

Use a Python script in a notebook to read and write rows one-by-one.

Answer

Download files locally and then upload them to the Fabric portal.

Answer

Create a Power BI report and import the data.

Question 13

When designing an analytics solution, what is the primary purpose of the 'Gold' layer in a Medallion architecture?

Accepted Answer

Providing curated, business-ready data for analytics.. The Medallion architecture is a standard design pattern for data lakes. The Gold layer contains refined, business-level data that is ready for consumption by reports and dashboards. Understanding the stages of the Medallion architecture is essential for data engineers to maintain logical separation between raw ingested data, cleaned data, and final curated datasets, ensuring that analytics solutions remain clean, performant, and reliable for end users.

Answer

Storing raw, unvalidated data from source systems.

Answer

Storing cleaned and deduplicated data for internal engineering use.

Answer

Acting as a temporary sandbox for data exploration.

Question 14

Your organization is implementing a multi-stage development lifecycle in Microsoft Fabric. You need to ensure that when content moves from the 'Test' workspace to the 'Production' workspace, the data source connection automatically switches from the test SQL database to the production SQL database. Which feature should you configure?

Accepted Answer

Deployment pipeline rules. Deployment pipeline rules allow for the dynamic modification of item properties, such as data source connections or parameter values, during the deployment process between stages. This ensures that the production environment remains isolated from development data without requiring manual intervention after every deployment. It is a critical component for maintaining environment parity and reducing manual configuration errors in enterprise analytics.

Answer

Workspace-level sensitivity labels

Answer

OneLake shortcuts

Answer

Git integration branch policies

Question 15

A data engineering team is setting up Git integration for a Microsoft Fabric workspace. They need to ensure that the synchronization process is robust and follows best practices for collaborative development. Which TWO actions should the team perform to successfully manage version control for Fabric items? (Choose TWO)

Accepted Answer

Connect the workspace to an Azure DevOps Git repository and branch.. Git integration in Fabric requires both a connection to a supported remote repository and an understanding of how workspace items are serialized into metadata. Proper synchronization involves committing local workspace changes to the remote branch and managing conflicts through standard Git workflows. This process bridges the gap between low-code workspace editing and professional software development practices for data teams.

Answer

Manually export item .bim files and upload them to a GitHub repository.

Answer

Assign the Workspace Admin role to the Service Principal used for Git.

Answer

Convert all Lakehouses to Warehouses to enable Git compatibility.