exam questions

Exam 70-537 All Questions

View all questions & answers for the 70-537 exam

Exam 70-537 topic 1 question 24 discussion

Actual exam question from Microsoft's 70-537
Question #: 24
Topic #: 1
[All 70-537 Questions]

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario.
Your company has a main office in New York and a branch office in Toronto. Each office has a dedicated connection to the Internet. Each office has a firewall that uses inbound and outbound rules.
The company has an on-premises network that contains several datacenters. The datacenters contain multiple hypervisor deployments, including Window Server
2016 Hyper-V. The network uses Microsoft System Center for monitoring and Windows Azure Pack for self-service.
The company has a Microsoft Azure subscription that contains several workloads. You use Azure Resource Manager templates and other automated processes to create and manage the resources in Azure.
You have an Azure Stack integrated system in the New York office. The company has a deployment team in the Toronto office and a development team in the
New York office. The system has an offer named Offer1. Several tenants have subscriptions based on Offer1.
You have a Hyper-V host named Server1 that runs Windows Server 2012 R2. Server1 is used for testing. The hardware on Server1 can support the deployment of the Azure Stack Development Kit.
You have a Generation 1 virtual machine named VM1 that runs Windows Server 2012 R2. VM1 is deployed to a Hyper-V host that runs Windows Server 2016.
VM1 has a fixed size disk named VM1.vhdx that is 200 GB.
End of repeated scenario.
You implement a SQL Server resource provider that uses D14v2 virtual machines.
A tenant creates a SQL database that runs several heavy workloads. The tenant reports that SQL queries are slow to complete.
You need to recommend changes to the Azure Stack integrated system to reduce the amount of time required to complete the SQL queries.
What should you recommend?

  • A. Resize the virtual machine that provides the Microsoft SQL Server service.
  • B. Instruct the tenant to install Microsoft SQL Server on a virtual machine in its subscription.
  • C. In the Azure Stack integrated system, cluster the D14v2 virtual machines.
  • D. Deploy a physical server that has more resources that the D14v2 virtual machines. Install Microsoft SQL Server on the server. Add the server to the SQL Server resource provider.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
PanKok
4 years, 4 months ago
https://docs.microsoft.com/en-us/azure-stack/operator/azure-stack-sql-resource-provider-hosting-servers?view=azs-2008
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago