You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a subfolder named Subfolder1 that contains CSV files. You need to convert the CSV files into the delta format that has V-Order optimization enabled. What should you do from Lakehouse explorer?

• A.Use the Load to Tables feature.
• B.Create a new shortcut in the Files section.
• C.Create a new shortcut in the Tables section.
• D.Use the Optimize feature.

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains a warehouse named Warehouse!. Warehousel contains two schemas name schemal and schema2 and a table named schemal.city.
You need to make a copy of schemal.city in schema2. The solution must minimize the copying of data.
Which T-SQL statement should you run?

• A.INSERT INTO schema2.city SELECT * FROM schemal.city;
• B.CREATE TABLE schema2.city AS CLONE OF schemal.city;
• C.CREATE TABLE schema2.city AS SELECT * FROM schemal.city;
• D.SELECT * INTO schema2.eity FROM schemal.city;

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric warehouse named Warehouse1 that contains a table named dbo.Product. dbo.Product contains the following columns.

You need to use a T-SQL query to add a column named PriceRange to dbo.Product. The column must categorize each product based on UnitPrice. The solution must meet the following requirements:
* If UnitPrice is 0, PriceRange is "Not for resale".
* If UnitPrice is less than 50, PriceRange is "Under $50".
* If UnitPrice is between 50 and 250, PriceRange is "Under $250".
* In all other instances, PriceRange is "$250+".
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value 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:

Comment: *

Name: *

Email: *

Verification: *

You have a semantic model named Model 1. Model 1 contains five tables that all use Import mode. Model1 contains a dynamic row-level security (RLS) role named HR. The HR role filters employee data so that HR managers only see the data of the department to which they are assigned.
You publish Model1 to a Fabric tenant and configure RLS role membership. You share the model and related reports to users.
An HR manager reports that the data they see in a report is incomplete.
What should you do to validate the data seen by the HR Manager?

• A.Select Test as role to view the data as the HR role.
• B.Filter the data in the report to match the intended logic of the filter for the HR department.
• C.Ask the HR manager to open the report in Microsoft Power Bl Desktop.
• D.Select Test as role to view the report as the HR manager,

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric warehouse named Warehouse1 that contains a table named dbo.Product. dbo.Product contains the following columns.

You need to use a T-SQL query to add a column named PriceRange to dbo.Product. The column must categorize each product based on UnitPrice. The solution must meet the following requirements:
* If UnitPrice is 0, PriceRange is " Not for resale " .
* If UnitPrice is less than 50, PriceRange is " Under $50 " .
* If UnitPrice is between 50 and 250, PriceRange is " Under $250 " .
* In all other instances, PriceRange is " $250+ " .
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value 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:

Comprehensive Detailed Explanation
We need to create a computed column PriceRange based on the UnitPrice column in the dbo.Product table.
Step 1: Requirements
If UnitPrice = 0 # " Not for resale "
If UnitPrice < 50 # " Under $50 "
If UnitPrice > = 50 AND UnitPrice < 250 # " Under $250 "
Otherwise # " $250+ "
This matches a CASE expression in T-SQL.
Step 2: CASE Expression Structure
The syntax is:
CASE
WHEN condition THEN result
WHEN condition THEN result
ELSE result
END
Step 3: Apply to Problem
SELECT
Item,
UnitPrice,
PriceRange = CASE
WHEN UnitPrice = 0 THEN ' Not for resale '
WHEN UnitPrice < 50 THEN ' Under $50 '
WHEN UnitPrice > = 50 AND UnitPrice < 250 THEN ' Under $250 '
ELSE ' $250+ '
END
FROM [Warehouse1].[dbo] .[Product];
Step 4: Why This is Correct
CASE starts the conditional evaluation.
ELSE handles the default branch ( $250+ ).
END closes the expression.
Meets all requirements exactly.
References
CASE expression in T-SQL
Computed columns in T-SQL

Comment: *

Name: *

Email: *

Verification: *