Configure Resources for Scale and Performance DP-300 Practice Questions (Page 6)

Questions 26–30

1. 26foundation · easy

   You need to reduce the cost of an Azure SQL Database while maintaining its current performance level. Which approach is most appropriate?

   • AMove the database to an elastic pool
   • BSwitch to a lower service tier with the same DTU count
   • CEnable auto-pause on the database
   • DUse Azure Hybrid Benefit for SQL Server
   Reveal Solution Discussion Select an answer first
2. 27application · medium

   An Azure SQL Managed Instance hosts a database with a large fact table. Queries that aggregate data by date are slow. The table has a clustered columnstore index. You notice that the index has high fragmentation and the queries are still slow. What should you do to improve performance?

   • AIncrease the instance's vCore count to speed up the scan.
   • BSwitch the table to a rowstore heap to reduce overhead.
   • CAdd a nonclustered index on the date column.
   • DRebuild the columnstore index to remove deleted rows and improve segment quality.
   Reveal Solution Discussion Select an answer first
4. 28application · medium

   A company has a large table in an Azure SQL Database that is frequently updated. The table is 500 GB and you want to reduce storage costs. You are considering compression. What should you do?

   • AEnable page compression on the table.
   • BEnable columnstore compression on the table.
   • CEvaluate the trade-off between compression savings and CPU overhead before enabling compression.
   • DEnable row compression on the table.
   Reveal Solution Discussion Select an answer first
5. 29application · medium

   An Azure SQL Managed Instance is running at 80% CPU for most of the day. The instance is used by multiple applications, and the workload is steady. You need to increase compute capacity to reduce CPU pressure. What should you do?

   • AEnable zone redundancy on the managed instance.
   • BAdd a read replica to offload read-only queries.
   • CIncrease the number of vCores in the same service tier.
   • DChange the service tier from General Purpose to Business Critical.
   Reveal Solution Discussion Select an answer first
6. 30foundation · easy

   You need to improve the performance of an Azure SQL Database by moving it to a higher performance level within the same service tier. Which action should you take?

   • AChange the database to a different service tier
   • BIncrease the number of DTUs or vCores assigned to the database
   • CApply an index recommendation from automatic tuning
   • DEnable read scale-out
   Reveal Solution Discussion Select an answer first