You have a Fabric tenant that contains a machine learning model registered in a Fabric workspace. You need to use the model to generate predictions by using the predict function in a fabric notebook. Which two languages can you use to perform model scoring? Each correct answer presents a complete solution. NOTE:
Each correct answer is worth one point.

• A.T-SQL
• B.DAX EC.
• C.Spark SQL
• D.PySpark

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains a data warehouse named DW1. DW1 contains a table named DimCustomer. DimCustomer contains the fields shown in the following table.

You need to identify duplicate email addresses in DimCustomer. The solution must return a maximum of
1,000 records.
Which four T-SQL statements should you run in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.

Correct Answer:

Explanation:

Step 1 - Select the required fields and count
We want to group by CustomerAltKey and count occurrences.
SELECT CustomerAltKey, COUNT(*)
Step 2 - From the table
FROM DimCustomer
Step 3 - Grouping by email
GROUP BY CustomerAltKey
Step 4 - Filtering duplicates (only values with count > 1)
HAVING COUNT(*) > 1
Step 5 - Limiting the result to 1,000 rows
LIMIT 1000
(or in T-SQL, SELECT TOP(1000) ...). Since both options are shown, we use LIMIT 1000 because Fabric Warehouse supports Synapse SQL T-SQL + ANSI SQL style.
Correct Sequence:
SELECT CustomerAltKey, COUNT(*)
FROM DimCustomer
GROUP BY CustomerAltKey
HAVING COUNT(*) > 1
LIMIT 1000

Comment: *

Name: *

Email: *

Verification: *

You are analyzing customer purchases in a Fabric notebook by using PySpark.
You have the following DataFrames:
- transactions: Contains five columns named transaction_id,
customer_id, product_id, amount, and date and has 10 million rows, with each row representing a transaction.
- customers: Contains customer details in 1,000 rows and three columns
named customer_id, name, and country.
You need to join the DataFrames on the customer_id column. The solution must minimize data shuffling.
You write the following code.
from pyspark.sql import functions as F
results =
Which code should you run to populate the results DataFrame?

• A.transactions.join(F.broadcast(customers), transactions.customer_id == customers.customer_id)
• B.transactions.join(customers, transactions.customer_id == customers.customer_id).distinct()
• C.transactions.join(customers, transactions.customer_id == customers.customer_id)
• D.transactions.crossJoin(customers).where(transactions.customer_id == customers.customer_id)

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric warehouse that contains a table named SalesOrderDetail. SalesOrderDetail contains three columns named OrderQty, ProductID and SalesOrderlD. SalesOrderDetail contains one row per combination of SalesOrderlD and ProductID.
You need to calculate the proportion of the total quantity of each sales order represented by each product within the sales order.
Which T-SQL statement should you run?

• A.
• B.
• C.
• D.

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric workspace that contains a warehouse named DW1. DW1 contains the following tables and columns.

You need to summarize order quantities by year and product. The solution must include the yearly sum of order quantities for all the products in each row.
How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

Comment: *

Name: *

Email: *

Verification: *