👉Get Full PDF
| Question.16 You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1. Dataflow1 has a query that returns 2,000 rows. You view the query in Power Query as shown in the following exhibit.  What can you identify about the pickupLongitude column? (A) The column has duplicate values. (B) All the table rows are profiled. (C) The column has missing values. (D) There are 935 values that occur only once. |
16. Click here to View Answer
Answer is (A) The column has duplicate values.
We see a count of 1000 (which is the limit by default) we do not know all the data is read, but we can see of the 1000 distinct is less and so we have duplicate values.
B – Not all the rows are profiled in the sample (only 1000 of 2000)
C- From the column statistics, you don’t have any missing values in the sample
D- The values that occur only once are 871 (unique count)
| Question.17 You have a Fabric tenant named Tenant1 that contains a workspace named WS1. WS1 uses a capacity named C1 and contains a dataset named DS1. You need to ensure read-write access to DS1 is available by using XMLA endpoint. What should be modified first? (A) the DS1 settings (B) the WS1 settings (C) the C1 settings (D) the Tenant1 settings |
17. Click here to View Answer
Answer is (C) the C1 settings
As XMLA is set to Read-Only first, you must go to the capacity settings to enable read-write.
| Question.18 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?  |
18. Click here to View Answer
This statement allows to alter (which includes truncating) tables within the specified schema. It ensures that the permission is restricted to schemaA and does not grant access to other schemas or objects.
| Question.19 You have a Fabric tenant that contains 30 CSV files in OneLake. The files are updated daily. You create a Microsoft Power BI semantic model named Model1 that uses the CSV files as a data source. You configure incremental refresh for Model1 and publish the model to a Premium capacity in the Fabric tenant. When you initiate a refresh of Model1, the refresh fails after running out of resources. What is a possible cause of the failure? (A) Query folding is occurring. (B) Only refresh complete days is selected. (C) XMLA Endpoint is set to Read Only. (D) Query folding is NOT occurring. (E) The delta type of the column used to partition the data has changed. |
19. Click here to View Answer
Answer is (A) The delta type of the column used to partition the data has changed.
Query folding is not applicable with csv files, which rules out A,D answers.
The provided Microsoft link related to “problem-loading-data-takes-too-long”, states two causes, one related to query folding (we’ve already ruled it out) and another one related to the data type, which in turn leads us to answer “The delta type of the column used to partition the data has changed.”
| Question.20 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 should you use from Microsoft Power BI Desktop? (A) Data categories (B) Data view (C) Model view (D) DAX query view |
20. Click here to View Answer
Answer is (C) Model view
In the Model view, it is possible to analyze the semantic model and create new layouts.