DP-700 試験問題を無料オンラインアクセス

You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Table 1. You need to ensure that a user named User 1 can view only specific rows in Table1. What should you do first?

• A.Create a function.
• B.Create a security policy.
• C.Create a security predicate.
• D.Grant User1 the SELECT permission for Table1.

You have a Fabric workspace that contains a warehouse named Warehouse1. Data is loaded daily into Warehouse1 by using data pipelines and stored procedures.
You discover that the daily data load takes longer than expected.
You need to monitor Warehouse1 to identify the names of users that are actively running queries.
Which view should you use?

• A.queryinsights.frequently_run_queries
• B.sys.dm_exec_sessions
• C.queryinsights.long_running_queries
• D.sys.dm_exec_requests
• E.sys.dm_exec_connections

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.No
• B.Yes

You have a Fabric workspace that contains a lakehouse and a notebook named Notebook1. Notebook1 reads data into a DataFrame from a table named Table1 and applies transformation logic. The data from the DataFrame is then written to a new Delta table named Table2 by using a merge operation.
You need to consolidate the underlying Parquet files in Table1.
Which command should you run?

• A.CACHE
• B.VACUUM
• C.BROADCAST
• D.OPTIMIZE

You have a Fabric workspace that contains a data pipeline named Pipeline1 and a notebook named Notebook1. Pipeline1 contains an activity that is used to run Notebook1. Pipeline! is scheduled to run every
10 minutes.
You receive an alert that Pipeline! failed during the notebook execution activity.
You need to identify in which cell the failure occurred.
What should you do from Monitor in the Fabric admin center?

• A.Select the entry for the pipeline execution, and then select the output.
• B.Select the entry for the notebook execution, and then select the logs.
• C.Select the entity for the pipeline execution, and then view the activity run.
• D.Select the entry for the notebook execution, and then view the item snapshot.