Demo Preview

DP-700 Safe Question Preview

This public preview shows limited demo-safe questions only. Correct answers, full explanations, paid-only media, private IDs, and attempt data are not included.

Implement and Manage an Analytics SolutionMonitor and Optimize an Analytics SolutionIngest and Transform DataDrag OrderMulti SelectMultiple Choice
Start Interactive DemoExam Landing Page

Preview Questions

Drag OrderImplement and Manage an Analytics Solution
Question 1. You need to ensure that the authors can see only their respective sales data. How should you complete the statement? To answer, drag the appropriate values 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. Answer:
A. SCHEMABINDING
B. USER_NAME()
C. FILTER
D. AuthorSales
Open safe question previewReport Question
Multi SelectMonitor and Optimize an Analytics Solution
Question 2. HOTSPOT You need to troubleshoot the ad-hoc query issue. How should you complete the statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer:
A. queryinsights.exec_requests_history
B. queryinsights.exec_sessions_history
C. queryinsights.frequently_run_queries
D. queryinsights.long_running_queries
E. last_run_total_elapsed_time_ms > 7200000
F. max_run_total_elapsed_time_ms > 7200000
G. median_total_elapsed_time_ms > 7200000
H. number_of_canceled_runs > 1
I. number_of_failed_runs > 1
J. number_of_runs > 1
Open safe question previewReport Question
Multiple ChoiceIngest and Transform Data
Question 3. 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. Enable external data sharing.
D. Create a data pipeline.
Open safe question previewReport Question
Multiple ChoiceIngest and Transform Data
Question 4. You need to resolve the sales data issue. The solution must minimize the amount of data transferred. What should you do?
A. Spilt the dataflow into two dataflows.
B. Configure scheduled refresh for the dataflow.
C. Configure incremental refresh for the dataflow. Set Store rows from the past to 1 Month.
D. Configure incremental refresh for the dataflow. Set Refresh rows from the past to 1 Year.
E. Configure incremental refresh for the dataflow. Set Refresh rows from the past to 1 Month.
Open safe question previewReport Question
Multi SelectIngest and Transform Data
Question 5. You need to create a workflow for the new book cover images. Which two components should you include in the workflow? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A. a notebook that uses Apache Spark Structured Streaming
B. a time-based schedule
C. an activator item
D. a data pipeline
E. a streaming dataflow
F. a blob storage action
Open safe question previewReport Question