Online Access Free DP-700 Exam Questions

You have a Fabric workspace that contains a lakehouse named Lakehouse1.
In an external data source, you have data files that are 500 GB each. A new file is added every day.
You need to ingest the data into Lakehouse1 without applying any transformations. The solution must meet the following requirements Trigger the process when a new file is added.
Provide the highest throughput.
Which type of item should you use to ingest the data?

• A.Environment
• B.Data pipeline
• C.Dataflow Gen2
• D.KQL queryset

You need to return records ingested during the last 540 seconds.
Which KQL filter should you use?

• A.| where SecondsAgo = datetime_diff( ' second ' , now(), JobStartTime) < = 540
• B.| where SecondsAgo = datetime_diff( ' second ' , now(), ingestion_time()) < = 540
• C.| where SecondsAgo = datetime_diff( ' second ' , ingestion_time(), now()) < = 540
• D.| where SecondsAgo = datetime_diff( ' second ' , JobEndTime, JobStartTime) < = 540

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.3
• B.A
• C.2
• D.1

You need to implement the solution for the book reviews.
Which should you do?

• A.Create a Dataflow Gen2 dataflow.
• B.Create a shortcut.
• C.Create a data pipeline.
• D.Enable external data sharing.

You need to create the product dimension.
How should you complete the Apache Spark SQL code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
A screenshot of a computer Description automatically generated

Join between Products and ProductSubCategories:
Use an INNER JOIN.
The goal is to include only products that are assigned to a subcategory. An INNER JOIN ensures that only matching records (i.e., products with a valid subcategory) are included.
Join between ProductSubCategories and ProductCategories:
Use an INNER JOIN.
Similar to the above logic, we want to include only subcategories assigned to a valid product category. An INNER JOIN ensures this condition is met.
WHERE Clause
Condition: IsActive = 1
Only active products (where IsActive equals 1) should be included in the gold layer. This filters out inactive products.