참고: ITDumpsKR에서 Google Drive로 공유하는 무료, 최신 DP-600 시험 문제집이 있습니다: https://drive.google.com/open?id=16gVTcjzxHyx7gQQa_EZnNERiJe_qqagM
Microsoft DP-600시험이 정말 어렵다는 말을 많이 들으신 만큼 저희 ITDumpsKR는Microsoft DP-600덤프만 있으면Microsoft DP-600시험이 정말 쉬워진다고 전해드리고 싶습니다. Microsoft DP-600덤프로 시험패스하고 자격증 한방에 따보세요. 자격증 많이 취득하면 더욱 여유롭게 직장생활을 즐길수 있습니다.
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Implementing Analytics Solutions Using Microsoft Fabric |
| Exam Number: | DP-600 |
| Exam Price: | $165 USD |
| Exam Duration: | 120 minutes |
| Related Certifications: | Microsoft Certified: Fabric Analytics Engineer Associate |
| Available Languages: | Japanese, Chinese (Simplified), English, Korean |
| Exam Format: | Multiple-choice, Drag-and-drop, Case studies |
| Passing Score: | 700/1000 |
| Certificate Validity Period: | 1 year |
| Real Exam Qty: | 40-60 |
| 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 |
ITDumpsKR의Microsoft인증DP-600자료는 제일 적중률 높고 전면적인 덤프임으로 여러분은 100%한번에 응시로 패스하실 수 있습니다. 그리고 우리는 덤프를 구매 시 일년무료 업뎃을 제공합니다. 여러분은 먼저 우리 ITDumpsKR사이트에서 제공되는Microsoft인증DP-600시험덤프의 일부분인 데모 즉 문제와 답을 다운받으셔서 체험해보실 수 잇습니다.
| 주제 | 소개 |
|---|---|
| 주제 1 |
|
| 주제 2 |
|
| 주제 3 |
|
질문 # 13
Hotspot Question
You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains a fact table named FactSales that has one billion rows.
You run the following T-SQL statement.
CREATE TABLE test.FactSales AS CLONE OF Dbo.FactSales;
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
정답：
설명：
Explanation:
The AS CLONE AS creates a replica of the original table by copying the metadata (no data).
The two copies are independent therefore any changes will not be inherited.
https://learn.microsoft.com/en-us/fabric/data-warehouse/clone-table
질문 # 14
You have a Microsoft Power Bl project that contains a semantic model. You plan to use Azure DevOps for version control.
You need to modify the .gitignore file to prevent the data values from the data sources from being pushed to the repository. Which file should you reference?
정답：D
설명：
When using Power BI Project (.pbip) with Git integration:
The .pbip project separates model metadata (schema, measures, relationships, etc.) from actual data values.
The localSettings.json file stores machine-specific and environment-specific settings, including data source credentials and local configurations. These should not be checked into version control to avoid exposing sensitive information or environment-specific configs.
Other options:
unappliedChanges.json # tracks unsaved changes, not data values.
model.bim # defines the semantic model schema (measures, relationships, metadata) and must be included in version control.
cache.abf # stores Analysis Services cache data, not part of source control.
Therefore, the correct file to exclude is localSettings.json.
Reference:
Power BI Projects and Git integration
localSettings.json in PBIP projects
질문 # 15
You have the source data model shown in the following exhibit.
The primary keys of the tables are indicated by a key symbol beside the columns involved in each key.
You need to create a dimensional data model that will enable the analysis of order items by date, product, and customer.
What should you include in the solution? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
정답：
설명：
Explanation:
The relationship between OrderItem and Product must be based on: Both the CompanyID and the ProductID columns The Company entity must be: Denormalized into the Customer and Product entities In a dimensional model, the relationships are typically based on foreign key constraints between the fact table (OrderItem) and dimension tables (Product, Customer, Date). Since CompanyID is present in both the OrderItem and Product tables, it acts as a foreign key in the relationship. Similarly, ProductID is a foreign key that relates these two tables. To enable analysis by date, product, and customer, the Company entity would need to be denormalized into the Customer and Product entities to ensure that the relevant company information is available within those dimensions for querying and reporting purposes.
References =
Dimensional modeling
Star schema design
질문 # 16
You need to resolve the issue with the pricing group classification.
How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
정답：
설명：
질문 # 17
You have a Fabric lakehouse named Lakehouse1 that contains the following data.
You need build a T-SQL statement that will return the total sales amount by OrderDate only for the days that are holidays in Australia. The total sales amount must sum the quantity multiplied by the price on each row in the dbo.sales table.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
정답：
설명：
Explanation:
Step 1: Requirement
We need to calculate total sales amount by OrderDate.
Total Sales Amount = Quantity × UnitPrice per row.
Then SUM over all rows per OrderDate.
Only include rows where the OrderDate matches a public holiday in Australia.
Step 2: Calculation Logic
If we select s.Quantity * s.UnitPrice, it only computes row-level values.
To calculate the total sales amount per OrderDate, we need:
SUM(s.Quantity * s.UnitPrice) AS TotalSalesAmt
Thus, the correct calculation: SUM(s.Quantity * s.UnitPrice)
Step 3: Join Type
We want to return only those sales that occurred on public holidays in Australia.
If we used a LEFT JOIN, we'd include all sales regardless of holiday.
A FULL OUTER JOIN would include non-matching rows, not required.
A CROSS JOIN would duplicate results unnecessarily.
A RIGHT OUTER JOIN would include holidays with no sales, which is not needed.
The correct choice is an INNER JOIN on matching dates.
Step 4: Final Query
SELECT
s.OrderDate,
SUM(s.Quantity * s.UnitPrice) AS TotalSalesAmt
FROM dbo.sales AS s
INNER JOIN dbo.publicholidays AS ph
ON s.OrderDate = ph.Date
WHERE ph.countryOrRegion = 'Australia'
GROUP BY s.OrderDate;
Why This is Correct
SUM(s.Quantity * s.UnitPrice) # ensures sales are aggregated correctly.
INNER JOIN # ensures only rows where OrderDate matches a holiday are included.
WHERE ph.countryOrRegion = 'Australia' # filters holidays to Australia only.
References
SUM (Transact-SQL)
JOIN operations in T-SQL
질문 # 18
......
DP-600시험합격: https://www.itdumpskr.com/DP-600-exam.html
그 외, ITDumpsKR DP-600 시험 문제집 일부가 지금은 무료입니다: https://drive.google.com/open?id=16gVTcjzxHyx7gQQa_EZnNERiJe_qqagM