Online Access Free 070-462 Practice Test

Which of the following files keeps track of all transactions that occur in an SQL Server database?

• A.Data File
• B.Redo Log
• C.Archive Log
• D.Transaction Log

You administer two instances of Microsoft SQL Server 2012. You deploy an application that uses a database on the named instance.
The application is unable to connect to the database on the named instance.
You need to ensure that the application can connect to the named instance.
What should you do?

• A.Use the Data Quality Client to configure the application.
• B.Start the SQL Server Integration Services Service.
• C.Start the SQL Server Browser Service.
• D.Use the Master Data Services Configuration Manager to configure the application.

Which of the following conditions must exist prior to restoring a system database in SQL Server 2012?

• A.You must detach the user databases from the SQL 2012 instance.
• B.The hard drive must be reformatted.
• C.The SQL Server 2012 instance must be started in single-user mode.
• D.The SQL Server 2012 instance must be removed.

You work as the Senior Database Administrator (DBA) at ABC.com. The company has a main office and 10 branch offices. Each branch office contains a single database server running Microsoft SQL Server 2012. The main office has multiple clustered servers running Microsoft SQL Server 2012.
Your role includes the management of the entire Microsoft SQL Server 2012 infrastructure.
The company runs a custom application that stores data in a large Microsoft SQL Server 2012 database.
The primary database is hosted in the main office. Each branch office SQL Server hosts a copy of the database.
You need to configure a solution that will replicate the entire primary database from the main office SQL Server every weekend.
What should you include in your solution?

• A.Log Shipping
• B.Transactional Replication
• C.Snapshot Replication
• D.SQL Server Availability Group

You administer a Microsoft SQL Server 2012 database instance. Other applications run on the server. Some of the applications are throwing errors because of insufficient memory.
You need to ensure that the other applications have sufficient memory.
Which setting should you configure?

Correct Answer:

Explanation