070-765 무료 덤프문제 온라인 액세스
| 시험코드: | 070-765 |
| 시험이름: | Provisioning SQL Databases |
| 인증사: | Microsoft |
| 무료 덤프 문항수: | 268 |
| 업로드 날짜: | 2026-08-10 |
You must optimize DB1 for queries that use unknown variables. DB2 must not allow queries to run in parallel.
You need to configure the databases.
In the table below, identify the parameter that must be configured for each database.
NOTE: Make only one selection in each column.
You are configuring a table to use the Always Encrypted feature. The table will have the columns configured as shown in the following table.
All the columns will be encrypted by using the AEAD_AES_256_CBC_HMAC_SHA_256 algorithm. Values will be stored in the most secure way possible.
Which two columns should use randomized encryption? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Your company has several Microsoft Azure SQL Database instances used within an elastic pool.
You need to obtain a list of databases in the pool.
How should you complete the commands? To answer, drag the appropriate segments to the correct targets. Each segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
You develop a Microsoft SQL Server 2014 database that contains a heap named OrdersHistorical.
You write the following Transact-SQL query:
INSERT INTO OrdersHistorical
SELECT * FROM CompletedOrders
You need to optimize transaction logging and locking for the statement.
Which table hint should you use?
You have an AlwaysOn availability group on Microsoft Azure virtual machines. All the virtual machines are on a virtual network that uses an of 10.0.0.0/24.
You plan to deploy a new replica to an additional Azure virtual machine.
You deploy the new virtual machine by using an Azure virtual machine template that has SQL Server preconfigured.
The network security group for the new virtual machine is configured as shown in the following exhibit.
drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic, Each correct selection is worth one point.
