Practice Free DP-600 Exam Online Questions
Which Power BI component is used to integrate and transform data from various data sources?
- A . Power Query
- B . Power Pivot
- C . Power View
- D . Power Map
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.
- A . T-SQL
- B . DAX EC.
- C . Spark SQL
- D . PySpark
C, D
Explanation:
The two languages you can use to perform model scoring in a Fabric notebook using the predict function are Spark SQL (option C) and PySpark (option D). These are both part of the Apache Spark
ecosystem and are supported for machine learning tasks in a Fabric environment.
Reference = You can find more information about model scoring and supported languages in the context of Fabric notebooks in the official documentation on Azure Synapse Analytics.
Which type of data store should you recommend in the AnalyticsPOC workspace?
- A . a data lake
- B . a warehouse
- C . a lakehouse
- D . an external Hive metaStore
C
Explanation:
A lakehouse (C) should be recommended for the AnalyticsPOC workspace. It combines the capabilities of a data warehouse with the flexibility of a data lake. A lakehouse supports semi-structured and unstructured data and allows for T-SQL and Python read access, fulfilling the technical requirements outlined for Litware.
Reference = For further understanding, Microsoft’s documentation on the lakehouse architecture provides insights into how it supports various data types and analytical operations.
What is the primary function of the XMLA endpoint in Microsoft Fabric?
- A . To execute DAX queries
- B . To manage semantic model deployment
- C . To enable data import/export
- D . To provide connectivity between databases
DRAG DROP
You have a Fabric tenant that contains a data warehouse named DW1. DW1 contains a table named DimCustomer.
DimCustomer contains the fields shown in the following table.
You need to identify duplicate email addresses in DimCustomer. The solution must return a maximum of 1,000 records.
Which four T-SQL statements should you run in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.
You have a Microsoft Power B1 Premium Per User (PPU) workspace that contains a semantic model. You have an Azure App Service app named App1 that modifies row-level security (RLS) for the model by using the XMLA endpoint. App1 requires users to sign in by using their Microsoft Entra credentials to access the XMLA endpoint. You need to configure App1 to use a service account to access the model.
What should you do first?
- A . Add a managed identity to the workspace.
- B . Add a managed identity to App1.
- C . Upgrade the workspace to Premium capacity.
- D . Modify the XMLA Endpoint setting.