- All Exams Instant Download
What is a possible cause of the failure?
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...
Which three levels of access should you assign to the developers?
You need to provide Power Bl developers with access to the pipeline. The solution must meet the following requirements: • Ensure that the developers can deploy items to the workspaces for Development and Test. • Prevent the developers from deploying items to the workspace for Production. • Follow the principle...
What should you do?
You need to ensure the data loading activities in the AnalyticsPOC workspace are executed in the appropriate sequence. The solution must meet the technical requirements. What should you do?A . Create a pipeline that has dependencies between activities and schedule the pipeline.B . Create and schedule a Spark job definition.C...
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 ....
Which additional permissions should you assign when you share the data store?
Topic 1, Litware. Inc. Case Study Overview Litware. Inc. is a manufacturing company that has offices throughout North America. The analytics team at Litware contains data engineers, analytics engineers, data analysts, and data scientists. Existing Environment litware has been using a Microsoft Power Bl tenant for three years. Litware has...
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...
