DP-700 Practice Test 4 — 25 Questions

Question 1

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 2

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 3

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 4

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 5

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.

Question 6

Refer to the exhibit. You are configuring a Dataflow Gen2 to move data. Based on the JSON configuration, what happens if the incoming data contains an extra column not defined in the destination schema?

Accepted Answer

The ingestion process fails.. With schema validation set to 'strict', Dataflow Gen2 enforces a rigid mapping between source and sink schemas. If the incoming data does not match the defined schema exactly, the ingestion process will fail. This configuration is critical for maintaining high data quality and preventing 'schema drift' in downstream analytical tables, ensuring that automated processes do not break due to unexpected changes in the upstream data structure.

Answer

The extra column is automatically dropped.

Answer

The extra column is added to the destination schema.

Answer

The extra column is logged as a warning.

Question 7

Refer to the exhibit. You are using Structured Streaming to ingest data into a Delta table. Why is the checkpoint path required?

Accepted Answer

It stores the offset and state information for fault tolerance.. Checkpointing is essential in Structured Streaming for fault tolerance and exactly-once processing guarantees. It stores the state of the stream, including the offsets of the data processed so far. If a job fails, the checkpoint allows the stream to resume exactly where it left off, preventing data loss or duplication. This is a mandatory component for building reliable streaming pipelines in a production Fabric Lakehouse environment.

Answer

It is used to store the schema definition.

Answer

It increases the throughput of the write operation.

Answer

It is required for overwriting existing tables.

Question 8

You have a Lakehouse in a workspace and want to allow a specific user to query the data using the SQL analytics endpoint, but you do not want them to be able to modify the Lakehouse schema or delete files. Which action should you take?

Accepted Answer

Share the Lakehouse with the user and grant 'Read' and 'ReadData' permissions.. This question explores the granularity of permissions in Microsoft Fabric. Providing access to the SQL analytics endpoint requires specific permissions that differ from the full 'Contributor' access. Understanding how to share items with 'Read' and 'ReadData' permissions is essential for implementing a least-privilege security model.

Answer

Assign the user to the Contributor role in the workspace.

Answer

Grant the user 'Execute' permissions on the workspace capacity.

Answer

Add the user to the 'Member' role and disable 'Share' permissions.

Question 9

A company is using Git integration in Microsoft Fabric to manage their Lakehouse and Report items. They notice that after a developer committed changes to a branch and synced them to the workspace, certain sensitive metadata files are being tracked in the repository. Which file should be modified in the local Git repository to prevent specific Fabric item metadata from being tracked in the future?

Accepted Answer

.gitignore. Git integration in Fabric synchronizes item definitions between the workspace and a Git provider. To manage which files are ignored or tracked, standard Git practices apply. This is essential for preventing the leakage of sensitive internal metadata or temporary files that should not be part of the version control history of the analytics project.

Answer

fabric.config

Answer

.fabricignore

Answer

item.config.json

Question 10

Refer to the exhibit. The Copy activity fails to infer the schema correctly from the source files. What is the most likely cause?

Accepted Answer

The sink type is set to DeltaSink, which requires a pre-defined schema mapping for autoCreate.. The exhibit shows a standard copy activity without a defined dataset mapping or schema definition. When using 'autoCreate' for a Delta sink, Fabric requires a schema definition or an existing mapping to determine column types correctly. Without it, the sink assumes all data is string-based, which often leads to errors when writing to strictly typed Delta tables or results in poor query performance.

Answer

The recursive flag is set to true, causing the sink to attempt to merge multiple schemas.

Answer

AzureBlobFSReadSettings does not support schema inference from delimited files.

Answer

The Copy activity requires an Execute Pipeline activity to initialize the sink.

Question 11

What is the primary function of the 'Validate' activity in a Fabric pipeline?

Accepted Answer

To ensure a dataset exists before a downstream activity runs.. The Validate activity is used to check the existence or completion of a dataset before proceeding to the next step. It is commonly used to ensure that upstream processes have successfully dropped files into a landing zone. This activity prevents downstream failures by ensuring the data is ready and present, providing a reliable orchestration pattern that keeps pipelines running smoothly and predictably in production.

Answer

To verify the data types of columns in a table.

Answer

To perform a checksum verification of file integrity.

Answer

To compile the pipeline and check for syntax errors.

Question 12

You are configuring a Fabric pipeline to perform incremental loads from a source system. Which approach is considered the best practice to track changes efficiently?

Accepted Answer

Use a watermark column for filtering. Using a watermarking column (such as a 'LastModified' timestamp or an incrementing ID) is the standard industry practice for incremental loading. By querying only rows with a value greater than the previous high-water mark, you significantly reduce the amount of data transferred and processed. This approach minimizes source system load and execution time, making it essential for building performant, cost-effective pipelines that handle large-scale data updates over time.

Answer

Truncate and reload the entire dataset every time

Answer

Compare every row using a hash function

Answer

Delete all data older than one month

Question 13

You are designing a data lakehouse architecture. Which file format is recommended for optimal performance in Fabric?

Accepted Answer

