Microsoft DP-700 Übungsprüfungen
Zuletzt aktualisiert am 26.04.2025- Prüfungscode: DP-700
- Prüfungsname: Microsoft Fabric Data Engineer
- Zertifizierungsanbieter: Microsoft
- Zuletzt aktualisiert am: 26.04.2025
HOTSPOT
You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse1 contains the following tables and columns.
You need to denormalize the tables and include the ContractType and StartDate columns in the
Employee table.
The solution must meet the following requirements:
– Ensure that the StartDate column is of the date data type.
– Ensure that all the rows from the Employee table are preserved and include any matching rows from the Contract table.
– Ensure that the result set displays the total number of employees per contract type for all the contract types that have more than two employees.
How should you complete the statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have a Fabric workspace that contains a warehouse named Warehouse1.
You have an on-premises Microsoft SQL Server database named Database1 that is accessed by using an on-premises data gateway.
You need to copy data from Database1 to Warehouse1.
Which item should you use?
- A . a Dataflow Gen1 dataflow
- B . a data pipeline
- C . a KQL queryset
- D . a notebook
HOTSPOT
You have a Fabric workspace.
You are debugging a statement and discover the following issues:
– Sometimes, the statement fails to return all the expected rows.
– The PurchaseDate output column is NOT in the expected format of mmm dd, yy.
You need to resolve the issues. The solution must ensure that the data types of the results are retained. The results can contain blank cells.
How should you complete the statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You need to ensure that usage of the data in the Amazon S3 bucket meets the technical requirements.
What should you do?
- A . Create a workspace identity and enable high concurrency for the notebooks.
- B . Create a shortcut and ensure that caching is disabled for the workspace.
- C . Create a workspace identity and use the identity in a data pipeline.
- D . Create a shortcut and ensure that caching is enabled for the workspace.
You have a Fabric warehouse named DW1. DW1 contains a table that stores sales data and is used by multiple sales representatives.
You plan to implement row-level security (RLS).
You need to ensure that the sales representatives can see only their respective data.
Which warehouse object do you require to implement RLS?
- A . ISTORED PROCEDURE
- B . CONSTRAINT
- C . SCHEMA
- D . FUNCTION
HOTSPOT
You need to recommend a method to populate the POS1 data to the lakehouse medallion layers.
What should you recommend for each layer? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have a Fabric F32 capacity that contains a workspace. The workspace contains a warehouse named DW1 that is modelled by using MD5 hash surrogate keys.
DW1 contains a single fact table that has grown from 200 million rows to 500 million rows during the past year.
You have Microsoft Power BI reports that are based on Direct Lake. The reports show year-over-year values.
Users report that the performance of some of the reports has degraded over time and some visuals show errors.
You need to resolve the performance issues.
The solution must meet the following requirements:
Provide the best query performance.
Minimize operational costs.
Which should you do?
- A . Change the MD5 hash to SHA256.
- B . Increase the capacity.
- C . Enable V-Order
- D . Modify the surrogate keys to use a different data type.
- E . Create views.
You have a Fabric workspace that contains a warehouse named Warehouse1. Data is loaded daily into Warehouse1 by using data pipelines and stored procedures. You discover that the daily data load takes longer than expected.
You need to monitor Warehouse1 to identify the names of users that are actively running queries.
Which view should you use?
- A . sys.dm_exec_connections
- B . sys.dm_exec_requests
- C . queryinsights.long_running_queries
- D . queryinsights.frequently_run_queries
- E . sys.dm_exec_sessions
You have a Fabric workspace that contains a Real-Time Intelligence solution and an eventhouse.
Users report that from OneLake file explorer, they cannot see the data from the eventhouse.
You enable OneLake availability for the eventhouse.
What will be copied to OneLake?
- A . only data added to new databases that are added to the eventhouse
- B . only the existing data in the eventhouse
- C . no data
- D . both new data and existing data in the eventhouse
- E . only new data added to the eventhouse
You have a Fabric workspace that contains a lakehouse named Lakehouse1. Data is ingested into Lakehouse1 as one flat table.
The table contains the following columns.
You plan to load the data into a dimensional model and implement a star schema. From the original flat table, you create two tables named FactSales and DimProduct. You will track changes in DimProduct.
You need to prepare the data.
Which three columns should you include in the DimProduct table? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . Date
- B . ProductName
- C . ProductColor
- D . TransactionID
- E . SalesAmount
- F . ProductID