Hotspot Question
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.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-as-clone-of-transact- sql?view=fabric&preserve-view=true Creates a new table as a zero-copy clone of another table in Warehouse in Microsoft Fabric. Only the metadata of the table is copied. The underlying data of the table, stored as parquet files, is not copied.
https://learn.microsoft.com/en-us/fabric/data-warehouse/clone-table
Separate and independent
Upon creation, a table clone is an independent and separate copy of the data from its source.
Any changes made through DML or DDL on the source of the clone table are not reflected in the clone table.Similarly, any changes made through DDL or DML on the table clone are not reflected on the source of the clone table.

Comment: *

Name: *

Email: *

Verification: *

Drag and Drop Question
You are implementing two dimension tables named Customers and Products in a Fabric warehouse.
You need to use slowly changing dimension (SCD) to manage the versioning of data. The solution must meet the requirements shown in the following table.

Which type of SCD should you use for each table? To answer, drag the appropriate SCD types to the correct tables. Each SCD type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Static table:
Type 0 - Fixed Dimension. No changes allowed, dimension never changes.
Commonly used SCD types:
Type 1 - No History. Update record directly, there is no record of historical values, only current state.
Type 2 - Row Versioning.
Type 3 - Previous Value column.
Rarely used:
Type 4 - History Table.
Type 6 - Hybrid SCD.

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Nyctaxi_raw. Nyctaxi_raw contains the following columns.

You create a Fabric notebook and attach it to lakehouse1.
You need to use PySpark code to transform the dat
a. The solution must meet the following requirements:
* Add a column named pickupDate that will contain only the date portion of pickupDateTime.
* Filter the DataFrame to include only rows where fareAmount is a positive number that is less than 100.
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:

Comment: *

Name: *

Email: *

Verification: *

You need to resolve the issue with the pricing group classification.
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:

* You should use CREATE VIEW to make the pricing group logic available for T-SQL queries.
* The CASE statement should be used to determine the pricing group based on the list price.
The T-SQL statement should create a view that classifies products into pricing groups based on the list price.
The CASE statement is the correct conditional logic to assign each product to the appropriate pricing group.
This view will standardize the pricing group logic across different databases and semantic models.

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains a workspace named Workspace1 and a user named DBUser.
Workspace1 contains a lakehouse named Lakehousel. DBUser does NOT have access to the tenant.
You grant DBUser access to Lakehouse1 as 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.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

Comment: *

Name: *

Email: *

Verification: *