Microsoft Provisioning SQL Databases - 070-765 Exam Practice Test
You plan to deploy Microsoft SQL Server on a Microsoft Azure Virtual machine. The virtual machine will have a 30-TB database and will have 10 1-TB VHDs for the database.
You need to configure the storage to meet the following requirements:
Evenly distribute read and write operations across the VHDs.
Minimize the read and write time.
Which storage configuration should you use?
You need to configure the storage to meet the following requirements:
Evenly distribute read and write operations across the VHDs.
Minimize the read and write time.
Which storage configuration should you use?
Correct Answer: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You administer all the deployments of Microsoft SQL Server 2014 in your company. You have two servers in the same data center that hosts your production database.
You need to ensure that the database remains available if a catastrophic server failure or a disk failure occurs.
You also need to maintain transactional consistency of the data across both servers.
You need to achieve these goals without manual intervention.
Which configuration should you use?
You need to ensure that the database remains available if a catastrophic server failure or a disk failure occurs.
You also need to maintain transactional consistency of the data across both servers.
You need to achieve these goals without manual intervention.
Which configuration should you use?
Correct Answer: H
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You plan to install Microsoft SQL Server 2014 for a web hosting company.
The company plans to host multiple web sites, each supported by a SQL Server database.
You need to select an edition of SQL Server that features backup compression of databases, basic data integration features, and low total cost of ownership.
Which edition should you choose?
The company plans to host multiple web sites, each supported by a SQL Server database.
You need to select an edition of SQL Server that features backup compression of databases, basic data integration features, and low total cost of ownership.
Which edition should you choose?
Correct Answer: D
Vote an answer
You administer a Microsoft SQL Server 2014 instance. After a routine shutdown, the drive that contains tempdb fails.
You need to be able to start the SQL Server.
What should you do?
You need to be able to start the SQL Server.
What should you do?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You have Microsoft SQL Server on a Microsoft Azure Virtual machine. The virtual machine has a database named DB1.
You need to identify the fragmentation percentage for the indexes of DB1.
Which dynamic management view should you query?
You need to identify the fragmentation percentage for the indexes of DB1.
Which dynamic management view should you query?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You are migrating an on-premises Microsoft SQL Server virtual machine (VM) to an Azure IaaS VM.
The following chart shows current peak IOPS per hour over the course of a day:
You have a single-server on-premises Microsoft SQL Server deployment.
You must migrate the environment to an Azure virtual machine (VM). You must minimize costs while maintaining the same level of performance as the on-premises SQL environment.
You need to evaluate the number and types of read/write operations for the existing deployment.
Which tool should you use?
The number of IOPS per hour is expected to peak at 20 times the current value in the future.
Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.
The following chart shows current peak IOPS per hour over the course of a day:
You have a single-server on-premises Microsoft SQL Server deployment.
You must migrate the environment to an Azure virtual machine (VM). You must minimize costs while maintaining the same level of performance as the on-premises SQL environment.
You need to evaluate the number and types of read/write operations for the existing deployment.
Which tool should you use?
The number of IOPS per hour is expected to peak at 20 times the current value in the future.
Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.
Correct Answer:
You administer a Microsoft SQL Server 2016 instance.
You need to configure a new database to support FILETABLES.
What should you do? Choose all that apply.
You need to configure a new database to support FILETABLES.
What should you do? Choose all that apply.
Correct Answer: B,D,E
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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. You expect to have 100 users from each office.
In the past, users at remote sites reported issues when they used applications hosted at the Seattle office.
You need to optimize performance for users running reports while minimizing costs.
What should you do?
In the past, users at remote sites reported issues when they used applications hosted at the Seattle office.
You need to optimize performance for users running reports while minimizing costs.
What should you do?
Correct Answer: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You administer a Windows Azure SQL Database database named Inventory that contains a stored procedure named p_AddInventory.
Users need to be able to SELECT from all tables in the database and execute the stored procedure.
You need to grant only the necessary permissions.
What should you do?
Users need to be able to SELECT from all tables in the database and execute the stored procedure.
You need to grant only the necessary permissions.
What should you do?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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?
You must enable Always Encrypted for columns in a database.
You need to configure the key store provider.
What should you do?
Correct Answer: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You have just completed a new Microsoft SQL Server installation.
You need to configure a new SQL Server Agent alert to send an email to the DBA team for severity 20 errors.
Which three actions should you perform? Each correct answer presents part of the solution. (Choose three.)
You need to configure a new SQL Server Agent alert to send an email to the DBA team for severity 20 errors.
Which three actions should you perform? Each correct answer presents part of the solution. (Choose three.)
Correct Answer: B,D,F
Vote an answer
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 virtual machines.
You need to create the templates.
Solution: You use Visual Studio to create a XAML template that defines the deployment and configuration settings for the SQL Server environment.
Does the solution meet the goal?
Your company plans to use Microsoft Azure Resource Manager templates for all future deployments of SQL Server on Azure virtual machines.
You need to create the templates.
Solution: You use Visual Studio to create a XAML template that defines the deployment and configuration settings for the SQL Server environment.
Does the solution meet the goal?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).