Microsoft Provisioning SQL Databases 70-765 Exam Practice Test

Page: 1 / 14
Total 267 questions
Question 1

You administer a SQL Server 2014 database instance.

You need to configure the SQL Server Database Engine service on a failover cluster.

Which user account should you use?



Answer : A

References:

https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/install/create-a-new-sql-server-failover-cluster-setup


Question 2

You have Microsoft SQL Server on a Microsoft Azure virtual machine.

You have two Windows accounts named serviceAccount1 and ServiceAccount2. The SQL Server Agent runs as ServiceAccount1.

You need to run SQL Server Agent job steps by using ServiceAccount2.

Which cmdlet should you run first?



Answer : C

The New-ADServiceAccount command creates a new Active Directory managed service account or group managed service account object.


Question 3

Your database contains a table named Purchases. The table includes a DATETIME column named PurchaseTime that stores the date and time each purchase is made. There is a non- clustered index on the PurchaseTime column. The business team wants a report that displays the total number of purchases made on the current day. You need to write a query that will return the correct results in the most efficient manner.

Which Transact-SQL query should you use?



Answer : D

To compare a time with date we must use >= and > operators, and not the = operator.


Question 4

You plan to deploy an AlwaysOn failover cluster in Microsoft Azure. The cluster has a Service Level Agreement (SLA) that requires an uptime of at least 99.95 percent.

You need to ensure that the cluster meets the SLA.

Which cmdlet should you run before you deploy the virtual machine?



Answer : B

On Azure virtual machines, a SQL Server Availability Group requires a load balancer. The load balancer holds the IP address for the Availability Group listener. The New-AzureRmLoadBalancer cmdlet creates an Azure load balancer.


Question 5

You are developing customized Microsoft Azure Resource Group templates to automate the process of deploying Microsoft SQL Server in Azure to enforce consistency during future deployments.

You need to deploy the customized templates to the Azure environment and to external endpoints.

Which resource value should you populate?



Answer : C


Question 6

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 apply only to that question.

You have deployed several GS-series virtual machines (VMs) in Microsoft Azure. You plan to deploy Microsoft SQL Server in an Always On Availability Group. You expect to have less than 1 million IO transaction per month.

You need to recommend a storage solution for the SQL Servers. The solution must minimize costs.

Which storage option should you use?



Answer : A

P10 has 500 IOPS per disk, which provides for more than 1 million IOPS per month.

Note: 3600*30* 500 is 54 million IOPS/month.

References:

https://azure.microsoft.com/en-us/pricing/details/managed-disks/


Question 7

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?



Answer : D

Data that is written to a striped volume is interleaved to all disks at the same time instead of sequentially.

Therefore, disk performance is the fastest on a RAID 0 volume as compared to any other type of disk configuration.


https://support.microsoft.com/en-us/help/323433/how-to-establish-a-striped-volume-raid-0-inwindows-server-2003

Page:    1 / 14   
Total 267 questions