70-765 exam

HOTSPOT You plan to migrate a Microsoft SQL Server workload from an on-premises server to a Microsoft Azure virtual machine (VM). The current server contains 4 cores with an average CPU workload of 6 percent and a peak workload of 10 percent when using 2.4Ghz processors. You gather the following...

Topic 5, Contoso, Ltd Case Study 2 Background You are the database administrator for Contoso, Ltd. The company has 200 offices around the world. The company has corporate executives that are located in offices in London, New York, Toronto, Sydney, and Tokyo. Contoso, Ltd. has a Microsoft Azure SQL Database...

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question...

You administer a Microsoft SQL Server 2014 database. The database contains a Product table created by using the following definition: You need to ensure that the minimum amount of disk space is used to store the data in the Product table. What should you do?A . Convert all indexes to...

You have a Microsoft SQL Server 2014 named SRV2014 that has a single tempdb database file. The tempdb database file is eight gigabytes (GB) in size. You install a SQL Server 2016 instance named SQL Server 2016 by using default settings. The new instance has eight logical processor cores. You...

Topic 1, Implementing SQL in Azure Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets stated goals. Your company plans to use Microsoft Azure Resource Manager templates for all future...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets stated goals. You have a mission-critical application that stores data in a Microsoft SQL Server instance. The application runs several financial...

You administer a Microsoft SQL Server 2014 server. You plan to deploy new features to an application. You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance. What should you do?A . Query the sys.dm_db_index_usage_stats DMC . Query the sys.dm_db_missing_index_details DME . Use the Database...

Note: This questions is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question...

HOTSPOT You need to create the contosodb1 database. How should you complete the Azure PowerShell command? To answer, select the appropriate Azure PowerShell segments in the answer area. View AnswerAnswer: Explanation: Box 1: New-AzureRmSqlDatabase New-AzureRmSqlDatabase creates a database or an elastic database. New-AzureRmSqlDatabase is a command with the Azure Resource...