DP-600 practice questions 51–60

1. Question 51 · 190 in bank

   Select 2

   You have a Fabric tenant that contains a machine learning model registered in a Fabric workspace. You need to use the model to generate predictions by using the PREDICT function in a Fabric notebook. Which two languages can you use to perform model scoring? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.

   • AT-SQL
   • BDAX
   • CSpark SQL
   • DPySpark

   Show answer

   Answer: CD

   Explanation

   https://learn.microsoft.com/en-us/fabric/data-science/tutorial-data-science-batch-scoring ou'll load the test dataset into a spark DataFrame and create an MLFlowTransformer object to generate batch predictions. You can then invoke the PREDICT function using one of following three ways: Transformer API from SynapseML Spark SQL API PySpark user-defined function (UDF)

   Source: Adapted from community discussion — gtc108

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

2. Question 52 · 190 in bank

   HOTSPOT - You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a warehouse named DW1. DW1 contains two tables named Employees and Sales. All users have read access to Dw1. You need to implement access controls to meet the following requirements: • For the Sales table, ensure that the users can see only the sales data from their respective region. • For the Employees table, restrict access to all Personally Identifiable Information (PII). • Maintain access to unrestricted data for all the users. What should you use for each table? 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

   Employees: Column-level security: Column-Level-Security (CLS): https://learn.microsoft.com/en-us/fabric/data-warehouse/column-level-security "allowing you to restrict column access to protect sensitive data..." Sales: Row-Level-Security (RLS): https://learn.microsoft.com/en-us/fabric/data-warehouse/row-level-security "control access to rows in a database table. For example, you can ensure that workers access only those data rows that are pertinent to their department." (or Sales Region in this case)

   Source: Adapted from community discussion — CHZW

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

