You have a Fabric tenant.
You plan to create a Fabric notebook that will use Spark DataFrames to generate Microsoft Power Bl visuals.
You run the following code.

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains a semantic model named Modell. Model! contains a fact table with millions of rows of shipment data.
You need to enable partitioning to improve the query performance and manageability of Modell. Which two tools can you use to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.

• A.Microsoft Power Bl Desktop
• B.DAX Studio
• C.Tabular Editor
• D.Microsoft SQL Server Management Studio (SSMS)
• E.the Microsoft Power Bl service

Comment: *

Name: *

Email: *

Verification: *

You are analyzing customer purchases in a Fabric notebook by using PySpanc You have the following DataFrames:

You need to join the DataFrames on the customer_id column. The solution must minimize data shuffling. You write the following code.

Which code should you run to populate the results DataFrame?

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

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a lakehouse named Lakehouse1 and a warehouse named Warehouse1.
You need to create a new table in Warehouse1 named POSCustomers by querying the customer table in Lakehouse1.
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:

Step 1 - Creating the new table from a query
To create a table in a SQL warehouse using a query, the correct syntax is:
CREATE TABLE < table_name > AS SELECT ...
So we must select:
CREATE TABLE dbo.POSCustomers AS SELECT
Step 2 - Selecting the source table
Since the data source is the Lakehouse1 table Customer, the fully qualified name is:
lakehouse1.dbo.Customer
Final Answer:
CREATE TABLE dbo.POSCustomers AS SELECT
postalcode,
category
FROM lakehouse1.dbo.Customer;
References:
CREATE TABLE AS SELECT (CTAS) in Fabric Warehouse
Fabric Lakehouse and Warehouse interoperability

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric workspace that contains a warehouse named Warehouse!. Warehousel contains the following data.

You need to create a T-SQL statement that will denormalize the tables and include the ContractType and StartDate attributes in the results. The solution must meet the following requirements:
* Include attributes from matching rows in the Contract table.
* Ensure that all the rows from the Employee table are preserved.
* Return the total number of employees per contract type for all the contract types that have more than two employees.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

Comprehensive Detailed Explanation
We are tasked with writing a T-SQL query to denormalize the tables Employee and Contract in a Fabric warehouse.
Requirements Breakdown
Include attributes from matching rows in the Contract table
This means we must join Employee and Contract on EmployeeID.
Ensure that all rows from the Employee table are preserved
This requires a LEFT OUTER JOIN from Employee to Contract. If an employee has no contract, we still want the employee record included.
Return the total number of employees per contract type for all contract types that have more than two employees This means we need to:
Group by ContractType
Count distinct EmployeeID
Filter groups where that count > 2.
To filter aggregated results, we use HAVING, not WHERE.
Completed Query
WITH result AS (
SELECT
e.EmployeeID,
e.EmployeeName,
e.EmployeePosition,
c.ContractType,
c.StartDate
FROM Employee AS e
LEFT OUTER JOIN Contract AS c
ON c.EmployeeID = e.EmployeeID
)
SELECT
ContractType,
COUNT(DISTINCT EmployeeID) AS TotalEmployees
FROM result
GROUP BY ContractType
HAVING COUNT(DISTINCT EmployeeID) > 2;
Why This is Correct
LEFT OUTER JOIN ensures all employees are included, regardless of contracts.
HAVING allows filtering aggregated groups by employee counts.
The query returns ContractType, StartDate (as requested in denormalization), and aggregated employee counts.
References
T-SQL JOINs in Microsoft Fabric
Aggregate functions and HAVING clause
Denormalization best practices in Fabric warehouses

Comment: *

Name: *

Email: *

Verification: *