Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a KQL database that contains two tables named Stream and Reference. Stream contains streaming data in the following format.

Reference contains reference data in the following format.

Both tables contain millions of rows.
You have the following KQL queryset.

You need to reduce how long it takes to run the KQL queryset.
Solution: You change the join type to kind=outer.
Does this meet the goal?

• A.Yes
• B.No

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric workspace that contains a notebook named Notebook1 and an Azure Data Factory pipeline named Pipeline1. Pipeline1 runs Notebook1 by using a notebook activity and passes simple parameter types.
Notebook1 contains the following cells:
Cell 3: Contains %%configure code that sets Apache Spark session properties Cell 5: Contains a designated parameters cell During an execution of Pipeline1, the pipeline fails before any business logic runs.
You need to ensure that Pipeline1 runs successfully.
What should you do?

• A.Move the designated parameters cell to cell 1.
• B.Move the %%configure code to a cell 1.
• C.Move the %%configure code to cell 6.
• D.Pass all the values directly from the notebook activity.

Comment: *

Name: *

Email: *

Verification: *

HOTSPOT
You are processing streaming data from an external data provider.
You have the following code segment.

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:

Litware from New York will be displayed at the top of the result set - Yes The data is sorted first by Location in descending order and then by UnitsSold in descending order. Since " New York " is alphabetically the last Location, it will appear first in the result set. Within " New York " , Litware has the highest UnitsSold (1000), so it will be displayed at the top.
Fabrikam in Seattle will have value = 2 in the Rank column - No
The row_rank_dense function assigns dense ranks based on UnitsSold within each location. In " Seattle " :
Contoso has UnitsSold = 300 # Rank 1
Litware has UnitsSold = 100 # Rank 2
Fabrikam also has UnitsSold = 100, so it shares the same rank (2) as Litware.
Litware in San Francisco will have the same value in the Rank column as Litware in New York - No The rank is calculated separately for each location. In " San Francisco " :
Both Relecloud and Litware have UnitsSold = 500, so they share the same rank (1).
In " New York " , Litware has the highest UnitsSold = 1000 # Rank 1.
Since ranks are calculated independently for each location, Litware in San Francisco does not share the same rank as Litware in New York.

Comment: *

Name: *

Email: *

Verification: *

HOTSPOT
You need to troubleshoot the ad-hoc query issue.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
A screenshot of a computer Description automatically generated

SELECT last_run_start_time, last_run_command: These fields will help identify the execution details of the long-running queries.
FROM queryinsights.long_running_queries: The correct solution is to check the long-running queries using the queryinsights.long_running_queries view, which provides insights into queries that take longer than expected to execute.
WHERE last_run_total_elapsed_time_ms > 7200000: This condition filters queries that took more than 2 hours to complete (7200000 milliseconds), which is relevant to the issue described.
AND number_of_failed_runs > 1: This condition is key for identifying queries that have failed more than once, helping to isolate the problematic queries that cause failures and need attention.

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric capacity that contains a workspace named Workspace1. Workspace1 contains a lakehouse named Lakehouse1, a data pipeline, a notebook, and several Microsoft Power BI reports.
A user named User1 wants to use SQL to analyze the data in Lakehouse1.
You need to configure access for User1. The solution must meet the following requirements:
Provide User1 with read access to the table data in Lakehouse1.
Prevent User1 from using Apache Spark to query the underlying files in Lakehouse1.
Prevent User1 from accessing other items in Workspace1.
What should you do?

• A.Assign User1 the Member role for Workspace1. Share Lakehouse1 with User1 and select Read all SQL endpoint data.
• B.Share Lakehouse1 with User1 directly and select Build reports on the default semantic model.
• C.Share Lakehouse1 with User1 directly and select Read all SQL endpoint data.
• D.Assign User1 the Viewer role for Workspace1. Share Lakehouse1 with User1 and select Read all SQL endpoint data.

Comment: *

Name: *

Email: *

Verification: *