Fabric Tenant Query Performance

18 Questions

What is the purpose of running the Spark SQL statement EXPLAIN TABLE customer?

To identify if maintenance tasks were performed on the table

What is the primary purpose of using the XMLA endpoint in a Fabric tenant?

To execute DAX queries on a semantic model

What is the benefit of processing foldable Power Query transformation steps in a Microsoft SQL Server engine?

Reduced latency in data ingestion from Azure SQL databases

What is the purpose of a lakehouse in a Fabric tenant?

To store and manage large datasets in a scalable and secure manner

What is the primary purpose of using a DAX query in a Fabric tenant?

To filter and aggregate data in a semantic model

What is the primary purpose of using a T-SQL statement in a Fabric tenant?

To ingest data from an Azure SQL database

What is the correct T-SQL statement to copy all data from the 'city' table in 'schema1' to the 'city' table in 'schema2'?

INSERT INTO schema2.city SELECT * FROM schema1.city;

How can you prevent new tables added to Lakehouse1 from being added automatically to the default semantic model of the lakehouse?

Configure the semantic model settings

What type of activity should you add to an Azure Data Factory pipeline to execute a stored procedure in a warehouse?

Execute stored procedure

How do you create a new table in Warehouse1 named POSCustomers by querying the customer table in Lakehouse1?

CREATE TABLE Warehouse1.POSCustomers AS SELECT * FROM Lakehouse1.customer;

What is the purpose of the semantic model settings in a lakehouse?

To control the automatic addition of tables to the default semantic model

What is the benefit of adding an Execute Stored Procedure activity to an Azure Data Factory pipeline?

To execute a stored procedure in a warehouse and make the returned values available to downstream activities

Which query should you use to return data for the year 2023 that displays ProductID and ProductName and has a summarized Amount that is higher than 10,000?

SELECT ProductID, ProductName, SUM(Amount) AS TotalAmount FROM table_name WHERE year = 2023 GROUP BY ProductID, ProductName HAVING TotalAmount > 10000

How should you complete the code to return the customer ID, name, postal code, and the last updated time of the most recent row for each customer ID?

SELECT customer_id, name, postal_code, MAX(updated_time) FROM Stage.Customers GROUP BY customer_id, name, postal_code

What will you be able to do after connecting to Lakehouse1 using its SQL endpoint?

Read Table2 and Table3

What type of table is Table1 in Lakehouse1?

Delta table

What can you do with Fabric notebooks?

Generate Microsoft Power BI visuals using Spark DataFrames

What is the purpose of the Fabric workspace?

To manage a data lakehouse

This quiz assesses your ability to troubleshoot query performance issues in a Fabric tenant by identifying whether maintenance tasks were performed on a Delta table. The quiz presents a scenario where a query is slow to execute and requires you to determine the cause of the issue.

Make Your Own Quizzes and Flashcards

Convert your notes into interactive study material.