What should you in the recommendation?

You need to recommend a solution to resolve the query issue of the serverless SQL pool. The solution must minimize impact on the users.

What should you in the recommendation?
A . Update the statistics for the serverless SQL pool.
B . Move the data from the serverless SQL pool to a dedicated Apache Spark pool.
C . Execute the sp_sec_process_daca_limic stored procedure for the serverless SQL pool.
D . Move the data from the serverless SQL pool to a dedicated SQL pool.

View Answer

Answer: D

Explanation:

Users indicate that queries against the serverless SQL pool fail occasionally because the size of tempdb has been exceeded.

In the dedicated SQL pool resource, temporary tables offer a performance benefit because their results are written to local rather than remote storage.

Temporary tables in serverless SQL pool.

Temporary tables in serverless SQL pool are supported but their usage is limited. They can’t be used in queries which target files.

For example, you can’t join a temporary table with data from files in storage. The number of temporary tables is limited to 100, and their total size is limited to 100 MB.

Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-temporary