DP-700 Practice Test 8 — 10 Questions

Question 1

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 2

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?

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 3

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 4

Refer to the exhibit. A data engineer applies this configuration to a Microsoft Fabric notebook session. Which statement best describes the impact of this configuration on the analytics solution?

Accepted Answer

It optimizes Delta tables for faster reading, specifically benefiting Direct Lake mode.. V-Order and Optimize Write are Fabric-specific enhancements for Spark that significantly improve read and write performance for Delta tables. V-Order applies a specialized sorting and compression algorithm to Parquet files, making them optimized for the 'Direct Lake' mode in Power BI. Understanding these configurations is vital for building high-performance data lakes that integrate seamlessly with reporting layers.

Answer

It enables encryption at rest for all Parquet files generated in the session.

Answer

It forces the notebook to use a high-concurrency Spark pool for all users.

Answer

It disables the creation of transaction logs to save storage space in OneLake.

Question 5

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 6

You need to perform a complex transformation that involves multiple joins across tables of varying sizes in Fabric. Which tool provides the best balance between performance and ease of use?

Accepted Answer

Fabric Dataflow Gen2.. Dataflows Gen2 are specifically designed for low-code ETL, providing a visual interface that translates into efficient Spark jobs. They handle complex joins and transformations natively, making them ideal for standard data engineering tasks. They abstract the complexity of Spark configuration while providing enough power to manage large-scale data manipulation, making them the superior choice for most transformation scenarios compared to manual coding.

Answer

Microsoft Purview Data Catalog.

Answer

A SQL stored procedure on an on-premises server.

Answer

Azure Data Factory pipeline parameters only.

Question 7

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 8

A large enterprise is organizing its Microsoft Fabric environment. They need to allow a team of developers to create and modify Lakehouses, Warehouses, and Notebooks within a specific workspace. However, the organization's security policy dictates that these developers must not be able to share items or modify the workspace's membership. Which workspace role should you assign to these developers?

Accepted Answer

Contributor. This scenario focuses on the administrative overhead and security implications of workspace management. Assigning the correct role ensures that developers have enough permission to perform their primary duties, such as creating Spark notebooks and Data Pipelines, without granting excessive rights that could lead to unauthorized data sharing or workspace configuration changes that affect the entire project team.

Answer

Admin

Answer

Member

Answer

Viewer

Question 9

A company is using a Fabric F64 capacity. During a period of low activity, the administrator wants to reduce costs. What is the most direct way to stop incurring charges for the Fabric compute resources without deleting the capacity?

Accepted Answer

Pause the capacity in the Azure portal.. Managing Fabric capacity costs is a critical task for administrators. F-SKU capacities offer flexibility that P-SKUs do not, specifically the ability to pause and resume. This allows organizations to align their spending with actual usage patterns, such as shutting down resources during weekends or non-business hours.

Answer

Delete all workspaces associated with the capacity.

Answer

Switch the capacity to a 'Trial' license.

Answer

Remove all users from the Fabric Admin role.

Question 10

You are implementing a security strategy for Microsoft Fabric. You need to ensure that data access is restricted based on sensitivity labels and that these labels persist when data is exported to Excel. Which TWO statements describe the behavior of sensitivity labels in Fabric? (Choose TWO)

Accepted Answer

Labels applied to a semantic model can be automatically inherited by downstream reports.. Sensitivity labels from Microsoft Purview Information Protection are integrated into Fabric to provide end-to-end data governance. These labels help classify data and can apply encryption or watermarks that follow the data even after it leaves the service. Understanding how these labels propagate and protect data is essential for maintaining compliance in a modern analytics solution.

Answer

Sensitivity labels in Fabric only affect the UI color and do not provide protection.

Answer

Labels are only available for Power BI items and cannot be applied to Lakehouses.

Answer

Sensitivity labels automatically delete any data that is older than three years.