You have a Fabric warehouse that contains a table named Sales.Products. Sales.Products contains the following columns.

You need to write a T-SQL query that will return the following columns.

How should you complete the code? To answer, select the appropriate options in the answer area.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant.
You need to configure OneLake security for users shown in the following table.

The solution must follow the principle of least privilege.
Which permission should you assign to each user? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

You need to configure OneLake security for two users with the following requirements:
User1: Read all the Spark data
User2: Read all the SQL endpoint data
The available permissions are: Read, ReadAll, and ReadData.
Understanding the permissions:
Read # Grants access to metadata but not the data itself.
ReadData # Grants access to query data through SQL endpoints (SQL-based access).
ReadAll # Grants access to read data across all engines (including Spark and SQL endpoints).
Applying least privilege principle:
User1 (Spark access): Needs to read all the Spark data # Assign ReadAll because Spark requires this permission to access data in OneLake.
User2 (SQL endpoint access): Needs to read SQL endpoint data only # Assign ReadData, as this grants access to SQL endpoints without over-provisioning Spark access.
Final Answer:
User1: ReadAll
User2: ReadData
References:
Microsoft Fabric OneLake permissions
Fabric Lakehouse & SQL Endpoint security

Comment: *

Name: *

Email: *

Verification: *

You have Fabric tenant that contains four workspaces named Development, Test, QA, and Production. All the workspaces are in Premium Per User (PPU) license mode.
You plan to use a release pipeline to support the development lifecycle from Development to Production.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Explanation:

Scenario Recap
Fabric tenant with workspaces: Development, Test, QA, Production.
All workspaces are already in Premium Per User (PPU) mode (which is required for deployment pipelines).
Task: Set up a release pipeline to move through Dev # Test # QA # Production.
Step 1: Create a deployment pipeline
The first step is always to create a new deployment pipeline in the Fabric/Power BI service. This establishes the structure for Dev # Test # Prod (and optionally QA).
Step 2: Create the QA stage
By default, pipelines have 3 stages (Dev, Test, Prod).
Since we need a QA stage in addition, we must explicitly add it as a stage to the pipeline.
Step 3: Assign workspaces
Once the pipeline structure is ready (with QA included), we assign each workspace to the corresponding stage:
Development # Development
Test # Test
QA # QA
Production # Production
Why Not the Other Actions?
Move each workspace to Pro license mode # Incorrect, because deployment pipelines require Premium capacity or PPU, and the workspaces already are in PPU mode.
Create a deployment rule # Deployment rules (e.g., parameter or data source rules) are optional for environment-specific changes, but not part of the initial required setup sequence.
References
Deployment pipelines overview
Assigning workspaces to deployment pipelines

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains a takehouse named lakehouse1. Lakehouse1 contains a Delta table named Customer.
When you query Customer, you discover that the query is slow to execute. You suspect that maintenance was NOT performed on the table.
You need to identify whether maintenance tasks were performed on Customer.
Solution: You run the following Spark SQL statement:
DESCRIBE HISTORY customer
Does this meet the goal?

• A.Yes
• B.No

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric workspace named Workspace1 and an Azure Data Lake Storage Gen2 account named storage"!. Workspace1 contains a lakehouse named Lakehouse1.
You need to create a shortcut to storage! in Lakehouse1.
Which connection and endpoint should you specify? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

When creating a shortcut to an Azure Data Lake Storage Gen2 account in a lakehouse, you should use the abfss (Azure Blob File System Secure) connection string and the dfs (Data Lake File System) endpoint. The abfss is used for secure access to Azure Data Lake Storage, and the dfs endpoint indicates that the Data Lake Storage Gen2 capabilities are to be used.

Comment: *

Name: *

Email: *

Verification: *