DP-700 practice questions 71–80

1. Question 71 · 116 in bank

   HOTSPOT - You have a Fabric workspace that contains two lakehouses named Lakehouse1 and Lakehouse2. Lakehouse1 contains staging data in a Delta table named Orderlines. Lakehouse2 contains a Type 2 slowly changing dimension (SCD) dimension table named Dim_Customer. You need to build a query that will combine data from Orderlines and Dim_Customer to create a new fact table named Fact_Orders. The new table must meet the following requirements: Enable the analysis of customer orders based on historical attributes. Enable the analysis of customer orders based on the current attributes. How should you complete the statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   

   Next question

2. Question 72 · 116 in bank

   You have a Fabric workspace that contains a lakehouse named Lakehouse1. In an external data source, you have data files that are 500 GB each. A new file is added every day. You need to ingest the data into Lakehouse1 without applying any transformations. The solution must meet the following requirements Trigger the process when a new file is added. Provide the highest throughput. Which type of item should you use to ingest the data?

   • AEventstream
   • BDataflow Gen2
   • CStreaming dataset
   • DData pipeline

   Show answer

   Answer: D

   Explanation

   Eventstream is designed for ingesting real-time or streaming data from sources like IoT devices or logs. It’s not optimized for batch processing or large files.

   Source: Adapted from community discussion — IshtarSQL

   Next question

3. Question 73 · 116 in bank

   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?

   • ACreate views.
   • BModify the surrogate keys to use a different data type.
   • CChange the MD5 hash to SHA256.
   • DIncrease the capacity.
   • EDisable V-Order on the warehouse.

   Show answer

   Answer: D

   Next question

4. Question 74 · 116 in bank

   You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse1. You plan to deploy Warehouse 1 to a new workspace named Workspace2. As part of the deployment process, you need to verify whether Warehouse1 contains invalid references. The solution must minimize development effort and provide detailed information about the invalid references. What should you use?

   • Aa dbt project
   • Ba deployment pipeline
   • Ca Python script
   • Da database project

   Show answer

   Answer: B

   Next question

5. Question 75 · 116 in bank

   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.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   As a european I would not know it has to be 7, we never use that format and I do not know (or want to know) all formats by heart..... try_cast: https://learn.microsoft.com/en-us/sql/t-sql/functions/try-cast-transact-sql?view=sql-server-ver16 convert: https://learn.microsoft.com/en-us/sql/t-sql/functions/cast- and-convert-transact-sql?view=sql-server-ver16

   Source: Adapted from community discussion — 8d6881f

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

6. Question 76 · 116 in bank

   You are developing a data pipeline named Pipeline1. You need to add a Copy data activity that will copy data from a Snowflake data source to a Fabric warehouse. What should you configure?

   • ADegree of copy parallelism
   • BFault tolerance
   • CEnable staging
   • DEnable logging

   Show answer

   Answer: C

   References

   • Microsoft Learn

   Next question

7. Question 77 · 116 in bank

   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 change the join type to kind=outer. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: B

   Explanation

   No. An outer join can be more computationally intensive than an inner join because it needs to process all rows from both tables and include rows that don't have matching entries.

   Source: Adapted from community discussion — GHill1982

   Next question

8. Question 78 · 116 in bank

   You have a Fabric workspace named Workspace1 that is connected to a GitHub repository named repo1. Workspace1 contains the items shown in the following table.

   

   You modify Semanticmodel1, Semanticmodel2, and Report2. You need to commit the changes to repo1. What is the minimum number of commits you should perform?

   • A1
   • B2
   • C3
   • D4

   Show answer

   Answer: B

   Next question

9. Question 79 · 116 in bank

   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 change project to extend. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: B

   Explanation

   No. The `project` operator is used to select specific columns, whereas `extend` is used to add new calculated columns to the result set. They serve different purposes.

   Source: Adapted from community discussion — GHill1982

   Next question

10. Question 80 · 116 in bank

    You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Table1. You need to ensure that a user named User1 can view only specific rows in Table1. What should you do first?

    • ACreate a security predicate.
    • BCreate a function.
    • CCreate a security policy.
    • DGrant User1 the SELECT permission for Table1.

    Show answer

    Answer: B

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DP-700 practice, question 71. 116 questions available.