Optimize Performance DP-700 Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   Which Spark optimization technique avoids shuffling large datasets by sending a small copy of one table to each executor to perform a join locally?

   • ABroadcast join
   • BSort-merge join
   • CShuffle hash join
   • DCartesian join
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   An Eventstream ingests clickstream data from a website into an Eventhouse. The eventstream currently uses a single partition and default batching. The ingestion rate is high, and the Eventhouse queries are slow because of the high volume of data. Which action should the engineer take to improve the eventstream throughput and Eventhouse query performance?

   • ADecrease the batching interval to send data more frequently.
   • BUse a single partition to maintain ordering.
   • CIncrease the number of partitions on the eventstream and enable data compression.
   • DDisable compression to reduce CPU usage.
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A data pipeline runs daily and loads a large CSV file from a legacy system into a Lakehouse. The pipeline currently uses a Copy activity that reads the entire file with a single partition, causing long runtimes. The file is 50 GB and contains no header row. What should you configure to reduce the runtime?

   • AConvert the CSV to Parquet before loading using a Dataflow Gen2.
   • BIncrease the Spark executor memory in the pipeline's default cluster.
   • CSet the copy activity's data integration unit (DIU) to Auto and enable parallel copy.
   • DEnable staging and use a wildcard file path to split the file into multiple chunks.
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A Fabric warehouse has a large fact table and a small dimension table. Queries joining these tables are slow because the query optimizer chooses a hash join. The dimension table is 10 MB. What should you do to improve query performance?

   • AAdd a nonclustered index on the fact table's foreign key.
   • BIncrease the warehouse's compute size.
   • CUse a broadcast join hint in the query.
   • DRewrite the query to use a subquery instead of a join.
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which Eventstreams feature allows you to group multiple events that arrive close in time into a single batch, reducing the number of writes to the destination?

   • AEvent batching
   • BEvent filtering
   • CEvent serialization
   • DEvent partitioning
   Reveal Solution Discussion Select an answer first