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

Questions 31–34

1. 31foundation · easy

   You need to reduce the I/O latency for SQL Server on an Azure Virtual Machine by placing the data and log files on separate disks. What is the primary benefit of this configuration?

   • AIt reduces I/O contention between data and log operations
   • BIt allows independent scaling of storage
   • CIt reduces the risk of data corruption
   • DIt simplifies backup management
   Reveal Solution Discussion Select an answer first
2. 32foundation · easy

   You need to increase the storage capacity of an Azure SQL Managed Instance. Which setting should you modify?

   • AThe vCore count
   • BThe service tier
   • CThe max storage size
   • DThe maintenance window
   Reveal Solution Discussion Select an answer first
4. 33expert · hard

   A large table in an Azure SQL Database is partitioned by month. The table has a clustered columnstore index. You need to archive data older than 2 years. The archive process must be fast and not affect ongoing queries. What should you do?

   • ADisable compression on old partitions and then delete.
   • BDelete the old rows using a DELETE statement with a date filter.
   • CRebuild the columnstore index to remove old data.
   • DUse partition switching to move old partitions to a staging table, then drop the staging table.
   Reveal Solution Discussion Select an answer first
5. 34expert · hard

   A SQL Server on Azure VM runs a database with a large table that is frequently updated. The table has a clustered index and several nonclustered indexes. You notice that index fragmentation is high and queries are slow. You need to improve performance with minimal downtime. What should you do?

   • AReorganize all indexes.
   • BDisable the nonclustered indexes and rebuild them later.
   • CRebuild all indexes with the ONLINE option.
   • DDrop and recreate the nonclustered indexes.
   Reveal Solution Discussion Select an answer first