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

You administer a Microsoft SQL Server 2014 database named Contoso on a server named Server01.
You need to prevent users from disabling server audits in Server01.
What should you create?

• A.A Server Audit Specification
• B.An Alert
• C.A SQL Profiler Trace
• D.An Extended Event session
• E.A Database Audit Specification
• F.A Policy
• G.A Resource Pool

You use Resource Manager to deploy a new Microsoft SQL Server instance in a Microsoft Azure virtual machine (VM) that uses Premium storage. The combined initial size of the SQL Server user database files is expected to be over 200 gigabytes (GB). You must maximize performance for the database files and the log file.
You add the following additional drive volumes to the VM:

You have the following requirements:
Maximize performance of the SQL Server instance.
Use Premium storage when possible.
You need to deploy the SQL instance.
In the table below, identify the drive where you must store each SQL Server file type.
NOTE: Make only one selection in each column. Each correct selection is worth one point.

정답:

Explanation:
Enable read caching on the disk(s) hosting the data files and TempDB.
Do not enable caching on disk(s) hosting the log file. Host caching is not used for log files.
Incorrect Answers:
C, D: Avoid using operating system or temporary disks for database storage or logging.
References:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance

You are migrating an on-premises database server to Microsoft SQL Server on a Microsoft Azure virtual machine. The virtual machine will use Premium Storage.
The on-premises database files for a user database are configured as shown in the following table.

What is the minimum number of VHDs that should be provisioned in Azure for each file type to meet the current IOPS needs? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

정답:

Explanation:
References:
https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy

You have an on-premises database.
You plan to migrate the database to Microsoft SQL Server on a Microsoft Azure virtual machine.
You move the database files to Azure.
You need to attach the database files to the SQL Server instance on the virtual machine. The solution must ensure that you can run file snapshot backups.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

정답:

Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-sql-server-transact-sql

You need to ensure that the columns are protected.
What should you use?

• A.Azure Key Vault
• B.persistent data masking
• C.cell-level encryption
• D.Always Encrypted