Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Aug Microsoft Official New Released 70-462
100% Free Download! 100% Pass Guaranteed!

Administering Microsoft SQL Server 2012 Databases

Question No: 91 – (Topic 2)

You have a large partitioned fact table in a data warehouse. The table is stored as a clustered index.

You need to modify the indexing solution to minimize the amount of disk space required to store the table.

What should you do?

  1. Enable row compression for the clustered index.

  2. Enable page compression for the clustered index.

  3. Implement a clustered columnstore index.

  4. Implement a nonclustered columnstore index.

Answer: D

Question No: 92 – (Topic 2)

You work as the Senior Database Administrator (DBA) at ABC.com. The company has a main office and 10 branch offices. Each branch office contains a single database server running Microsoft SQL Server 2012. The main office has multiple clustered servers running Microsoft SQL Server 2012.

Your role includes the management of the entire Microsoft SQL Server 2012 infrastructure.

The company runs a custom application that stores data in a large Microsoft SQL Server 2012 database.

The primary database is hosted in the main office. Each branch office SQL Server hosts a copy of the database.

You need to configure a solution that will replicate the entire primary database from the main office SQL Server every weekend.

What should you include in your solution?

  1. Transactional Replication

  2. Log Shipping

  3. Snapshot Replication

  4. SQL Server Availability Group

Answer: C

Question No: 93 – (Topic 2)

You have a SQL Server database named DB1.

You plan to load 10 milion rows to DB1 by running bcp.exe.

You need to modify DB1 to minimize the amount of space required to store the transaction logs during the load operation. The solution must ensure that you can perform a point-in- time restore.

Which database setting should you modify?

  1. Compatibility level to 120

  2. Containment type to partial.

  3. Recovery model to Bulk logged.

  4. Recovery model to simple.

Answer: A

Question No: 94 – (Topic 2)

You administer two instances of Microsoft SQL Server 2012. You deploy an application that uses a database on the named instance.

The application is unable to connect to the database on the named instance. You need to ensure that the application can connect to the named instance. What should you do?

  1. Configure the application as data-tiered.

  2. Open port 1433 on the Windows firewall on the server.

  3. Configure the named SQL Server instance to use an account that is a member of the Domain Admins group.

  4. Start the SQL Server Browser Service.

Answer: D

Question No: 95 – (Topic 2)

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.

You need to be notified immediately when fatal errors occur on Server01. What should you create?

  1. An Alert

  2. A Server Audit Specification

  3. An Extended Event session

  4. A Resource Pool

  5. A Policy

  6. A SQL Profiler Trace

  7. A Database Audit Specification

Answer: A

Reference: http://www.sqlskills.com/blogs/glenn/creating-sql-server-agent-alerts-for-critical- errors/

Question No: 96 – (Topic 2)

You want to remove SQL Server Integration Services from a server running the Windows Server 2008 R2 operating system that also has the Database Engine and SQL Server Analysis Services installed.

Which of the following tools can you use to accomplish this goal?

  1. SQL Server Management Studio

  2. SQL Server Configuration Manager

  3. Add/Remove Programs in Control Panel

  4. SQL Server Installation Center

Answer: C

Question No: 97 – (Topic 2)

Which of the following is a valid upgrade path for SQL Server 2012?

  1. SQL Server 2000 -gt; SQL Server 2012

  2. SQL Server 2000 -gt; SQL Server 2005 -gt; SQL Server 2012

  3. SQL Server 7 -gt; SQL Server 2012

  4. Oracle 11g -gt; SQL Server 2012

Answer: B

Explanation: References:

https://technet.microsoft.com/en-us/library/ms143393(v=sql.110).aspx https://technet.microsoft.com/en-us/library/ms143393(v=sql.90).aspx

Question No: 98 DRAG DROP – (Topic 2)

You administer a Microsoft SQL Server database. Service accounts for SQL Agent are configured to use a local user.

A Microsoft SQL Server Integration Services (SSIS) job step has been created within a SQL Server Agent job.

The SSIS package accesses a network share when exporting data from a SQL Server database.

When you execute the SQL Server Agent job, it fails due to a permissions failure on a share on a remote server.

You need to ensure that the SQL Server Agent job can execute the SSIS package.

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.)

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Question No: 99 – (Topic 2)

Which of the following SQL Server 2012 indexes stores data in a column-wise fashion instead of the traditional row-wise method?

  1. Bitmap Index

  2. Clustered Index

  3. Function-based Index

  4. Columnstore Index

Answer: C

Explanation: References:

https://msdn.microsoft.com/en-us/library/gg492088(v=sql.110).aspx

Question No: 100 – (Topic 2)

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.

You need to diagnose deadlocks that happen when executing a specific set of stored procedures by recording events and playing them back on a different test server.

What should you create?

  1. An Extended Event session

  2. A Policy

  3. A Database Audit Specification

  4. An Alert

  5. A Server Audit Specification

  6. A SQL Profiler Trace

  7. A Resource Pool

Answer: F

Reference: http://msdn.microsoft.com/en-us/library/ms188246.aspx

100% Dumps4cert Free Download!
70-462 PDF
100% Dumps4cert Pass Guaranteed!
70-462 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.