[2016-New] 100% Pass GreatExam Microsoft 70-462 Practice Test Free Version (201-220)

GreatExam guarantees your Microsoft 70-462 exam 100% success with our unique official 70-462 exam questions resources! GreatExam’s 70-462 braindumps are developed by experiences IT Certifications Professionals working in today’s prospering companies and data centers! GreatExam 70-462 exam dumps are checked by our experts team every day to ensure you have the latest updated exam dumps!

QUESTION 201
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.

 

2011
Answer:
2012
Explanation:
http://sqlsailor.com/2011/12/29/tdetransparent-data-encryption-in-sql-server-2012-rc-0/

QUESTION 202
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.)
2021
Answer:
2022
Explanation:
https://msdn.microsoft.com/en-us/library/ff929139%28v=sql.110%29.aspx http://www.sqlcoffee.com/SQLServer2012_0009.htm

QUESTION 203
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.

Answer: C
Explanation:
https://msdn.microsoft.com/en-us/library/ms188236(v=sql.110).aspx

QUESTION 204
Which of the following is the default instance name in an SQL Server 2012 installation?

A.    SQLSERVER12
B.    MSSQLSERVER
C.    MSSQL
D.    2012SQL

Answer: B
Explanation:
https://msdn.microsoft.com/en-us/library/ms143547(v=sql.110).aspx

QUESTION 205
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.

Answer: A
Explanation:
https://msdn.microsoft.com/en-us/library/cc280525(v=sql.110).aspx

QUESTION 206
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

Answer: A
Explanation:
https://msdn.microsoft.com/en-us/library/ms189852%28v=sql.110%29.aspx

QUESTION 207
Which of the following is a high availability feature with SQL Server 2012?

A.    Clustering
B.    AlwaysOn
C.    Log Shipping
D.    Active-Active

Answer: B
Explanation:
https://msdn.microsoft.com/en-us/library/ms190202%28v=sql.110%29.aspx

QUESTION 208
Which of the following is NOT a pre-defined server role in SQL Server 2012?

A.    securityadmin
B.    serveradmin
C.    sysdba
D.    dbcreator

Answer: C
Explanation:
https://msdn.microsoft.com/en-us/library/ms188659%28v=sql.110%29.aspx

QUESTION 209
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.

Answer: A
Explanation:
https://msdn.microsoft.com/en-us/library/ms175526%28v=sql.110%29.aspx

QUESTION 210
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.

Answer: C
Explanation:
https://msdn.microsoft.com/en-us/library/ms190768%28v=sql.110%29.aspx

QUESTION 211
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;

Answer: A
Explanation:
https://msdn.microsoft.com/en-us/library/ms177442%28v=sql.110%29.aspx

QUESTION 212
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

Answer: C
Explanation:
https://msdn.microsoft.com/en-us/library/ms141209%28v=sql.110%29.aspxv

QUESTION 213
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

Answer: C
Explanation:
https://msdn.microsoft.com/en-us/library/gg492088%28v=sql.110%29.aspx

QUESTION 214
Which of the following is the default port for an SQL Server database to communicate over?

A.    1433
B.    21
C.    1344
D.    1521

Answer: A
Explanation:
https://msdn.microsoft.com/en-us/library/ms177440%28v=sql.110%29.aspx

QUESTION 215
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?

A.    CLUSTERED
B.    BITMAP
C.    NONCLUSTERED
D.    IND_ORDERED

Answer: C
Explanation:
https://msdn.microsoft.com/en-us/library/ms188783%28v=sql.110%29.aspx

QUESTION 216
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

Answer: A
Explanation:
https://msdn.microsoft.com/en-us/library/ms190925%28v=sql.110%29.aspx

QUESTION 217
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
corresponding date.
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.

Answer: D

QUESTION 218
Which of the following SQL Server 2012 tools assists DBAs in running and analyzing trace results?

A.    SSIS
B.    SQL Profiler
C.    AlwaysOn
D.    EXP

Answer: B
Explanation:
https://msdn.microsoft.com/en-us/library/ms187929%28v=sql.110%29.aspx

QUESTION 219
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;

Answer: D
Explanation:
https://msdn.microsoft.com/en-us/library/ms178067%28v=sql.110%29.aspx

QUESTION 220
Which of the following file systems is supported for an SQL Server 2012 installation?

A.    EXT4
B.    NTFS
C.    FAT16
D.    EXT3

Answer: B
Explanation:
https://msdn.microsoft.com/en-us/library/ms143506%28v=sql.110%29.aspx#storagetypes

By utilizing GreatExam high quality Microsoft 70-462 exam dumps products, you can surely pass 70-462 certification exam 100%! GreatExam also offers 100% money back guarantee to individuals in case they fail to pass Microsoft 70-462 in one attempt.

http://www.greatexam.com/70-462-exam-questions.html