04 Chapter 04 DP-300T00A-Trainer-Files-Administering-Relational

Which Performance Monitor counter reflects how long SQL Server expects to retain data in memory?

• Page Life Expectancy
• Processor Queue Length
• Paging File Usage

Which Extended Events target only writes to memory and is not persisted ?

• Ring Buffer
• Target File
• Event Tracking for Windows

If you want to see the sizes of your SQL Server Databases running in an Azure VM, which tool should you use?

• The SQL VM Resource Provider
• Azure Monitor
• Intelligent Insights

Which type of storage should be used in conjunction with Azure VMs for SQL Server _x000B_data files?

• Disk Storage
• Table Storage
• Blob Storage

Which of the following can be limited using Resource Governor?

• Write IOPs
• Buffer Pool Allocation
• Recompilation

Which is an option from the SQL Server Resource Provider for Azure VMs?

• Storage configuration
• Maintenance plan
• Resource Governor

Which intelligent query processing feature allows for faster calculations of a large number of rows?

• Batch Mode on Row Store
• Approximate Count Distinct
• Interleaved Execution

Which component of resource governor allows you to configure limits on system resources?

• Resource Pools
• Workload Groups
• Classifier Functions

You need to migrate a set of databases that use distributed transactions from on-premises SQL Server. Which of the following options should you choose?

• Azure SQL Managed Instance
• Azure SQL Database
• SQL Server in an Azure VM