Microsoft Provisioning SQL Databases Set 2

You manage a Microsoft SQL Server environment in a Microsoft Azure virtual machine. You must enable Always Encrypted for columns in a database. You need to configure the key store provider. What should you do?

You have Microsoft SQL Server on a Microsoft Azure Virtual machine. The virtual machine has a database named DB1. You need to identify the fragmentation percentage for the indexes of DB1. Which dynamic management view should you query?

You have the databases configured as shown in the following table. Which two databases can use the Stretch Database feature? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

You have a database named DB1 that is 3 TB. DB1 contains a fact table that is 1.2 TB. You load 200 GB of new data to the fact table from a line-of-business application. Users of DB1 notice that reports render more slowly after you loaded the data. What are two possible causes of the performance issue? Each correct answer presents a complete solution. 885CB989129A5F974833949052CFB2F2 NOTE: Each correct selection is worth one point.

A company hosts a default installation of Microsoft SQL Server 2017 on a Linux-based server. You observe that the performance of the server has degraded. Process for allocating tables show high latency. You need to recommend a solution to improve performance when allocating tables. What should you recommend?

You deploy a new Microsoft Azure SQL Database instance to support a variety of mobile applications and public websites. 885CB989129A5F974833949052CFB2F2 You have the following requirements: You must be able to replicate the database to Azure datacenters in other regions by using geo-replication. Clients must only connect to the Azure SQL Database by using contained database users. You must be able to move the database to other servers in the future. Only applications in the 23.96.52.0-23.96.52.255 IP range are permitted to access the database. The firewall settings for the instance must not provide access to any other Azure services. You need to configure the firewall settings for the environment. Which three actions should you perform? Each correct answer presents part of the solution.

You administer a Microsoft SQL Server 2012 server. One of the databases on the server supports a highly active OLTP application. Users report abnormally long wait times when they submit data into the application. You need to identify which queries are taking longer than 1 second to run over an extended period of time. What should you do?

You administer a Microsoft SQL Server database. You need to ensure that the size of the transaction log file does not exceed 2 GB. What should you do?

You plan to deploy a Microsoft SQL Server database engine instance to an existing server. The server is in a remote location that is not physically secure. It is the only server in that location. The server runs a read-only domain controller (RODC), read-only DNS server, and read-only global catalog server. You are not permitted to add other Windows roles and features. You must not remove the RODC feature from the server. The SQL Server installation process fails. You need to modify the environment to allow the installation of SQL Server while minimizing costs. What should you do?

You manage a Microsoft SQL Server instance named SQL1 that has 32 gigabytes (GB) of total memory. The instance supports an app named App1 that only uses a single thread. App1 frequently queries the database using the same index. The operating system and App1 combined require 8 GB of memory to function. You need to ensure that the SQL Server does not limit the performance of App1. What configuration option should you set?