DP-700 practice questions 111–116

1. Question 111 · 116 in bank

   HOTSPOT - You are processing streaming data from an external data provider. You have the following code segment.

   

   For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   NO, YES, YES First row will be Washington, Contoso, 400 Fabrikam in Seattle will have 2 because row_rank_dense allows ties Yes, in both cases it will be 1

   Source: Adapted from community discussion — MDWPartners

   

   Next question

2. Question 112 · 116 in bank

   You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta table named Table1. You analyze Table1 and discover that Table1 contains 2,000 Parquet files of 1 MB each. You need to minimize how long it takes to query Table1. What should you do?

   • ADisable V-Order and run the OPTIMIZE command.
   • BDisable V-Order and run the VACUUM command.
   • CRun the OPTIMIZE and VACUUM commands.

   Show answer

   Answer: C

   Explanation

   OPTIMIZE: This will help compact the small Parquet files into larger files, improving the efficiency of queries. VACUUM: This will remove old versions of files that are no longer needed, freeing up storage and further optimizing performance.

   Source: Adapted from community discussion — GHill1982

   Next question

3. Question 113 · 116 in bank

   You have a Fabric workspace that contains a warehouse named Warehouse1. Data is loaded daily into Warehouse1 by using data pipelines and stored procedures. You discover that the daily data load takes longer than expected. You need to monitor Warehouse1 to identify the names of users that are actively running queries. Which view should you use?

   • Asys.dm_exec_connections
   • Bsys.dm_exec_requests
   • Cqueryinsights.long_running_queries
   • Dqueryinsights.frequently_run_queries
   • Esys.dm_exec_sessions

   Show answer

   Answer: E

   Explanation

   sys.dm_exec_connections: This view returns information about the current connections to the database instance, such as the client IP address, the login time, and the number of reads and writes. It focuses on connection details rather than identifying specific user queries. sys.dm_exec_requests: This view provides information about requests currently executing on the server, including the session ID, request status, and resource consumption. While it can show active requests, it doesn’t necessarily identify the specific users running the queries. The sys.dm_exec_sessions view, on the other hand, contains information about all active user connections and internal tasks, including details like the session ID and login name. This makes it more suitable for identifying which users are actively running queries in your database.

   Source: Adapted from community discussion — prabhjot

   References

   • Microsoft Learn

   Next question

4. Question 114 · 116 in bank

   You have a Fabric workspace that contains an eventstream named EventStream1. EventStream1 outputs events to a table in a lakehouse. You need to remove files that are older than seven days and are no longer in use. Which command should you run?

   • AVACUUM
   • BCOMPUTE
   • COPTIMIZE
   • DCLONE

   Show answer

   Answer: A

   References

   • Microsoft Learn

   Next question

5. Question 115 · 116 in bank

   You have a Fabric warehouse named DW1 that loads data by using a data pipeline named Pipeline1. Pipeline1 uses a Copy data activity with a dynamic SQL source. Pipeline1 is scheduled to run every 15 minutes. You discover that Pipeline1 keeps failing. You need to identify which SQL query was executed when the pipeline failed. What should you do?

   • AFrom Monitoring hub, select the latest failed run of Pipeline1, and then view the output JSON.
   • BFrom Monitoring hub, select the latest failed run of Pipeline1, and then view the input JSON.
   • CFrom Real-time hub, select Fabric events, and then review the details of Microsoft.Fabric.ItemReadFailed.
   • DFrom Real-time hub, select Fabric events, and then review the details of Microsoft. Fabric.ItemUpdateFailed.

   Show answer

   Answer: B

   Next question

6. Question 116 · 116 in bank

   You have a Fabric notebook named Notebook1 that has been executing successfully for the last week. During the last run, Notebook1executed nine jobs. You need to view the jobs in a timeline chart. What should you use?

   • AReal-Time hub
   • BMonitoring hub
   • Cthe job history from the application run
   • DSpark History Server
   • Ethe run series from the details of the application run

   Show answer

   Answer: E

   Explanation

   I'm going with E, 'the run series from the details of the application run.' This question is confusing, as we find the run series in the Monitoring hub

   Source: Adapted from community discussion — Tuki93

   References

   • Microsoft Learn

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DP-700 practice, question 111. 116 questions available.