You build a data warehouse in an Azure Synapse Analytics dedicated SQL pool. Analysts write a complex SELECT query that contains multiple JOIN and CASE statements to transform data for use in inventor

Question

Options

• Aan ordered clustered columnstore index
• Ba materialized view
• Cresult set caching
• Da replicated table

• A
  13% (5)
• B
  80% (32)
• C
  5% (2)
• D
  3% (1)

Explanation

Materialized views for dedicated SQL pools in Azure Synapse provide a low maintenance method for complex analytical queries to get fast performance without any query change. Incorrect Answers: C: One daily execution does not make use of result cache caching. Note: When result set caching is enabled, dedicated SQL pool automatically caches query results in the user database for repetitive use. This allows subsequent query executions to get results directly from the persisted cache so recomputation is not needed. Result set caching improves query performance and reduces compute resource usage. In addition, queries using cached results set do not use any concurrency slots and thus do not count against existing concurrency https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance- tuning-materialized-views https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/performance- tuning-result-set-caching

No community discussion yet for this question.