DP-700 Microsoft Fabric Data Engineer Practice Exam

These questions are part of the practice quiz. Start practicing

• Which workspace role should a data engineer be assigned if they need to create Fabric items and read all data in an existing lakehouse?
• Which of the following descriptions best fits Delta Lake?
• Which language is optimized for querying real-time data in an eventhouse?
• Which workload experience provides the environment to orchestrate a data flow and prepare Dataflow Gen2?
• Which method is used to split the data across folders when saving a dataframe?
• How can you optimize cost when running Fabric workloads?
• How does Fabric support data governance and metadata management?
• Explain the difference between managedDelta vs external tables in Fabric Lakehouse.
• How do you connect a Fabric lakehouse to Power BI for analytics?
• Which type of table should an insurance company use to store supplier attribute details for aggregating claims?
• Which Eventstream transformation allows you to rename columns?
• Which option best describes the Lakehouse data store in Fabric?
• What is a dataflow in Fabric?
• What is the primary function of Activator in Microsoft Fabric?
• How do you ensure data quality across multiple datasets in a lakehouse?
• What practices support automation, governance, and versioning in a Fabric data engineering project?
• In Fabric, which statement best describes data lineage?
• Which experiences does Fabric Studio provide for data work?
• Which artifacts help enforce external data sharing governance in Fabric?
• Which statement about Lakehouse capabilities is accurate?
• Which statement correctly describes the use of Power Query Online with Dataflow Gen2?
• Which is NOT a benefit of using the Starter Spark Pool in Microsoft Fabric?
• Which statement about data sharing with external partners from Fabric is NOT a recommended practice?
• In lakehouse architecture, which statement best describes the typical roles of Bronze, Silver, and Gold layers?
• What is the primary function of the Monitor hub in Microsoft Fabric?
• What is the purpose of a catalog in data governance within Fabric?
• Which components are essential for end-to-end data governance in Fabric?
• Which of the following tools can be used to apply granular data access permissions in Fabric?
• Time travel in a dataset allows access to historical versions. What is the primary benefit?
• Define observability in Fabric and give examples of telemetry you would collect.
• Which practice best supports data governance in Fabric?
• What is data lineage, and how is it captured in Fabric?
• What is sensitivity labeling, and how does it help protect data in Fabric?
• What is OneLake sharing, and how does it support collaboration?
• What is the purpose of the project operator in KQL (Kusto Query Language) queries?
• What is a Dataflow Gen2?
• Which data store is designed for structured data and analytics workloads in Fabric?
• Which statement correctly lists the four data ingestion options available for Microsoft Fabric data warehousing?
• What happens when a user is granted a permission and then denied the same permission in a warehouse?
• What is a typical data engineering project lifecycle in Fabric from requirements to deployment?
• Which statement best describes an eventhouse in Microsoft Fabric?
• A security team is monitoring a banking transaction system for potential fraud. They need to detect accounts that perform multiple high-value transactions in rapid succession but remain inactive for at least 15 minutes before making another transaction burst. Which windowing function should you use in Evenstream?
• Which Delta Lake feature enables lightning-fast reads for Parquet file formats in Fabric Delta Lake?
• Which statement correctly describes platform-managed keys vs CMEK in Fabric encryption?
• What is a semantic model in the data warehouse experience?
• How can you use notebooks in Fabric for data science work with lakehouse data?
• In Spark Notebooks in Microsoft Fabric, how can you execute a Spark SQL query within a PySpark notebook cell while keeping the language as PySpark?
• What is a key aspect of monitoring best practices?
• How do you design a partitioning strategy for time-series data in Fabric lakehouse?
• What is the simplest way to analyze data in a CSV file using Spark?
• What are best practices for sharing data with external partners from Fabric?
• The requirement is to calculate the average temperature over the last 5 minutes, but only when a new sensor reading arrives. Which windowing function should you use in the Eventstream Group By transformation?
• What is a key benefit of using Microsoft Fabric in data projects?
• Where are lakehouse Delta tables stored?
• Which of the following statements is true about Dataflow Gen2 in Microsoft Fabric?
• Which Fabric tool is primarily used for orchestrating data movement and transformation pipelines?
• What is the effect of deployment pipelines in Fabric?
• Which Fabric experience is used to move and transform data?
• How can you enable users to filter a real-time dashboard interactively?
• What encryption is used in Fabric for data at rest and in transit?
• What is a lakehouse table in Fabric, and how is it typically stored?
• What are two common data ingestion patterns in Fabric, and when would you use them?
• What is a materialized view, and how can it speed up Fabric queries?
• A tool in Real-Time Intelligence in Fabric that can be used to trigger actions on streaming data. For example, a weather sensor might trigger emails when wind thresholds are met.
• Which component uses Power Query Online to transform data in Fabric?
• How do you implement end-to-end data governance in Fabric?
• Which statement describes OneLake's role within Fabric?
• What is time travel in Delta Lake, and how can you use it in Fabric?
• What statement describes tolerant reads in schema drift handling?
• Which option best ensures users always see fresh data in a real-time dashboard?
• Which component is used to visualize and explore real-time data in tiles?
• What is the effect described for VACUUM in Delta Lake?
• Which approach allows referencing an external lakehouse location without copying the data?
• What does Delta Lake provide to ensure consistent read and write operations in a Fabric lakehouse?
• Which of the following best describes Delta Lake in Fabric?
• How would you implement time-based retention in a lakehouse to comply with policy?
• Name typical data sources and connectors you can ingest into Fabric lakehouse.
• Which tool should you use to monitor capacity unit consumption in a Fabric data warehouse?
• Which describes an end-to-end data platform design for a SaaS company in Fabric?
• What is the role of notebooks in governance and reproducibility in Fabric?
• Which component allows you to run Spark notebooks and jobs in Fabric?
• How can you monitor data lineage changes when data pipelines are updated?
• What is order of evaluation of access in Fabric?
• Which view shows details about currently running queries in the data warehouse?
• Which workload experience lets you create a Dataflow Gen2?
• Which statement about partitioning time-series data is NOT part of a good strategy?
• How would you design a lakehouse for a retail analytics scenario (sales, inventory, customers)?
• You want to include data in an external Azure Data Lake Store Gen2 location in your lakehouse, without the requirement to copy the data. What should you do?
• Which feature enforces per-row access control in Fabric by evaluating a condition for each row?
• Which statement about Eventstream is true?
• How should you handle schema drift in a lakehouse pipeline?
• You've loaded a Spark dataframe with data, that you now want to use in a delta table. What format should you use to write the dataframe to storage?
• Which statement describes a characteristic of the Starter Spark Pool in Microsoft Fabric?
• How can you best check how long each individual activity took to complete in a previously run pipeline?
• You want to use a pipeline to copy data to a folder with a specified name for each run. What should you do?
• Which statement best defines capacity in Fabric?
• Which statement best describes the role of Git in Fabric’s CI/CD?
• Which statement about connecting Fabric lakehouse to Power BI is not true?
• To orchestrate a data flow and prepare Dataflow Gen2, which workload is appropriate?
• What is the benefit of using a single, integrated environment in Microsoft Fabric?
• In data warehousing, which table type is optimized for quantitative measurements and analytics?
• What is the recommended minimum file size when working with external data on files in Microsoft Fabric?
• How does Fabric categorize user experiences for data work, and what roles correspond to Data Engineer, Data Scientist, and Data Analyst?
• What is a data pipeline?
• Which option describes creating a reusable parameterized query for a KQL database?
• When would you choose Spark pools vs SQL endpoints in Fabric for data transformation?
• What best describes a Real-Time Intelligence item in Microsoft Fabric?
• Which approach ensures sink tables are updated when applying CDC changes?
• Which of the following is NOT among the four data ingestion options listed for Microsoft Fabric?
• Which query insights view helps identify long-running queries in Fabric?
• You have a managed table based on a folder that contains data files in delta format. If you drop the table, what happens?
• Which statement about Workspaces in Fabric is true?
• What are the core components of Microsoft Fabric's data platform architecture?
• How does Fabric's data catalog facilitate data discovery?
• How can you monitor and troubleshoot data pipelines in Fabric?
• Which format should you write a Spark dataframe to storage when preparing to create a Delta table?
• Which component in Microsoft Fabric is used to trigger downstream processes in response to events?
• What setting in Microsoft Fabric allows multiple notebooks to share the same Spark session?
• Why is indexing important in a data warehouse?
• Which data store in Microsoft Fabric can store raw CSV files?
• Which statement about OneLake sharing is true?
• What data retention strategies are typical in Fabric?
• How do you manage access control lists (ACLs) in OneLake?
• Which statement best describes the role of capacity within Fabric?
• How does Fabric support multi-tenant governance and isolate customer data?
• In the Medallion Architecture, what is the typical purpose of the Silver layer?
• Which action enables interactive Spark exploration of a file in the lakehouse?
• What is the purpose of a fact table in a data warehouse?
• Which of the following sets of layers are typically associated with the Medallion Architecture for data management?
• What is the default storage format for Fabric's OneLake?
• In Fabric data pipelines, how do ETL and ELT differ?
• What is column-level security, and when would you apply it?
• Which statement describes the Fabric lakehouse architecture?
• What is true about the difference between promotion and certification in Fabric?
• What is the primary language used for querying a data warehouse?
• How can you implement row-level security on lakehouse data in Fabric?
• Which dynamic management view provides details about SQL commands running in the data warehouse?
• What is the recommended approach to masking sensitive data when sharing with external parties?
• Which language is optimized for querying real-time data in an eventhouse?
• What access controls should be applied per data asset to secure Fabric assets?
• Which Fabric capability enables external data sharing with policy-based access, data license tagging, and audit trails?
• What is the primary function of deployment pipelines in Fabric?
• You want to use Apache Spark to interactively explore data in a file in the lakehouse. What should you do?
• Delta Lake is described as which of the following?
• Which component is designed to ingest and transform streaming data in Microsoft Fabric Real-Time Intelligence?
• In Fabric, what concept allows referencing schema without binding to a specific provider until read time?
• What are the four data ingestion options available in Microsoft Fabric for loading data into a data warehouse?
• In Fabric Real-Time Intelligence, where can ingested data reside for subsequent analysis?
• Which Delta Lake feature mentioned in the material enables faster reads for Parquet formats in Fabric Delta Lake?
• Which Delta Lake feature reduces the number of files as data is written?
• What are the key differences between Power BI datasets and lakehouse tables in Fabric?
• How should you determine partitioning strategy for a lakehouse table in Fabric?
• How would you implement incremental loads with CDC in Fabric?
• Which statement correctly describes the relationship between Data Factory and Dataflows Gen2 in Fabric?
• What Delta Lake command removes files that are no longer referenced and older than the retention threshold?
• What is a real-time dashboard?
• Which combination best supports governance and access control in Fabric data assets?
• What is the primary advantage of Dynamic Data Masking (DDM)?
• What is the purpose of item permissions in a workspace?
• To connect to and transform data to be loaded into a Fabric lakehouse using Dataflows Gen2, which sequence completes the task?
• How can you create a reusable parameterized query for a KQL database?
• In Real-Time Intelligence in Fabric, which tool is used to trigger actions on streaming data, such as sending alerts when conditions are met?
• Which Fabric component is commonly used for interactive data analysis and experimentation?
• What is the difference between a data catalog and a data dictionary in Fabric?
• In Dataflow Gen2 UI, which component is used to configure the transformations and settings of a query?
• What is a Microsoft Fabric lakehouse?
• Which statement about the Copy Data Activity is true?
• What is OneLake and how does it relate to Fabric Lakehouse storage?
• What element captures data lineage in Fabric?
• Which statement is used to load data into the data warehouse in Microsoft Fabric?
• How would you describe a lakehouse table stored on OneLake enabling BI-friendly SQL with ACID transactions?
• Which of the following is NOT a part of the Dataflow Gen2 UI in Microsoft Fabric?
• What is the purpose of the Fabric Activator destination in an eventstream?
• What is an eventhouse?
• To explore data interactively with Apache Spark in Microsoft Fabric, what should you create?
• What is the benefit of storing different layers of your lakehouse in separate workspaces?
• Which tool is best suited for data transformation in Fabric when dealing with large-scale data that will continue to grow?
• Which Fabric Real-Time Intelligence component should you use to ingest and transform a stream of real-time data?
• What is the purpose of connecting a Fabric workspace to a Git repository?
• What is the purpose of a security predicate function in Row-Level Security (RLS)?
• Which method helps ensure lineage reflects the latest data movement after pipeline updates?
• What are data quality checks, and how are they enforced in Fabric pipelines?
• Which Fabric tool is primarily used for streaming data ingestion?
• What is the recommended approach to versioning datasets in Fabric?
• What is data caching and how does Fabric use caching to improve performance?
• What are the recommended practices for securing data sharing with external customers in Fabric?
• What is the primary function of Microsoft Fabric Eventstreams?
• Which connectors are available for ingestion into Fabric lakehouse?
• What happens when you drop a managed table based on delta format data?
• What is the role of Git in the CI/CD process in Fabric?
• Which view should you use to identify commonly run queries in your data warehouse?
• Which components should you use to manage identities and access to data assets securely in Fabric?
• What are the supported data sources and file formats for the COPY (Transact-SQL) statement in Warehouse?
• What capability do Delta Lake tables provide in Fabric lakehouse?
• What do temporal window transformations enable you to do?