DP-600 exam

What should you use to implement calculation groups for the Research division semantic models?A . DAX StudioB . Microsoft Power Bl DesktopC . the Power Bl serviceD . Tabular EditorView AnswerAnswer: C

HOTSPOT You have a Fabric tenant. You plan to create a Fabric notebook that will use Spark DataFrames to generate Microsoft Power Bl visuals. You run the following code. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is...

You have a Fabric tenant that contains a Microsoft Power Bl report named Report 1. Report1 includes a Python visual. Data displayed by the visual is grouped automatically and duplicate rows are NOT displayed. You need all rows to appear in the visual. What should you do?A . Reference the...

You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a subfolder named Subfolder1 that contains CSV files. You need to convert the CSV files into the delta format that has V-Order optimization enabled. What should you do from Lakehouse explorer?A . Use the Load to Tables...

You have a Fabric tenant that contains a workspace named Workspace^ Workspacel is assigned to a Fabric capacity. You need to recommend a solution to provide users with the ability to create and publish custom Direct Lake semantic models by using external tools. The solution must follow the principle of...

Topic 3, Misc. Questions You have a Fabric warehouse that contains a table named Staging.Sales. Staging.Sales contains the following columns. You need to write a T-SQL query that will return data for the year 2023 that displays ProductID and ProductName arxl has a summarized Amount that is higher than 10,000....

HOTSPOT You have a Fabric tenant that contains two lakehouses. You are building a dataflow that will combine data from the lakehouses. The applied steps from one of the queries in the dataflow is shown in the following exhibit. Use the drop-down menus to select the answer choice that completes...

You have a Fabric tenant that contains a complex semantic model. The model is based on a star schema and contains many tables, including a fact table named Sales. You need to create a diagram of the model. The diagram must contain only the Sales table and related tables. What...

You have a Fabric tenant that contains 30 CSV files in OneLake. The files are updated daily. You create a Microsoft Power Bl semantic model named Modell that uses the CSV files as a data source. You configure incremental refresh for Model 1 and publish the model to a Premium...

You need to ensure that Contoso can use version control to meet the data analytics requirements and the general requirements. What should you do?A . Store all the semantic models and reports in Data Lake Gen2 storage.B . Modify the settings of the Research workspaces to use a GitHub repository.C...