Free Braindump2go Latest Microsoft Exam Dumps

Collection of Braindump2go LatestMicrosoft Exam Questions and Dumps for free Download

Microsoft 70-462 Exam Questions Newly Updtaed By Braindump2go (131-145)

Instant Download 70-462 PDF Files! New Updated 189 Exam Questions and Answers help 100% Exam Pass! 70-462 Certification Get Quickly!

Vendor: Microsoft
Exam Code: 70-462
Exam Name: Administering Microsoft SQL Server 2012 Databases Exam

11022

QUESTION 131
You administer a Microsoft SQL Server 2012 database instance.
You create a new user named UserA.
You need to ensure that UserA is able to create SQL Server Agent jobs and to execute SQL Server Agent jobs owned by UserA.
To which role should you add UserA?

A.    DatabaseMailUserRole
B.    ServerGroupAdministratorGroup
C.    SQLAgentUserRole
D.    Securityadmin

Answer: C

QUESTION 132
You administer a Microsoft SQL Server 2012 database.
You have a SQL Server Agent job instance that runs using the service account.
You have a job step within the job that requires elevated privileges.
You need to ensure that the job step can run using a different user account.
What should you use?

A.    a schedule
B.    an alert
C.    an operator
D.    a proxy

Answer: D

QUESTION 133
You install a Microsoft SQL Server 2012 instance.
The instance will store data extracted from two databases running on Windows Azure SQL Database.
You hire a data steward to perform interactive data cleansing and ad hoc querying and updating of the database.
You need to ensure that the data steward is given the correct client tools to perform these tasks.
Which set of tools should you install?

A.    SQL Server Management Studio and Distributed Replay Client
B.    Master Data Services and Data Quality Client
C.    Data Quality Client and Distributed Replay Client
D.    Data Quality Client and SQL Server Management Studio

Answer: A

QUESTION 134
You administer a Microsoft SQL Server environment.
You purchase a new server and plan to migrate your database from SQL Server 2008 to SQL Server 2012.
You want to evaluate to prepare for possible conflicts and issues that may arise during or after the migration.
Which SQL Server tool should you use?

A.    Distributed Replay
B.    Migration Assistant
C.    Data Tools
D.    Upgrade Advisor

Answer: D

QUESTION 135
Drag and Drop Questions
You are migrating an OLTP database from Windows Azure SQL Database to on-premise.
You are planning the installation of a Microsoft SQL Server 2012 server failover cluster.
The server has the following partitions:

wps5EB5.tmp_thumb

You install the operating system on the C: drive.
The database solution will use row versioning, triggers, and cursors.
The tempdb database cannot be placed on the same disk subsystem as the OLTP database.
The OLTP database needs to be on the fastest disk subsystem possible. The database is currently 200GB in size. It will not substantially increase in size in the next 3 years.
You need to plan the usage of the disk subsystems.
To which hard disk should each database belong? (To answer, drag the appropriate database or databases to their corresponding hard disk or disks in the answer area. Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)

wps7745.tmp_thumb

Answer:

wps9A11.tmp_thumb

QUESTION 136
Drag and Drop Questions
You administer several Microsoft SQL Server 2012 servers.
You want to run scheduled checks to confirm that the databases on the servers are not configured to AutoShrink.
You need to create a policy to check the condition.
What should you do? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

wpsB55F.tmp_thumb

Answer:

wpsC9DA.tmp_thumb

QUESTION 137
Drag and Drop Questions
You administer a Windows Azure SQL Database database used for data warehouse operations.
The database contains a table named OrdersHistory, defined as follows:

wpsE057.tmp_thumb

A weekly ETL (extract-transform-load) runs a large INSERT statement to add data into the OrdersHistory table.
The process is taking a long time to complete.
You discover that the bulk of the process is performing non-clustered index updates on the OrdersHistory table.
You need to improve the performance of the ETL process faster.
You need to meet the following requirements:
– Avoid losing existing permissions on existing objects.
– Use minimal administrative effort.
What should you do? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

wps17F.tmp_thumb

Answer:

