Online Access Free 070-462 Exam Questions
| Exam Code: | 070-462 |
| Exam Name: | Administering Microsoft SQL Server 2012/2014 Databases |
| Certification Provider: | Microsoft |
| Free Question Number: | 305 |
| Posted: | Sep 06, 2025 |
You administer a Microsoft SQL Server 2012 database.
The database uses SQL Server Agent jobs to perform regular FULL and LOG backups. The database uses the FULL recovery model.
You plan to perform a bulk import of a very large text file.
You need to ensure that the following requirements are met during the bulk operation:
* The database transaction log is minimally affected.
* The database is online and all user transactions are recoverable.
* All transactions are fully recoverable prior to the import.
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.)
You administer a Microsoft SQL Server 2012 database instance.
The instance is running on a server with the following configuration:
* 1 TB RAM
* SAN storage for database and log files
* 4 quad-core processors
* 64-Bit Windows 2008 R2 operating system
This instance hosts a database with large partitioned tables. Users report that complex queries are taking a long time to complete.
While troubleshooting, you discover that CPU utilization is low (less than 20 percent), disk activity is low (little or no waiting processes), and no significant blocking is occurring.
You need to ensure that the instance can process queries as quickly and efficiently as possible.
Which setting should you configure?
You administer a Microsoft SQL Server instance that contains a database of confidential data.
You need to encrypt the database files at the page level. You also need to encrypt the transaction log files.
Which four 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.)
