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

You configure log shipping on two servers named SQL1 and sql2. SQL2 is in Standby mode.
You configure backup and restore to occur every hour.
A user generates a report from sql2 and discovers that the report data is out-of-date.
You verify that the report data is a day old and discover that the primary backup files are available only on SQL1.
You need to identify what prevents the primary backup files from being available on sql2.
Which two actions should you perform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A.From Microsoft SQL Server Management Studio on SQL1, run the Transaction Log Shipping Status report.
• B.From SQL2, execute the SP_log_shipping_monitor_secondary system stored procedure.
• C.From SQL1, review the SQL Server Agent job history log.
• D.From SQL1, execute the SP_log_shipping_monitor_secondary system stored procedure.
• E.From Microsoft SQL Server Management Studio on SQL2, run the Transaction Log Shipping Status report.

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 are the database administrator for a company that hosts Microsoft SQL Server. You manage both on-premises and Microsoft Azure SQL Database environments. A service account has the required permissions to backup all databases.
You have a user database named HRDB that contains sensitive human resources data. The HRDB backup files must be encrypted.
You need to grant the service account that backs up the HRDB database the permission necessary to access the encryption key. Your solution must use the principle of least privilege.
Which permission should you grant?

• A.dbcreator
• B.View Database State
• C.dbo
• D.View ServerState
• E.db_datawriter
• F.View Definition
• G.sysadmin
• H.DDLAdmin

You manage a Microsoft SQL Server environment. A server fails and writes the following event to the application event log:
MSG_AUDIT_FORCED_SHUTDOWN
You configure the SQL Server startup parameters as shown in the following graphic:

Use the drop-down menus to select the answer choice that answers each question.
NOTE: Each correct selection is worth one point.

정답:

Explanation

Box 1: single-user
The startup option -m starts an instance of SQL Server in single-user mode.
Box 2: sysadmin
Starting SQL Server in single-user mode enables anymember of the computer's local Administrators group to connect to the instance of SQL Server as a member of the sysadmin fixed server role.
References:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/database-engine-service-startup-option

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.
A company is deploying a Microsoft SQL Server environment in Microsoft Azure.
Backups need to be performed and managed automatically.
You need to configure the SQL Server backup.
Which option should you use?

• A.backup compression
• B.file snapshot backup
• C.SQL Server Managed Backup to Azure
• D.tail-log backup
• E.SQL Server backup to URL
• F.mirrored backup media sets
• G.back up and truncate the transaction log
• H.backup encryption

You are creating an application that will connect to the AgentPortal database by using a SQL login named AgentPortalUser. Stored procedures in the database will use sp_send_dbmail to send email messages.
You create a user account in the msdb database for the AgentPortalUser login.
You use the Database Mail Configuration Wizard to create a Database Mail profile. Security has not been configured for the Database Mail profile.
You need to ensure that AgentPortalUser can send email messages.
What should you do?

• A.In the Database Mail Configuration Wizard, configure the Database Mail profile as a private profile for the AgentPortalUser account.
• B.In the Database Mail Configuration Wizard, create an email account for each recipient's email address in the Database Mail profile.
• C.Disable the guest user in the msdb database.
• D.Use the sysmail_help_profileaccount_sp stored procedure to add accounts to the Database Mail profile.