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.an Azure SQL database
• B.a KQL database
• C.a lakehouse
• D.a warehouse

Comment: *

Name: *

Email: *

Verification: *

You have a data warehouse that contains a table named Stage. Customers. Stage-Customers contains all the customer record updates from a customer relationship management (CRM) system. There can be multiple updates per customer You need to write a T-SQL query that will return the customer ID, name, postal code, and the last updated time of the most recent row for each customer ID.
How should you complete the code? To answer, select the appropriate options in the answer area, NOTE Each correct selection is worth one point.

Correct Answer:

Explanation:

* In the ROW_NUMBER() function, choose OVER (PARTITION BY CustomerID ORDER BY LastUpdated DESC).
* In the WHERE clause, choose WHERE X = 1.
To select the most recent row for each customer ID, you use the ROW_NUMBER() window function partitioned by CustomerID and ordered by LastUpdated in descending order. This will assign a row number of 1 to the most recent update for each customer. By selecting rows where the row number (X) is 1, you get the latest update per customer.
References =
* Use the OVER clause to aggregate data per partition
* Use window functions

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric workspace named Workspace-!. You have a GitHub repository named Repol. You need to connect Workspacel to the main branch of Repol. Which information should you provide?

• A.an access key and the branch name of Repo1
• B.a personal access token (PAT) and the URL of Repo1
• C.a shared access signature (SAS) token and the branch name of Repo1 B
• D.an access key and the URL of Repo1

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric eventhouse that contains a KQL database. The database contains a table named TaxiData that stores the following data.

You need to create a column named FirstPickupDateTime that will contain the first value of each hour from tpep_pickup_datetime partitioned by payment_type.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

Comment: *

Name: *

Email: *

Verification: *