You have a Fabric tenant that contains a workspace named Workspace1.

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)