Here you have the best Microsoft 70-462 practice exam questions
Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You administer all the deployments of Microsoft SQL Server in your company.
You need to ensure that an OLTP database that uses a storage area network (SAN) remains available if any of the servers fail.
You also need to minimize the amount of storage used by the database.
Which configuration should you use?
To ensure the OLTP database remains available if any of the servers fail and to minimize the amount of storage used, configuring two servers on the same subnet with a SQL Server Availability Group in Synchronous-Commit Availability Mode is ideal. This setup ensures high availability and minimal data loss by keeping two copies of the data synchronized. Synchronous commit mode also ensures that transactions are committed on both the primary and secondary databases, which is crucial for maintaining data consistency. Using servers on the same subnet simplifies network configurations and can reduce some overhead, making it an efficient choice for minimizing storage and ensuring availability.
Note: This question is part of a series of questions that use the same set of answers choices. An answer choice may be correct for more than one question in the series.
You administer a Microsoft SQL Server server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database.
The recovery model and backup schedule are configured as shown in the following table:
The differential backup of the reporting database fails. Then, the reporting database fails at 14:00 hours.
You need to ensure that the reporting database is restored. You also need to ensure that data loss is minimal.
What should you do?
To restore the reporting database with minimal data loss, you need to restore the most recent successful backup. Since the latest differential backup failed, restoring it would not be viable. Therefore, the most recent successful backup is the latest full backup. By restoring the latest full backup, you ensure the data is restored to the last known good state with minimal data loss.
DRAG DROP -
You administer three Microsoft SQL Server 2012 servers named ServerA, ServerB, and ServerC.
ServerA is the acting principal and ServerB is the mirror.
You need to add ServerC as a witness to the existing mirroring session between ServerA and ServerB.
You need to achieve this goal without delaying synchronization.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Select and Place:
You administer a Microsoft SQL Server database.
You create an availability group named haContosoDbs. Your primary replica is available at Server01\Contoso01.
You need to configure the availability group to prevent data loss. In the event of a database failure, the designed secondary database must come online automatically.
Which Transact-SQL statement should you use?
To prevent data loss and ensure that the secondary database comes online automatically in the event of a failure, the configuration should use synchronous commit mode and automatic failover. Synchronous commit mode ensures that transactions are committed on both the primary and secondary replicas, thereby preventing data loss. Automatic failover ensures that the secondary replica takes over automatically without requiring manual intervention. Therefore, the correct Transact-SQL statement should modify the availability group with these settings.
You administer a Microsoft SQL Server 2012 instance that has several SQL Server Agent jobs configured.
When 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:
"Executed as user CONTOSO\ServiceAccount....0.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2011. All rights reserveD. Started 63513 PM 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?
To ensure that all details of job step failures are retained for SQL Server Agent jobs, configuring output files is the best option. This approach allows each step in the SQL Server Agent jobs to write its output to a specified file, thereby capturing full error messages without truncation. It provides a straightforward way to keep comprehensive logs for review whenever there is a job failure.