70-764 Administering a SQL Database Infrastructure - Practice Questions

Question 19

You administer a Microsoft SQL Server 2016 instance that has several SQL Server Agent jobs configured.

SQL Server Agent jobs fail, the error messages returned by the job steps are truncated.

The following error message is an example of the truncated error message:

Error 2012-06-23 183536.87 Code 0XC001000E Source UserImport Description Code 0x00000000 Source Log Import Activity Descript... The package execution fa... The step failed."

You need to ensure that all the details of the job step failures are retained for SQL Server Agent jobs.

What should you do?

Select an option, then click Submit answer.

○
Expand agent logging to include information from all events.
○
Disable the Limit size of job history log feature.
○
Configure event forwarding.
○
Configure output files.

Question 20

You are a database administrator for a Microsoft SQL Server 2016 environment.

You want to deploy a new application that will scale out the workload to at least five different SQL Server instances.

You need to ensure that for each copy of the database, users are able to read and write data that will then be synchronized between all of the database instances.

Which feature should you use?

Select an option, then click Submit answer.

○
Database Mirroring
○
Peer-to-Peer Replication
○
Log Shipping
○
Availability Groups

70-764 – Administering a SQL Database Infrastructure