3. Question 53 · 190 in bank

   You need to create a Microsoft Power BI file that will be used to create multiple reports. The solution must meet the following requirements: • The file must include predefined data source connections. • The file must include the report structure and formatting. • The file must NOT contain any data. Which file format should you use?

   • APBIT
   • BPBIDS
   • CPBIX
   • DPBIP

   Show answer

   Answer: A

   Explanation

   PBIT (Power BI Template File) ✅ Why? A PBIT (Power BI Template file): ✔️ Includes predefined data source connections. ✔️ Includes report structure and formatting. ✔️ Does NOT contain any actual data—only metadata (queries, measures, visual

   Source: Adapted from community discussion — tizian10

   Next question

4. Question 54 · 190 in bank

   You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a single semantic model that has two Microsoft Power BI reports. You have a Microsoft 365 subscription that contains a data loss prevention (DLP) policy named DLP1. You need to apply DLP1 to the items in Workspace1. What should you do?

   • ACreate a workspace identity.
   • BApply a certified endorsement to the semantic model.
   • CApply sensitivity labels to the semantic model and reports.
   • DApply a master data endorsement to the semantic model.

   Show answer

   Answer: C

   References

   • Microsoft Learn

   Next question

5. Question 55 · 190 in bank

   Select 2

   You have a Fabric tenant that contains a workspace named Workspace1 and a user named User1. User1 is assigned the Contributor role for Workspace1. You plan to configure Workspace1 to use an Azure DevOps repository for version control. You need to ensure that User1 can commit items to the repository. Which two settings should you enable for User1? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • AUsers can sync workspace items with GitHub repositories
   • BUsers can create and use Data workflows
   • CUsers can create Fabric items
   • DUsers can synchronize workspace items with their Git repositories

   Show answer

   Answer: CD

   Explanation

   C. Users need to be able to Create Fabric Items to satisfy 'User1 can commit Items to the repository. D. They try to trick you with 'GITHUB'. Azure Devops uses GIT, but GITHUB is different. You want to sync your 'GIT Repositories'. Has nothing to do with GITHUB...

   Source: Adapted from community discussion — testtaker45

   Next question

6. Question 56 · 190 in bank

   You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a data pipeline named Pipeline1 and a lakehouse named Lakehouse1. You perform the following actions: • Create a workspace named Workspace2. • Create a deployment pipeline named DeployPipeline1 that will deploy items from Workspace1 to Workspace2. • Add a folder named Folder1 to Workspace1. • Move Lakehouse1 to Folder1. • Run DeployPipeline1. Which structure will Workspace2 have when DeployPipeline1 is complete?

   • A\Folder1\Pipeline1 \Folder1\Lakehouse1
   • B\Pipeline1 \Lakehouse1
   • C\Pipeline1 \Folder1\Lakehouse1
   • D\Folder1\Lakehouse1

   Show answer

   Answer: C

   Explanation

   Answer: C. \Pipeline1 and \Folder1\Lakehouse1 Reference from Microsoft Documentation: https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/understand-the-deployment-process?tabs=new-ui Under the "Folders in deployment pipelines (preview)" section in the provided text: Folders representation: "Folders are considered part of an item’s name (an item name includes its full path). When an item is deployed, after its path was changed (moved from folder A to folder B, for example), then Deployment pipelines applies this change to its paired item during deployment - the paired item will be moved as well to folder B. If folder B doesn't exist in the stage we're deploying to, it's created in its workspace first."

   Source: Adapted from community discussion — HUSSAIN_ALYAFEI

   References

   • Microsoft Learn

   Next question

7. Question 57 · 190 in bank

   Select 2

   Your company has a finance department. You have a Fabric tenant, an Azure Storage account named storage1, and a Microsoft Entra group named Group1. Group1 contains the users in the finance department. You need to create a new workspace named Workspace1 in the tenant. The solution must meet the following requirements: • Ensure that the finance department users can create and edit items in Workspace1. • Ensure that Workspace1 can securely access storage1 to read and write data. • Ensure that you are the only admin of Workspace1. • Minimize administrative effort. You create Workspace1. Which two actions should you perform next? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • AAssign the Contributor role to Group1.
   • BCreate a workspace identity.
   • CAssign the Admin role to yourself.
   • DAssign the Contributor role to each finance department user.

   Show answer

   Answer: AB

   Explanation

   correct : A. Assign the Contributor role to Group1: Since Group1 already contains all finance department users, assigning the Contributor role to the group grants them the necessary permissions (create and edit items) in Workspace1 with minimal administrative effort. This avoids having to assign roles to each user individually. B. Create a workspace identity: A workspace identity (or managed identity) allows Workspace1 to securely access external resources like storage1. By creating and configuring a workspace identity, you can grant it the appropriate permissions on storage1 for secure read and write access. Additionally, because you created the workspace, you are automatically the admin—meeting the requirement that you are the only admin of Workspace1.

   Source: Adapted from community discussion — Rahalcer

   Next question

8. Question 58 · 190 in bank

   You have a Fabric tenant that contains the workspaces shown in the following table.

   

   You have a deployment pipeline named Pipeline1 that deploys items from Workspace_DEV to Workspace_TEST. In Pipeline1, all items that have matching names are paired. You deploy the contents of Workspace_DEV to Workspace_TEST by using Pipeline1. What will the contents of Workspace_TEST be once the deployment is complete?

   • ALakehouse1 - Lakehouse2 - Notebook1 - Notebook2 - Pipeline1 - SemanticModel1
   • BLakehouse1 - Notebook1 - Pipeline1 - SemanticModel1
   • CLakehouse2 - Notebook2 - SemanticModel1
   • DLakehouse2 - Notebook2 - Pipeline1 - SemanticModel1

   Show answer

   Answer: A

   Explanation

   This is a silly question. In the pipeline, you can copy the contents if desired, from items like Lakehouse1 to Lakehouse2, you could even rename them if you wanted. This is very specific to say the names of the matching items will be paired. I thought this was a strange way of wording it, but when I saw A, I knew what they meant. This is just a trick question. It almost got me...

   Source: Adapted from community discussion — testtaker45

   Next question

9. Question 59 · 190 in bank

   HOTSPOT - You have a Fabric tenant that contains a workspace named Workspace_DEV. Workspace_DEV contains the semantic models shown in the following table.

   

   Workspace_DEV contains the dataflows shown in the following table.

   

   You create a new workspace named Workspace_TEST. You create a deployment pipeline named Pipeline1 to move items from Workspace_DEV to Workspace_TEST. You run Pipeline1. 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

   I am thoroughly confused by this question. I had to use ChatGPT 4o. It says : Yes, No, No. Here is the reasoning: 1. DF1 will be deployed to Workspace_TEST. Reasoning: Dataflows (including Gen1) are deployed to the next workspace during pipeline runs. This includes DF1, but its refresh policy will not be automatically applied. Answer: Yes. 2. Data from Model1 will be deployed to Workspace_TEST. Reasoning: Deployment pipelines do not transfer the data associated with a model. Only the model structure is deployed, and data must be refreshed in the target workspace after deployment. Answer: No. 3. The scheduled refresh policy for Model1 will be deployed to Workspace_TEST. Reasoning: Refresh policies for models are not deployed automatically through deployment pipelines. You need to manually configure refresh policies in the target workspace after deployment. Answer: No. Do with this information what you will. Enjoy -

   Source: Adapted from community discussion — testtaker45

   References

   • Microsoft Learn

   

   Next question

10. Question 60 · 190 in bank

    HOTSPOT - You have a Fabric warehouse that contains two tables named DimDate and Trips. DimDate contains the following fields.

    

    Trips contains the following fields.

    

    You need to compare the average miles per trip for statutory holidays versus non-statutory holidays. 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

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

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