You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 receives new data once every 24 hours. You have the following function. You have the…

Question

Exhibit

Options

• ACreate an index on the avg_f column.
• BConvert the avg_c column into a calculated column.
• CCreate an index on the sensorid column.
• DEnable result set caching.
• EChange the table distribution to replicate.

• A
  8% (2)
• B
  75% (18)
• C
  13% (3)
• E
  4% (1)

Explanation

A calculated column is a column that uses an expression to calculate its value based on other columns in the same table. In this case, the udfFtoC function can be used to calculate the avg_c value based on the avg_temperature column, eliminating the need to call the UDF in the SELECT Enabling result set caching can improve query performance by caching the result set of the query, so subsequent queries that use the same parameters can be retrieved from the cache instead of executing the query again. Creating an index on the avg_f column or the sensorid column is not useful because there are no join or filter conditions on these columns in the WHERE clause. Changing the table distribution to replicate is also not necessary because it does not affect the query performance in this scenario

No community discussion yet for this question.