さらに、ShikenPASS DP-600ダンプの一部が現在無料で提供されています：https://drive.google.com/open?id=1dQIKzyoga-HD4HVEkFA7C8vh8Y7ryB5C
他の同様の教育プラットフォームとは異なり、DP-600クイズガイドは、分類なしのランダムな蓄積ではなく、マルチプレート配布用の資料を割り当てます。 DP-600準備トレントは、さまざまな文化レベルのユーザーにより適したDP-600テスト資料を開発するために、従来の学習プラットフォームの利点に吸収され、その欠点を認識しています。そして、DP-600試験材料は、プレートの多くの研究部分がユーザーの熱意を喚起するのに十分であり、ユーザーが集中力を維持できるようにします。
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Implementing Analytics Solutions Using Microsoft Fabric |
| Exam Number: | DP-600 |
| Exam Duration: | 120 minutes |
| Certificate Validity Period: | 1 year |
| Exam Price: | $165 USD |
| Related Certifications: | Microsoft Certified: Fabric Analytics Engineer Associate |
| Passing Score: | 700/1000 |
| Available Languages: | Japanese, English, Korean, Chinese (Simplified) |
| Real Exam Qty: | 40-60 |
| Exam Format: | Drag-and-drop, Case studies, Multiple-choice |
| Sample Questions: | Microsoft DP-600 Sample Questions |
| Exam Way: | Online proctored or in-person testing center |
| Pre Condition: | Candidates should have foundational knowledge of data concepts, experience with Microsoft Fabric, and proficiency in data transformation and modeling. Familiarity with Power BI is recommended but not required. |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/certifications/exams/dp-600 |
ShikenPASSを利用するのは君の合格率を１００％保証いたします。ShikenPASSは多種なMicrosoft認証試験を受ける方を正確な資料を提供者でございます。弊社の無料なDP-600サンプルを遠慮なくダウンロードしてください。
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
質問 # 28
You have a KQL database that contains a table named Readings.
You need to query Readings and return the results shown in the following table.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
Explanation:
Comprehensive Detailed Explanation
We need to query a KQL database table named Readings to generate output that includes both the current reading and the previous reading values and datetime for each row.
Step 1: Understanding Requirements
The output table shows:
City, Area, MeterReading, Datetime
PrevMeterReading, PrevDatetime
The prev() function in KQL is used to access the value of a column from the previous row (based on order).
Step 2: Query Construction
We start with filtering:
Readings
| where City == " Copenhagen "
| sort by Datetime
To add columns that calculate the previous reading and previous datetime, we use extend:
| extend PrevMeterReading = prev(MeterReading), PrevDatetime = prev(Datetime) extend creates new columns.
prev() pulls the previous row's values.
Finally, we only want specific columns in the output. For this, we use project:
| project City, Area, MeterReading, Datetime, PrevMeterReading, PrevDatetime Step 3: Completed Query Readings
| where City == " Copenhagen "
| sort by Datetime
| extend PrevMeterReading = prev(MeterReading), PrevDatetime = prev(Datetime)
| project City, Area, MeterReading, Datetime, PrevMeterReading, PrevDatetime Why This is Correct extend adds calculated columns.
prev() gives access to the previous row.
project selects only the required columns.
This matches exactly the table shown in the question.
References
Kusto Query Language - extend operator
Kusto Query Language - project operator
prev() function in KQL
質問 # 29
You are creating a dataflow in Fabric to ingest data from an Azure SQL database by using a T-SQL statement.
You need to ensure that any foldable Power Query transformation steps are processed by the Microsoft SQL Server engine.
How should you complete the code? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
正解：
解説：
Explanation:
You should complete the code as follows:
* Table
* NativeQuery
* EnableFolding
In Power Query, using Table before the SQL statement ensures that the result of the SQL query is treated as a table. NativeQuery allows a native database query to be passed through from Power Query to the source database. The EnableFolding option ensures that any subsequent transformations that can be folded will be sent back and executed at the source database (Microsoft SQL Server engine in this case).
質問 # 30
Which workspace rote assignments should you recommend for ResearchReviewersGroupl and ResearchReviewersGroupZ? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
Explanation:
In Azure DevOps workspace (project) security settings, role assignments determine access levels for groups:
Viewer (equivalent to the Readers security group): Grants read-only access to work items, code, pipelines, and other artifacts. Ideal for review-only scenarios where users need to view but not edit content.
Contributor (equivalent to the Contributors security group): Allows full edit and contribute privileges, such as updating work items, code reviews, and pipeline runs. Suitable for active participation in reviews that may involve feedback or changes.
Based on the group names implying review-focused access, Viewer fits Group1 for passive observation, while Contributor fits Group2 for interactive review tasks. These align with default Azure DevOps permissions for secure, least-privilege access.
質問 # 31
You have a Fabric workspace named Workspace1 that contains a data flow named Dataflow1. Dataflow1 contains a query that returns the data shown in the following exhibit.
You need to transform the date columns into attribute-value pairs, where columns become rows.
You select the VendorlD column.
Which transformation should you select from the context menu of the VendorlD column?
正解：C
解説：
The transformation you should select from the context menu of the VendorID column to transform the date columns into attribute-value pairs, where columns become rows, is Unpivot columns (B). This transformation will turn the selected columns into rows with two new columns, one for the attribute (the original column names) and one for the value (the data from the cells). Reference = Techniques for unpivoting columns are covered in the Power Query documentation, which explains how to use the transformation in data modeling.
質問 # 32
You need to refresh the Orders table of the Online Sales department. The solution must meet the semantic model requirements. What should you include in the solution?
正解：C
解説：
Requirement: "The number of rows added to the Orders table during refreshes must be minimized." The Orders table has a sequential OrderID.
To minimize refresh size, you must only import new rows, not the entire table.
This requires retrieving the maximum OrderID currently loaded, then only loading rows with a greater OrderID.
So, the correct solution is to use a pipeline (ADF) with a dataflow to retrieve the maximum OrderID.
an Azure Data Factory pipeline that executes a dataflow to retrieve the maximum value of the OrderID column in the destination lakehouse
質問 # 33
......
DP-600試験攻略: https://www.shikenpass.com/DP-600-shiken.html
P.S. ShikenPASSがGoogle Driveで共有している無料かつ新しいDP-600ダンプ：https://drive.google.com/open?id=1dQIKzyoga-HD4HVEkFA7C8vh8Y7ryB5C