Practice Free DP-700 Exam Online Questions
What should you do to optimize the query experience for the business users?
- A . Enable V-Order.
- B . Create and update statistics.
- C . Run the VACUUM command.
- D . Introduce primary keys.
You have an Azure SQL database named DB1. The data in DB1 is appended daily.
You have a Fabric workspace named Workspace1 that contains a semanlk model named Model!. Modell is sourced from DB1. You need to configure Model1 to refresh only new and changed data during scheduled refreshes.
What should you do?
- A . In Model1, manually partition large tables by using monthly partitions.
- B . For Model1, change storage mode to Import
- C . From Power Query, define the RangeStart and RangeEnd parameters and filter table rows by using the parameters.
- D . For Workspace1, select Large semantic model storage format
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
- C . Modify the surrogate keys to use a different data type.
- D . Create views.
HOTSPOT
You are building a data orchestration pattern by using a Fabric data pipeline named Dynamic Data Copy as shown in the exhibit. (Click the Exhibit tab.)
Dynamic Data Copy does NOT use parametrization.
You need to configure the ForEach activity to receive the list of tables to be copied.
How should you complete the pipeline expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a KQL database that contains two tables named Stream and Reference. Stream contains streaming data in the following format.
Reference contains reference data in the following format.
Both tables contain millions of rows.
You have the following KQL queryset.
You need to reduce how long it takes to run the KQL queryset.
Solution: You add the make_list() function to the output columns.
Does this meet the goal?
- A . Yes
- B . No
You have a Fabric workspace that contains an eventstream named EventStream1. EventStream1 outputs events to a table in a lakehouse.
You need to remove files that are older than seven days and are no longer in use.
Which command should you run?
- A . VACUUM
- B . COMPUTE
- C . OPTIMIZE
- D . CLONE
You need to create a workflow for the new book cover images.
Which two components should you include in the workflow? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . a notebook that uses Apache Spark Structured Streaming
- B . a time-based schedule
- C . an activator item
- D . a data pipeline
- E . a streaming dataflow
- F . a blob storage action
You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse1.
You plan to deploy Warehouse1 to a new workspace named Workspace2.
As part of the deployment process, you need to verify whether Warehouse1 contains invalid Reference. The solution must minimize development effort.
What should you use?
- A . a database project
- B . a deployment pipeline
- C . a Python script
- D . a T-SQL script
HOTSPOT
You are building a data loading pattern for Fabric notebook workloads.
You have the following code segment:
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta table named Table1.
You analyze Table1 and discover that Table1 contains 2,000 Parquet files of 1 MB each.
You need to minimize how long it takes to query Table1.
What should you do?
- A . Disable V-Order and run the OPTIMIZE command.
- B . Disable V-Order and run the VACUUM command.
- C . Run the OPTIMIZE and VACUUM commands.