Free Microsoft DP-600 Exam Dumps Questions & Answers

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a lakehouse named I.H1 and a warehouse named DW1. I.H1 contains a table named signindata that is in the dho schema.
You need to create a stored procedure in DW1 that deduplicates the data in the signindata table.
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:

Scenario Recap
Fabric tenant # Workspace1
Contains:
Lakehouse LH1 (with table signindata in schema dho)
Warehouse DW1
Task: Create a stored procedure in DW1 that deduplicates rows in signindata.
Step 1: Stored procedure structure
In T-SQL, stored procedures begin with:
AS
BEGIN
-- logic
END
So the correct option for the first blank is BEGIN.
BEGIN DISTRIBUTED TRANSACTION is not needed because we are not spanning multiple servers or needing distributed transactions.
SET is not the right way to start the logic block.
Step 2: Deduplication logic
To remove duplicates from signindata, the query should return unique rows.
The simplest way is:
SELECT DISTINCT PersonID, FirstName, LastName
FROM dho.signindata;
Thus the correct choice for the second blank is DISTINCT.
GROUP BY could also deduplicate but is less efficient here since no aggregation is requested.
TOP 100 PERCENT WITH TIES is irrelevant.
Step 3: Final T-SQL stored procedure
CREATE PROCEDURE dbo.usp_GetPerson
AS
BEGIN
SELECT DISTINCT PersonID, FirstName, LastName
FROM dho.signindata;
END;
Why this is correct
BEGIN # correct stored procedure structure.
DISTINCT # ensures deduplication of rows from signindata.
References
CREATE PROCEDURE (Transact-SQL)
DISTINCT (Transact-SQL)

You have a Microsoft Power Bl report and a semantic model that uses Direct Lake mode. From Power Bl Desktop, you open Performance analyzer as shown in the following exhibit.

Use the dropdown 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:

You have a Fabric workspace named Workspace1 that contains the following items:
A warehouse named Warehouse1
A semantic model named Model1
An interactive report named Report1
You need to allow a user named User1 to access a single table in Warehouse1. The solution must follow the principle of least privilege.
What should you do first?

• A.  Assign object level permissions to User1 for Warehouse1.
• B.  Assign the Viewer role to User1 for Workspace1.
• C.  Share Warehouse1 with User1.
• D.  Assign the db_datareader role to User1 for Warehouse1.

You have a Fabric workspace named Workspace-!. You have a GitHub repository named Repol. You need to connect Workspacel to the main branch of Repol. Which information should you provide?

• A.  a personal access token (PAT) and the URL of Repo1
• B.  an access key and the branch name of Repo1
• C.  an access key and the URL of Repo1
• D.  a shared access signature (SAS) token and the branch name of Repo1

You have a Fabric workspace named Workspace1 that contains a semantic model and a report named Report1. Workspace 1 is connected to a Git repository named Gill.
You have a deployment pipeline that contains three stages named Development, Test, and Production.
You need to publish Report1 to the Production stage.
What should you do?

• A.  Sync Workspace1 with Git1.
• B.  Run a Git commit.
• C.  Run a full deployment
• D.  Run a backward deployment.