Free Microsoft 070-765 Exam Dumps Questions & Answers

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?

• A.  Import/Export wizard
• B.  Diskspd
• C.  SQL Profiler trace using TSQL template
• D.  SQL Server Logs

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.

Correct Answer:

You plan to deploy multiple Microsoft SQL Servers to a set of Windows Server virtual machines. You create the following configuration file:

You run the following batch file to start the installation:

The Postinstall. Sq1 script contains the following Transact-SQL statements;

You need to evaluate the installation process.
What changes are made during the installation?
To answer, select the appropriate responses in the answer area.

Correct Answer:

You are the administrator of a Microsoft SQL Server 2014 server.
Some applications consume significant resources. You need to manage the server workload by restricting resource-intensive applications You need to dynamically limit resource consumption.
What should you do?

• A.  Create a new plan Guide with a Scope Type of sql and define the resource limits for each application
• B.  Create a new rule for each application that sets the resource limit allowed
• C.  Set up Service Broker to ensure that application are not allowed to consume more than the specified amount of resource
• D.  Configure Resource Pools, Workload Groups, and Classifier Function, and then enable the Resource Governor

You administer a Microsoft SQL Server 2014 database named ContosoDb. Tables are defined as shown in the exhibit. (Click the Exhibit button.)

You need to display rows from the Orders table for the Customers row having the CustomerId value set to 1 in the following XML format.

Which Transact-SQL query should you use?

• A.  SELECT Name AS `Customers/Name', CountryAS `Customers/Country', OrderId, OrderDate, AmountFROM OrdersINNER JOIN CustomersON Orders.CustomerId= Customers.CustomerIdWHERE Customers.CustomerId= 1FOR XML PATH (`Customers'
• B.  SELECT OrderId, OrderDate, Amount, Name, CountryFROM OrdersINNER JOIN CustomersON Orders.CustomerId = Customers-CustomerIdWHERE Customers.CustomerId = 1FOR XML RAW
• C.  SELECT Name, Country, Crderld, OrderDate, AmountFROM OrdersINNER JOIN CustomersON Orders.CustomerId= Customers.CustomerIdWHERE Customers.CustomerId= FOR XML AUTO, ELEMENTS
• D.  SELECT Name AS `@Name', Country AS `@Country', OrderId, OrderDate, AmountFROM OrdersINNER JOIN CustomersON Orders.CustomerId= Customers.CustomerIdWHERE Customers.CustomerId = 1FOR XML PATH (`Customers')
• E.  SELECT OrderId, OrderDate, Amount, Name, CountryFROM OrdersINNER JOIN CustomersON Orders.CustomerId = Customers.CustomerIdWHERE Customers.CustomerId = 1FOR XML AUTO
• F.  SELECT OrderId, OrderDate, Amount, Name, CountryFROM OrdersINNER JOIN CustomersON Orders.CustomerId = Customers.CustomerIdWHERE Customers.CustomerId= 1FOR XML AUTO, ELEMENTS
• G.  SELECT Name, Country, OrderId, OrderDate, AmountFROM OrdersINNER JOIN CustomersON Orders.CustomerId= Customers.CustomerIdWHERE Customers.CustomerId= FOR XML AUTO
• H.  SELECT OrderId, OrderDate, Amount, Name, CountryFROM Orders INNER JOIN CustomersON Orders.CustomerId = Customers.CustomerIdWHERE Customers.CustomerId = 1FOR XML RAW, ELEMENTS