- All Exams Instant Download
What are two ways to achieve the goal?
You need to implement the date dimension in the data store. The solution must meet the technical requirements. What are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.A . Populate the date dimension table by using a...
Which type of data store should you recommend in the AnalyticsPOC workspace?
Which type of data store should you recommend in the AnalyticsPOC workspace?A . a data lakeB . a warehouseC . a lakehouseD . an external Hive metaStoreView AnswerAnswer: C Explanation: A lakehouse (C) should be recommended for the AnalyticsPOC workspace. It combines the capabilities of a data warehouse with the...
What will you be able to do after connecting to Lakehouse1?
You are the administrator of a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables: • Table1: A Delta table created by using a shortcut • Table2: An external table created by using Spark • Table3: A managed table You plan to connect to Lakehouse1 by...
Which query should you use?
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. Which query should you...
What should you use from Microsoft Power Bl Desktop?
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...
What should you do?
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...
What should be modified first?
You have a Fabric tenant named Tenant1 that contains a workspace named WS1. WS1 uses a capacity named C1 and contains a dawset named DS1. You need to ensure read-write access to DS1 is available by using the XMLA endpoint. What should be modified first?A . the DS1 settingsB ....
Which function should you include in the step?
You have a Fabric tenant that contains a warehouse. You use a dataflow to load a new dataset from OneLake to the warehouse. You need to add a Power Query step to identify the maximum values for the numeric columns. Which function should you include in the step?A . Table....
Which function should you run to make the data available in the Chart view?
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?A ....
How should you complete the T-SQL statement?
HOTSPOT You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains three schemas named schemaA, schemaB. and schemaC You need to ensure that a user named User1 can truncate tables in schemaA only. How should you complete the T-SQL statement? To answer, select the appropriate options in...
