Our PDF dumps of 70-462 exam is designed to ensure everything which you need to pass your exam successfully. At GreatExam, we have a completely customer oriented policy. We invite the professionals who have rich experience and expert knowledge of the IT certification industry to guarantee the PDF details precisely and logically. Our customers’ time is a precious concern for us. This requires us to provide you the products that can be utilized most efficiently.
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?
If you want to get more 70-462 exam preparation material, you can download the free 70-462 braindumps in PDF files on GreatExam. It would be great helpful for your exam. All the 70-462 dumps are updated and cover every aspect of the examination. Welcome to choose.