070-765 무료 덤프문제 온라인 액세스

A company plans to deploy Microsoft SQL Server databases in Azure. The following requirements must be met:
Resources must be shared across 200 databases.
Total pool storage must support at least two terabytes (TB)
You need to configure the Azure environment and minimize costs.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.

정답:

Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers

You upgrade a database named DB1 to Microsoft SQL Server 2016.
Users report that performance for several queries is degraded. You determine that the query optimizer is incorrectly estimating the number of rows that the queries will return.
You need to resolve the performance issues.
How should you complete the Transact-SQL statement? To answer, drag the Transact-SQL segments to the correct locations. Each Transact-SQL 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.

정답:

Explanation:
References:
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-scoped-configuration-transact-sql?view=sql-server-2017

You have Microsoft SQL Server on a Microsoft Azure virtual machine.
You create a SQL Server Agent job by using the following statement.

You need to send an email message if the job fails.
Which stored procedure should you use?

• A.msdb.dbo.sp_help_alert
• B.msdb.dbo.sp_add_jobstep
• C.msdb.dbo.sp_add_notification
• D.msdb. dbo. sp_updace_alerc

User report that a query takes a long time to execute. The query has the following wait statistics.

Which resource causes the issue?

• A.processor
• B.disk
• C.blocking
• D.network

You are the database administrator for your company. Your company has one main office and two branch offices. You plan to create three databases named DB1, DB2, and DB3 that will be hosted on one Azure SQL Database server. You have the following requirements:
The main office must be able to connect to all three databases.
The branch offices must be able to connect to DB2 and DB3.
The branch offices must not be able to access DB1.
You need to configure transparent data encryption (TDE) for DB1. Which two actions should you perform?
Each correct answer presents part of the solution.

• A.Run ALTER DATABASE DB1 SET ENCRYPTION ON;.
• B.Run CREATE CERTIFICATE certl WITH Subject = TDE Cert1 on DB1.
• C.Connect to the master database.
• D.Connect to DB1.
• E.Run CREATE MASTER KEY on the master database.