What should you implement?

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...

January 5, 2019 No Comments READ MORE +

What should you do?

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. This leads to inconsistent performance for batch completion. You need...

January 4, 2019 No Comments READ MORE +

What should you do?

You administer a Microsoft SQL Server 2014 server. The MSSQLSERVER service uses a domain account named CONTOSOSQLService. You plan to configure Instant File Initialization. You need to ensure that Data File Autogrow operations use Instant File Initialization. What should you do? Choose all that apply.A . Restart the SQL Server...

January 4, 2019 No Comments READ MORE +

What configuration changes should you implement?

Topic 4, automobile parts Case Study 1 Background You manage the Microsoft SQL Server environment for a company that manufactures and sells automobile parts. The environment includes the following servers: SRV1 and SRV2. SRV1 has 16 logical cores and hosts a SQL Server instance that supports a mission-critical application. The...

January 3, 2019 No Comments READ MORE +

Which storage option should you use?

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...

December 30, 2018 No Comments READ MORE +

Does the solution meet the goal?

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 deployments of SQL Server on Azure...

December 26, 2018 No Comments READ MORE +

What configuration changes should you implement?

Topic 4, automobile parts Case Study 1 Background You manage the Microsoft SQL Server environment for a company that manufactures and sells automobile parts. The environment includes the following servers: SRV1 and SRV2. SRV1 has 16 logical cores and hosts a SQL Server instance that supports a mission-critical application. The...

December 25, 2018 No Comments READ MORE +

Which storage option should you use?

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...

December 21, 2018 No Comments READ MORE +

What should you do?

Topic 7, Mix Questions Set You administer a Microsoft SQL Server 2014 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...

December 12, 2018 No Comments READ MORE +

You need to open the firewall ports for use with SQL Server environment

HOTSPOT You need to open the firewall ports for use with SQL Server environment. In table below, identify the firewall port that you must use for each service. NOTE: Make only one selection in each column. View AnswerAnswer: Explanation: Report Server: 80 By default, the report server listens for HTTP...

December 11, 2018 No Comments READ MORE +