How should you design the solution?

November 23, 2020Pdfprep70-76570-765 exam questions, 70-765 practice exam, MCSA

HOTSPOT You need to set up the service accounts that the database engine and SQL Server Agent services will use. How should you design the solution? To answer, select the appropriate configuration options in the...

Read more +

Which storage option should you use?

November 23, 2020Pdfprep70-76570-765 exam questions, 70-765 practice exam, MCSA

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

Read more +

Does this meet the goal?

November 23, 2020Pdfprep70-76570-765 exam questions, 70-765 practice exam, MCSA

You have Microsoft SQL Server on a Microsoft Azure machine that has 12 databases. All database files are in the same Azure Blob account. You need to receive an email notification if I/O operation to...

Read more +

What is the minimum number of disks required for each database when using P30 storage disk type?

November 23, 2020Pdfprep70-76570-765 exam questions, 70-765 practice exam, MCSA

You plan to deploy Microsoft SQL Server on a Microsoft Azure virtual machine. The virtual machine will have two databases. Each database will reside on a separate VHD and will be between 600 and 800...

Read more +

Which argument insp_addmessage should you configure?

November 22, 2020Pdfprep70-76570-765 exam questions, 70-765 practice exam, MCSA

A Microsoft SQL Server instance has a database named Employees. The database contains information about employees including their salary. You must create a custom system message as an alert when an error is raised. You...

Read more +

What should you configure?

November 22, 2020Pdfprep70-76570-765 exam questions, 70-765 practice exam, MCSA

You administer a Microsoft SQL Server 2014 Enterprise Edition server that uses 64 cores. You discover performance issues when large amounts of data are written to tables under heavy system load. You need to limit...

Read more +

What should you do?

November 22, 2020Pdfprep70-76570-765 exam questions, 70-765 practice exam, MCSA

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

Read more +

Which storage option should you use?

November 22, 2020Pdfprep70-76570-765 exam questions, 70-765 practice exam, MCSA

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

Read more +

Which two databases can use the Stretch Database feature?

November 21, 2020Pdfprep70-76570-765 exam questions, 70-765 practice exam, MCSA

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

Read more +

For each setting, which value should you use?

November 21, 2020Pdfprep70-76570-765 exam questions, 70-765 practice exam, MCSA

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

Read more +