Demo Microsoft DP-700 Exam Questions

Demo practice questions for guest users.

Section: Practice Mode 12 Questions
Demo Practice
Back To Exam
Question 1

You need to ensure that the data analysts can access the gold layer lakehouse.
What should you do?


Correct Answer: C
Explanation:
Data Analysts' Access Requirements must only have read access to the Delta tables in the gold layer
and not have access to the bronze and silver layers.
The gold layer data is typically queried via SQL Endpoints. Granting the Read all SQL Endpoint data
permission allows data analysts to query the data using familiar SQL-based tools while restricting
access to the underlying files.
Question 2

HOTSPOT
You need to recommend a method to populate the POS1 data to the lakehouse medallion layers.
What should you recommend for each layer? To answer, select the appropriate options in the answer
area.
NOTE: Each correct selection is worth one point.

Correct Answer: A
Explanation:

A screenshot of a computer Description automatically generated
Bronze Layer: A pipeline Copy activity
The bronze layer is used to store raw, unprocessed data. The requirements specify that no
transformations should be applied before landing the data in this layer. Using a pipeline Copy activity
ensures minimal development effort, built-in connectors, and the ability to ingest the data directly
into the Delta format in the bronze layer.
Silver Layer: A notebook
The silver layer involves extensive data cleansing (deduplication, handling missing values, and
standardizing capitalization). A notebook provides the flexibility to implement complex
transformations and is well-suited for this task.
Question 3

HOTSPOT You need to meet the development requirements for the FeedbackJson column 

How should you complete the Transact SQL query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. 

Correct Answer: A
Explanation:
These three selections are the correct way to complete the query because they align exactly with the stated requirements for the FeedbackJson column. First, to extract the customer feedback text from the JSON document, the correct expression is JSON_VALUE(f.FeedbackJson, '$.text') AS FeedbackText. Microsoft documents that JSON_VALUE is used to extract a scalar value from JSON, while JSON_QUERY is used for returning an object or array. Since $.text is the textual feedback string, JSON_VALUE is the correct function. Second, to filter rows where the JSON text contains a keyword, the best choice is CONTAINS(FeedbackJson, @Keyword). The scenario explicitly states that FeedbackJson already has a full-text index, and Microsoft documents that CONTAINS is the full-text predicate used in the WHERE clause to search full-text indexed character data. That makes it more appropriate than using EDIT_DISTANCE for keyword filtering. Third, to order the results by similarity score, highest first, the correct item is SimilarityScore in the ORDER BY clause, which would be paired with DESC in the query. This matches the requirement to sort by the computed fuzzy similarity value. The DP-800 study guide specifically includes writing queries that use fuzzy string matching functions such as EDIT_DISTANCE, which supports the earlier computed SimilarityScore expression in the query. JSON_VALUE(f.FeedbackJson, '$.text') AS FeedbackText CONTAINS(FeedbackJson, @Keyword) SimilarityScore 

Demo Practice Mode

You are viewing only the questions marked as Demo.

BACK TO EXAM