You have a Fabric workspace named Workspace1 that is connected to a GitHub repository named repo1.
Workspace1 contains the items shown in the following table.

You modify Semantic model 1, Semanticmodel2, and Report2.
You need to commit the changes to repo1.
What is the minimum number of commits you should perform?

• A.2
• B.3
• C.1
• D.A

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric workspace named WS1 that contains several scheduled data pipelines. WS1 has workspace monitoring enabled, and the monitoring eventhouse contains a table named ItemJobEventLogs.
Users report that some downstream reports are missing newly ingested data.
You need to identify failed pipeline runs from the last nine minutes and return only the columns needed for troubleshooting.
How should you complete the KQL query?

Correct Answer:

Explanation:
First selection: JobType == ' Pipeline '
Second selection: SecondsAgo < = 540
Completed KQL query:
ItemJobEventLogs
| where JobType == ' Pipeline ' and JobStatus == ' Failed '
| extend SecondsAgo = datetime_diff( ' second ' , now(), ingestion_time())
| where SecondsAgo < = 540
| order by Timestamp desc
| project Timestamp, ItemName, WorkspaceName, JobStartTime, JobEndTime, JobStatus The correct selections are JobType == ' Pipeline ' and SecondsAgo < = 540 . Microsoft Fabric workspace monitoring writes item-level execution information to the ItemJobEventLogs table in the monitoring Eventhouse. Microsoft provides this specific KQL pattern for detecting recent pipeline failures , using JobType == ' Pipeline ' together with JobStatus == ' Failed ' .
The query then calculates:
datetime_diff( ' second ' , now(), ingestion_time())
This produces the approximate number of seconds elapsed since each monitoring record was ingested.
Because nine minutes = 540 seconds , the predicate SecondsAgo < = 540 retains records ingested during the preceding nine-minute window. SecondsAgo > = 540 would do the opposite by retaining records at least nine minutes old.
JobEndTime > = ago(9m) is not the correct selection because the query explicitly derives ingestion recency through ingestion_time(). Microsoft's documented workspace-monitoring example uses the same SecondsAgo < = 540 pattern.
Finally, project limits the result to the operational fields required for troubleshooting: timestamp, pipeline name, workspace, start/end times, and failure status.
Study Guide reference: Monitor and optimize an analytics solution # workspace monitoring # Eventhouse monitoring logs # KQL analysis of pipeline execution and failures.

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse2. A team of data analysts has Viewer role access to Workspace1. You create a table by running the following statement.

You need to ensure that the team can view only the first two characters and the last four characters of the Creditcard attribute.
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:

Comment: *

Name: *

Email: *

Verification: *

What should you do to optimize the query experience for the business users?

• A.Introduce primary keys.
• B.Create and update statistics.
• C.Enable V-Order.
• D.Run the VACUUM command.

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric workspace named Workspace1. Your company acquires GitHub licenses.
You need to configure source control for Workpace1 to use GitHub. The solution must follow the principle of least privilege. Which permissions do you require to ensure that you can commit code to GitHub?

• A.Contents (Read and write) only
• B.Contents (Read) and Commit statuses (Read and write)
• C.Actions (Read and write) and Contents (Read and write)
• D.Actions (Read and write) only

Comment: *

Name: *

Email: *

Verification: *