Browse all practice questions for the DP-700 Microsoft Fabric Data Engineer Practice Exam. Search by topic, open any question and review its full explanation, then test yourself in the practice quiz.

DP-700 Microsoft Fabric Data Engineer Practice Exam course image
More practice questions

These questions are part of the practice quiz. Start practicing

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

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy