I’ve been taking on some Microsoft certifications recently, and my latest success is passing the 70-462 exam, earning me the Microsoft Specialist. As all Microsoft certification exams, this exam covers a huge amount of information and content. As a result of this, a variety of materials and sources need to be studied in order to get the level understanding and memorization necessary to pass the exam. Now that I’ve passed the exam, I’d share that I used GreatExam 70-462 practice test.
Drag and Drop Question
You administer a Microsoft SQL Server 2012 database instance that uses transparent database encryption.
You plan to move the database from the current server to a new server by using Backup and Restore.
Drag and Drop Question
You are configuring a Microsoft SQL Server 2012 server and setting up a new database.
You need to ensure that the following requirements are met:
Provide access to the database for a Windows group named CORP\Employees. The database can be moved to another server with no additional changes to the security configuration of the database or server.
What should you do? (To answer, move the appropriate action or actions from the list of actions to the answer area and arrange them in the correct order.)
Which of the following conditions must exist prior to restoring a system database in SQL Server 2012?
A. The hard drive must be reformatted.
B. You must detach the user databases from the SQL 2012 instance.
C. The SQL Server 2012 instance must be started in single-user mode.
D. The SQL Server 2012 instance must be removed.
Which of the following is the default instance name in an SQL Server 2012 installation?
In which of the following statements about audit information stored in an SQL Server 2012 environment is TRUE?
A. It is located in a file specified in the File Path property of the Audit.
B. It is located in the Audit table in the MSDB database.
C. Each login has an audit record, which is viewable under Logins -> Audit.
D. SQL 2012 does not store any audit information.
Which of the following transaction safety setting in SQL Server 2012 mirroring forces the mirror to be synchronized with the primary at all times?
A. SAFETY FULL
B. SAFETY OFF
C. MIRROR SYNC
D. MIRROR 100
Which of the following is a high availability feature with SQL Server 2012?
C. Log Shipping
Which of the following is NOT a pre-defined server role in SQL Server 2012?
Which of the following is required in order for a differential backup to be useful for recovery purposes?
A. A full backup taken previous to the differential backup.
B. Hard drive space that is 2 times the size of the database you want to restore.
C. Less than 1000 database transactions an hour.
D. A full backup taken after the differential backup.
Which of the following statements about the tempdb system database is FALSE?
A. It is a globally available resource for all connected users.
B. It can hold explicitly or implicitly created database objects.
C. It must be sized in accordance with the smallest user-database on the machine.
D. It is created every time the SQL Server instance is restarted.
You have an index called Employee_IDX on the table Employees. Which of the following will rebuild this index online?
A. ALTER INDEX Employee_IDX ON Employees REBUILD WITH (ONLINE = ON);
B. CREATE INDEX Employee_IDX ON Employees REBUILD WITH (ONLINE = ON);
C. REBUILD ONLINE INDEX Employee_IDX ON Employees;
D. ALTER INDEX REBUILD ONLINE Employee_IDX;
Which of the following is a valid data source which you can import into SQL Server 2012?
A. Oracle data file
B. .DOC file
C. Access 2010
D. Oracle export file
Which of the following SQL Server 2012 indexes stores data in a column-wise fashion instead of the traditional row-wise method?
A. Bitmap Index
B. Clustered Index
C. Function-based Index
D. Columnstore Index
Which of the following is the default port for an SQL Server database to communicate over?
Which of the following SQL Server 2012 indexes is ordered independently of the actual physical order of the table data on which the index is based?
Which of the following files keeps track of all transactions that occur in an SQL Server database?
A. Transaction Log
B. Redo Log
C. Archive Log
D. Data File
Which of the following will show you a history of job errors that have occurred in jobs scheduled to run in an SQL Server 2012 installation?
A. Look at the sys.all_job_hist table.
B. In Management Studio, navigate to SQL Server Agent -> Error Logs and look at the log for the
C. Open the c:\error\job.log file and search for the particular job and the errors you wish to view.
D. You must use T-SQL to write a job-logging procedure to monitor jobs.
Which of the following SQL Server 2012 tools assists DBAs in running and analyzing trace results?
B. SQL Profiler
Which of the following statements will set the maximum amount of system memory that is managed by the SQL Server Memory Manager to 4GB?
A. sp_configure `max memory’, 4;
B. ALTER SYSTEM SET `max server memory’=4096;
C. sp_configure `max server memory’, 4;
D. sp_configure `max server memory’, 4096;
Which of the following file systems is supported for an SQL Server 2012 installation?
GreatExam 70-462 dumps and 70-462 practice test which contain almost 100% correct answers are tested and approved by senior Microsoft lecturers and experts. They have been devoting themselves to providing candidates with the best 70-462 study materials to make sure what they get are valuable. Comparing with others, GreatExam 70-462 exam questions are more authoritative and complete.