👉Get Full PDF
| Question.6 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 each statement based on the information presented in the graphic.  |
6. Click here to View Answer
If the query folded the work is pushed to the data source. the icons help to tell you if folding is occurring or not.
Reference:
https://learn.microsoft.com/en-us/power-query/step-folding-indicators#step-diagnostics-indicators
| Question.7 You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains a fact table named FactSales that has one billion rows. You run the following T-SQL statement. CREATE TABLE test.FactSales AS CLONE OF Dbo.FactSales;For each of the following statements, select Yes if the statement is true. Otherwise, select No.  |
7. Click here to View Answer
Answer is Y-N-N
Second and third statements are equal “Additional schema changes to dbo.FactSales will also apply to test.FactSales”
What happens with this statement:
– A new table called test.FactSales is created.
– The structure (columns, data types, constraints) of test.FactSales will be identical to that of Dbo.FactSales at the time of creation.
– The data in test.FactSales will be a snapshot of the data in Dbo.FactSales at the moment of table creation.
Reference:
https://learn.microsoft.com/en-us/fabric/data-warehouse/clone-table
| Question.8 You have source data in a folder on a local computer. You need to create a solution that will use Fabric to populate a data store. The solution must meet the following requirements: Support the use of dataflows to load and append data to the data store. Ensure that Delta tables are V-Order optimized and compacted automatically. Which type of data store should you use? (A) A lakehouse (B) An Azure SQL database (C) A warehouse (D) A KQL database |
8. Click here to View Answer
Answer is (A) A lakehouse
To meet the requirements of supporting dataflows to load and append data to the data store while ensuring that Delta tables are V-Order optimized and compacted automatically, you should use a lakehouse in Fabric as your solution.
| Question.9 You have a Fabric tenant that contains a warehouse. Several times a day, the performance of all warehouse queries degrades. You suspect that Fabric is throttling the compute used by the warehouse. What should you use to identify whether throttling is occurring? (A) The Capacity settings (B) The Monitoring hub (C) Dynamic management views (DMVs) (D) The Microsoft Fabric Capacity Metrics app |
9. Click here to View Answer
Answer is (D) The Microsoft Fabric Capacity Metrics app
The Microsoft Capacity Metrics app, also known as the metrics app, serves as a monitoring tool within the Microsoft Power BI service. It offers functionalities to track and analyze the resource utilization
Reference:
https://learn.microsoft.com/en-us/fabric/enterprise/throttling#track-rejected-operations
https://learn.microsoft.com/en-us/fabric/enterprise/metrics-app
| Question.10 You have a Fabric tenant that contains a warehouse. A user discovers that a report that usually takes two minutes to render has been running for 45 minutes and has still not rendered. You need to identify what is preventing the report query from completing. Which dynamic management view (DMV) should you use? (A) sys.dm_exec_requests (B) sys.dm_exec_sessions (C) sys.dm_exec_connections (D) sys.dm_pdw_exec_requests |
10. Click here to View Answer
Answer is (A) sys.dm_exec_requests
You can use the sys.dm_exec_requests dynamic management view (DMV) to identify what is preventing the report query from completing 1.
Reference:
https://learn.microsoft.com/en-us/fabric/data-warehouse/monitor-using-dmv
#identify-and-kill-a-long-running-query” target=”_blank”>https://learn.microsoft.com/en-us/fabric/data-warehouse/monitor-using-dmv
#identify-and-kill-a-long-running-query
https://learn.microsoft.com/en-us/fabric/data-warehouse/monitor-using-dmv