DP-600試験無料問題集（104題）「Microsoft Implementing Analytics Solutions Using Microsoft Fabric 認定」

出題：1

You have a Fabric tenant that contains a lakehouse.
You are using a Fabric notebook to save a large DataFrame by using the following code.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

正解：

Reference:
DataFrame write partitionBy
Apache Spark optimization with partitioning

出題：2

You have a Fabric tenant named Tenant1 that contains a workspace named WS1. WS1 uses a capacity named C1 and contains a dawset named DS1. You need to ensure read-write access to DS1 is available by using the XMLA endpoint. What should be modified first?

A. the WS1 settings

B. the DS1 settings

C. the Tenant1 settings

D. the C1 settings

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

You need to implement the date dimension in the data store. The solution must meet the technical requirements.
What are two ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Populate the date dimension table by using a dataflow.

B. Populate the date dimension table by using a Copy activity in a pipeline.

C. Populate the date dimension table by using a Stored procedure activity in a pipeline.

D. Populate the date dimension view by using T-SQL.

正解：A,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

You have a Fabric tenant that contains a Microsoft Power Bl report named Report 1. Report1 includes a Python visual. Data displayed by the visual is grouped automatically and duplicate rows are NOT displayed. You need all rows to appear in the visual. What should you do?

A. Modify the Sort Column By property for all columns.

B. Reference the columns in the Python code by index.

C. Add a unique field to each row.

D. Modify the Summarize By property for all columns.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

You have a Microsoft Power Bl semantic model.
You plan to implement calculation groups.
You need to create a calculation item that will change the context from the selected date to month-to-date (MTD).
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解：

出題：6

You have a Fabric tenant that contains a data pipeline.
You need to ensure that the pipeline runs every four hours on Mondays and Fridays.
To what should you set Repeat for the schedule?

A. By the minute

B. Weekly

C. Daily

D. Hourly

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

You have a Fabric tenant that contains a warehouse.
Several times a day. the performance of all warehouse queries degrades. You suspect that Fabric is throttling the compute used by the warehouse.
What should you use to identify whether throttling is occurring?

A. dynamic management views (DMVs)

B. the Monitoring hub

C. the Capacity settings

D. the Microsoft Fabric Capacity Metrics app

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

You have a Fabric tenant that contains a warehouse.
A user discovers that a report that usually takes two minutes to render has been running for 45 minutes and has still not rendered.
You need to identify what is preventing the report query from completing.
Which dynamic management view (DMV) should you use?

A. sys.dm._exec._connections

B. sys.dm-exec_requests

C. sys.dn_.exec._sessions

D. sys.dm_pdw_exec_requests

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

What should you recommend using to ingest the customer data into the data store in the AnatyticsPOC workspace?

A. a stored procedure

B. a pipeline that contains a KQL activity

C. a Spark notebook

D. a dataflow

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：10

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 Fabric tenant that contains a semantic model named Model1.
You discover that the following query performs slowly against Model1.

You need to reduce the execution time of the query.
Solution: You replace line 4 by using the following code:

Does this meet the goal?

A. No

B. Yes

正解：B 解答を投票する

DP-600試験無料問題集「Microsoft Implementing Analytics Solutions Using Microsoft Fabric 認定」