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…
A company has an on-premises Microsoft SQL Server 2014 environment. The company has a main office in Seattle, and remote offices in Amsterdam and Tokyo. You plan to deploy a Microsoft Azure SQL Database instance to support a new application.…
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…
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…
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…
You are deploying a Microsoft SQL Server database that will support a mixed OLTP and OLAP workload. The target virtual machine has four CPUs. You need to ensure that reports do not use all available system resources. What should you…
You plan to deploy 20 Microsoft Azure SQL Database instances to an elastic pool in Azure to support a batch processing application. Two of the databases in the pool reach their peak workload threshold at the same time every day.…
You plan to migrate a database To Microsoft Azure SQL Database. The database requires 500 gigabytes (GB) of storage. The database must support 50 concurrent logins. You must minimize the cost associated with hosting the database. You need to create…
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 manage a Microsoft SQL Server environment with several databases. You…
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 manage a Microsoft SQL Server environment with several databases. You…