DP-600 practice questions 61–70

1. Question 61 · 190 in bank

   HOTSPOT - You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a lakehouse named LH1 and a warehouse named DW1. LH1 contains a table named signindata that is in the dbo schema. You need to create a stored procedure in DW1 that deduplicates the data in the signindata table. How should you complete the T-SQL 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 62 · 190 in bank

   You are analyzing the data in a Fabric notebook. You have a Spark DataFrame assigned to a variable named df. You need to use the Chart view in the notebook to explore the data manually. Which function should you run to make the data available in the Chart view?

   • AdisplayHTML
   • Bshow
   • Cwrite
   • Ddisplay

   Show answer

   Answer: D

   Explanation

   IMHO, the answer is D. Link is here: https://learn.microsoft.com/en-us/fabric/data-engineering/notebook-visualization Point is: You can use the display function on dataframes that created in PySpark and Scala on Spark DataFrames or Resilient Distributed Datasets (RDD) functions to produce the rich dataframe table view and chart view.

   Source: Adapted from community discussion — stilferx

   References

   • Microsoft Learn

   Next question

3. Question 63 · 190 in bank

   HOTSPOT - You have the following T-SQL statement.

   

   For each of the following statements, select Yes if the statement is true. Otherwise, select No. 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

   The 1st question is, will Region values still returned even though they have RefundStatus value of "Refunded". The answer is yes, Regions will still get returned.

   Source: Adapted from community discussion — AngryJack

   

   Next question

4. Question 64 · 190 in bank

   HOTSPOT - You have a Fabric warehouse that contains the following data.

   

   The data has the following characteristics: • Each customer is assigned a unique CustomerID value. • Each customer is associated to a single SalesRegion value. • Each customer is associated to a single CustomerAddress value. • The Customer table contains 5 million rows. • All foreign key values are non-null. You need to create a view to denormalize the data into a customer dimension that contains one row per distinct CustomerID value. The solution must minimize query processing time and resources. How should you complete the T-SQL 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

5. Question 65 · 190 in bank

   You have a query in Microsoft Power BI Desktop that contains two columns named Order_Date and Shipping_Date. You need to create a column that will calculate the number of days between Order_Date and Shipping_Date for each row. Which Power Query function should you use?

   • ADateTime.LocalNow
   • BDuration.Days
   • CDuration.From
   • DDate.AddDays

   Show answer

   Answer: B

   Next question

6. Question 66 · 190 in bank

   You have a Fabric tenant that contains a semantic model. You need to modify object-level security (OLS) for the model. What should you use?

   • Athe Fabric service
   • BMicrosoft Power BI Desktop
   • CALM Toolkit
   • DTabular Editor

   Show answer

   Answer: D

   Next question

7. Question 67 · 190 in bank

   You have a Microsoft Power BI semantic model that contains a measure named TotalSalesAmount. TotalSalesAmount returns a sales revenue amount that is translated into a selected currency. You need to ensure that the value returned by TotalSalesAmount is formatted to use the correct currency symbol. What should you include in the solution?

   • Aa field parameter
   • Ba linguistic schema
   • Ca dynamic format string
   • Dthe WINDOW DAX function

   Show answer

   Answer: C

   Explanation

   To format the value returned by TotalSalesAmount with the correct currency symbol in your semantic model, you can use a dynamic format string in your DAX expression. Dynamic format strings allow you to apply custom formatting based on the context or user selection, such as displaying the appropriate currency symbol.

   Source: Adapted from community discussion — Rataxe

   Next question

8. Question 68 · 190 in bank

   You plan to use Fabric to store data. You need to create a data store that supports the following: • Writing data by using T-SQL • Multi-table transactions • Dynamic data masking Which type of data store should you create?

   • AKQL database
   • Blakehouse
   • Cwarehouse
   • Dsemantic model

   Show answer

   Answer: C

   Explanation

   Other Fabric storage options like Lakehouse or KQL Database do not fully support T-SQL transactions or dynamic data masking. Thus, the best choice for your requirements is a Warehouse in Microsoft Fabric.

   Source: Adapted from community discussion — 4390015

   Next question

9. Question 69 · 190 in bank

   DRAG DROP - You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 uses the Pro license mode and contains a semantic model named Model1. You have an Azure DevOps organization. You need to enable version control for Workspace1. The solution must ensure that Model1 is added to the repository. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

   

   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

   1. Connect Wokspace1 to a Git provider 2. Sync Workspace1 with the repository. 3. Configure branch policies in Azure DevOps Create a deployment pipeline is for CI/CD automation bout not for versioning, Power BI Pro support Git integration so is not necessary a Fabric capacity.

   Source: Adapted from community discussion — b01d700

   

   Next question

10. Question 70 · 190 in bank

    HOTSPOT - You have a Fabric tenant that contains a workspace named Enterprise. Enterprise contains a semantic model named Model1. Model1 contains a date parameter named Date1 that was created in Power Query. You build a deployment pipeline named Enterprise Data that includes two stages named Development and Test. You assign the Enterprise workspace to the Development stage. You need to perform the following actions: • Create a workspace named Enterprise [Test] and assign the workspace to the Test stage. • Configure a rule that will modify the value of Date1 when changes are deployed to the Test stage. Which two settings should you use? To answer, select the appropriate settings in the answer area. NOTE: Each correct answer 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

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

DP-600 practice, question 61. 190 questions available.