Question 11
You have a Fabric warehouse named Warehousel that contains a table named Table! Tablel contains customer data.
You need to implement row-level security (RLS) for Tablel. The solution must ensure that users can see only their respective data.
Which two objects should you create? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to implement row-level security (RLS) for Tablel. The solution must ensure that users can see only their respective data.
Which two objects should you create? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Question 12
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Fabric tenant that contains a new semantic model in OneLake.
You use a Fabric notebook to read the data into a Spark DataFrame.
You need to evaluate the data to calculate the min, max, mean, and standard deviation values for all the string and numeric columns.
Solution: You use the following PySpark expression: df.explain()
Does this meet the goal?
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Fabric tenant that contains a new semantic model in OneLake.
You use a Fabric notebook to read the data into a Spark DataFrame.
You need to evaluate the data to calculate the min, max, mean, and standard deviation values for all the string and numeric columns.
Solution: You use the following PySpark expression: df.explain()
Does this meet the goal?
Question 13
You need to recommend which type of fabric capacity SKU meets the data analytics requirements for the Research division. What should you recommend?
Question 14
Hotspot Question
You have a Microsoft Entra tenant named contoso.com and an external user named [email protected].
You have a Fabric workspace named Workspace1 that contains a semantic model named Model1 and a report named Report1.
[email protected] has access to Report1.
You enable read-write on the XML for Analysis (XMLA) endpoint to provide advanced semantic modeling by using DAX Studio.
You need to provide [email protected] with a URL that will enable connectivity by using DAX Studio.
How should you complete the URL? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point.
You have a Microsoft Entra tenant named contoso.com and an external user named [email protected].
You have a Fabric workspace named Workspace1 that contains a semantic model named Model1 and a report named Report1.
[email protected] has access to Report1.
You enable read-write on the XML for Analysis (XMLA) endpoint to provide advanced semantic modeling by using DAX Studio.
You need to provide [email protected] with a URL that will enable connectivity by using DAX Studio.
How should you complete the URL? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point.
Question 15
You have a Fabric tenant that contains a lakehouse named LH1.
You need to deploy a new semantic model. The solution must meet the following requirements:
* Support complex calculated columns that include aggregate functions, calculated tables, and Multidimensional Expressions (MDX) user hierarchies.
* Minimize page rendering times.
How should you configure the model? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to deploy a new semantic model. The solution must meet the following requirements:
* Support complex calculated columns that include aggregate functions, calculated tables, and Multidimensional Expressions (MDX) user hierarchies.
* Minimize page rendering times.
How should you configure the model? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