Delta Lake. Delta Lake is the gold standard format for Fabric. It is an open-source storage layer that brings ACID transactions to data lakes. It enables high-performance querying and supports time travel, schema evolution, and efficient metadata management. Because Fabric is built on the foundation of Delta Lake, using this format allows you to take advantage of native optimizations, providing superior performance compared to traditional formats like CSV or Parquet alone.

Answer

CSV

Answer

JSON

Answer

Avro

Question 14

Which Fabric feature allows you to monitor the status and history of your data pipeline runs?

Accepted Answer

Fabric Monitoring Hub.. The Monitoring Hub in Fabric provides a centralized view of all pipeline runs, including status, duration, and error logs. It is the primary tool for administrators and engineers to troubleshoot failed jobs, monitor performance, and track the history of data movement. Having this visibility is crucial for maintaining a reliable data platform, as it allows for proactive detection and quick resolution of pipeline failures or performance bottlenecks in your environment.

Answer

Power BI Desktop.

Answer

Microsoft Purview.

Answer

Data Warehouse SQL Query Editor.

Question 15

Refer to the exhibit. You are loading this file into a Lakehouse. You notice that the column headers contain special characters, and the data is failing to load correctly. What should you do?

Accepted Answer

Disable the 'first_row_as_header' setting and use custom schema mapping. When dealing with CSV files, column headers must be compatible with the destination system's naming conventions. Often, special characters in source headers are invalid for column names in the target Lakehouse tables. By sanitizing headers or choosing to skip them and using custom column names, you ensure the load completes successfully. This is a common real-world challenge when integrating data from disparate source systems into a unified analytical Lakehouse.

Answer

Change the file encoding to ASCII

Answer

Increase the pipeline retry count

Answer

Convert the CSV to binary format

Question 16

You are optimizing a Spark Notebook in Fabric that processes large Parquet files. Which TWO actions will improve the performance of data transformations?

Accepted Answer

Enable V-Order on the Delta tables.. Optimizing Spark performance in Fabric involves managing how data is distributed across the cluster and how it is physically stored. Using V-Order ensures that files are optimized for Fabric's compute engines, while proper partitioning prevents data skew and allows for efficient parallel processing across the available Spark nodes in the workspace.

Answer

Increase the 'isSequential' property to True.

Answer

Convert all files to the Avro format for faster reads.

Answer

Disable the Spark 'High Concurrency' mode.

Question 17

You are building a Dataflow Gen2 to ingest a 50 GB CSV file from an Azure Storage account into a Fabric Lakehouse. You want to ensure the ingestion uses the 'Fast Copy' feature. What must you do?

Accepted Answer

Ensure no transformations are used in the Power Query steps.. Fast Copy in Dataflows Gen2 allows for high-throughput data movement by bypassing the Power Query mashup engine for the data movement phase. It requires that the source connector supports it and that no complex transformations are applied within the Power Query steps that would force the engine to process rows individually.

Answer

Enable the 'Allow Schema Evolution' setting in the destination.

Answer

Use a Managed Private Endpoint for the connection.

Answer

Set the destination to 'Append' instead of 'Replace'.

Question 18

You are optimizing the ingestion of a large dataset into a Microsoft Fabric Lakehouse using a Spark Notebook. To ensure optimal query performance for downstream consumers, you want to apply the V-Order optimization and partition the data. Which TWO actions should you take to achieve this?

Accepted Answer

Set the spark.sql.parquet.vorder.enabled configuration to true.. Optimizing data in a Fabric Lakehouse involves both physical file organization and metadata enhancements. V-Order is a Microsoft proprietary optimization that improves read performance for Delta tables by reordering data within Parquet files. Partitioning organizes data into folders based on specific columns, which allows the Spark engine to prune unnecessary data during query execution, significantly reducing I/O.

Answer

Create a shortcut to the data in an Azure Data Lake Storage Gen2 account.

Answer

Convert the files to CSV format before ingestion to reduce overhead.

Answer

Apply a Z-Order index on the primary key column during the write operation.

Question 19

You are configuring a Data Factory Pipeline to perform an incremental load from an Azure SQL Database to a Fabric Warehouse. Which THREE components or features are essential for implementing a watermark-based incremental load? (Choose THREE)

Accepted Answer

A Lookup activity to retrieve the last stored watermark value.. Incremental loading requires tracking the last processed record to avoid re-processing the entire dataset. A watermark-based approach uses a value (like a timestamp or ID) to identify new data. This necessitates a way to store the last watermark, a way to retrieve the new maximum watermark, and a way to filter the source query accordingly.

Answer

A Shortcut to the Azure SQL Database.

Answer

Mirroring for Azure SQL Database.

Question 20

You want to automate the monitoring of your Fabric Capacity and receive a notification on your mobile device whenever the capacity utilization exceeds 90% for more than 15 minutes. Which Microsoft Fabric feature should you use to implement this alert?

Accepted Answer

Data Activator. Data Activator (Reflex) is the built-in tool for monitoring data and taking actions based on specific conditions or triggers. It integrates with Fabric items and can monitor metrics or data patterns, sending alerts to Teams, email, or custom business workflows when thresholds like capacity utilization are breached.

Answer

Azure Service Health

Answer

Power BI Subscription

Answer

OneLake File Explorer