wps1AF9.tmp_thumb

QUESTION 138
You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores.
You discover performance issues when complex calculations are performed on large amounts of data under heavy system load.
You need to limit the number of cores that handle the processing.
What should you configure?

A.    Max worker threads
B.    Processor affinity
C.    I/O affinity
D.    Lightweight pooling

Answer: B

QUESTION 139
Hotspot Question
You administer two Microsoft SQL Server 2012 databases named Contoso and ContosoWarehouse.
You plan to replicate tables from the Contoso database to the ContosoWarehouse database.
Indexes will be added to the tables in ContosoWarehouse to improve the performance of reports.
You need to ensure that the following requirements are met:
Indexes are not modified when the subscriptions are reinitialized.
Only the clustered index from Contoso will be replicated.
Minimal transaction log activity during the reinitialization.
What should you do? Choose the correct option(s).

wps39A0.tmp_thumb

Answer:

wps4E2B.tmp_thumb

QUESTION 140
What is the minimum recommended amount of RAM for SQL Server 2012 Enterprise?

A.    512 MB
B.    1 GB
C.    2 GB
D.    4 GB
E.    8 GB

Answer: B

QUESTION 141
Which of the following editions of SQL Server 2012 can you run on a computer that is running the Windows 7 Professional (x64) operating system? (Choose all that apply.)

A.    SQL Server 2012 (x64) Developer edition
B.    SQL Server 2012 (x64) Web edition
C.    SQL Server 2012 (x64) Enterprise edition
D.    SQL Server 2012 (x64) Standard edition

Answer: AD

QUESTION 142
Which of the following features can you install if you are installing SQL Server 2012 Enterprise edition on a computer running Windows Server 2008 R2 SP1 Enterprise edition in the Server Core configuration? (Choose all that apply.)

A.    Database Engine Services
B.    SQL Server Replication
C.    Analysis Services
D.    Reporting Services

Answer: ABC

QUESTION 143
On which of the following operating systems can you deploy the 64-bit version of SQL Server 2012 Enterprise edition? (Choose all that apply.)

A.    Windows 7 Ultimate (x64) edition
B.    Windows Server 2008 R2 SP1 (x64) Standard edition
C.    Windows Server 2008 SP2 (x64) Enterprise edition
D.    Windows Server 2003 R2 (x64) Enterprise edition

Answer: BC

QUESTION 144
You administer a Microsoft SQL Server 2012 database.
You have a SQL Server Agent job instance that runs using the service account.
You have a job step within the job that requires elevated permissions.
You need to ensure that the job step can run using a different user account.
What should you use?

A.    A notification
B.    A schedule
C.    A job category
D.    A proxy

Answer: D

QUESTION 145
You maintain several databases on a 32-bit Microsoft SQL Server 2005 instance on a Windows Server 2008 R2 64-bit server.
You need to migrate the databases to a 64-bit SQL Server 2012 instance on the same server. You also need to ensure that the new Transact-SQL functionality in SQL Server 2012 can be used in the database after the migration.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

A.    Perform a side-by-side installation of a 32-bit SQL Server 2012 instance.
B.    Perform a side-by-side installation of a 64-bit SQL Server 2012 instance.
C.    Perform an in-place upgrade to 64-bit SQL Server 2012.
D.    Detach the database from the old instance and attach it to the new instance.
E.    Change the compatibility level of the database.

Answer: BDE
Explanation:
* use detach and attach operations to upgrade a SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 database in SQL Server 2012. After being attached to SQL Server 2012, the database is available immediately and is automatically upgraded.


100% Full Money Back Guarantee Promised By Braindump2go to All 70-462 Exam Candiates: Braindump2go is confident that our NEW UPDATED 70-462 Exam Questions and Answers are changed with Microsoft Official Exam Center, If you cannot PASS 70-462 Exam, nevermind, we will return your full money back! Visit Braindump2go exam dumps collection website now and download 70-462 Exam Dumps Instantly Today!

1522

http://www.braindump2go.com/70-462.html

, , , , ,

Comments are currently closed.