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: 71 – (Topic 2)

You are developing a database application by using Microsoft SQL Server 2012. You have a query that runs slower than expected.

You need to capture execution plans that will include detailed information on missing indexes recommended by the query optimizer.

What should you do?

  1. Add a HASH hint to the query.

  2. Add a LOOP hint to the query.

  3. Add a FORCESEEK hint to the query.

  4. Add an INCLUDE clause to the index.

  5. Add a FORCESCAN hint to the Attach query.

  6. Add a columnstore index to cover the query.

  7. Enable the optimize for ad hoc workloads option.

  8. Cover the unique clustered index with a columnstore index.

  9. Include a SET FORCEPLAN ON statement before you run the query.

  10. Include a SET STATISTICS PROFILE ON statement before you run the query.

  11. Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query.

  12. Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement before you run the query.

  13. Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you run the query.

  14. Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query.

Answer: K

Question No: 72 – (Topic 2)

You administer a Microsoft SQL Server 2012 database named Contoso that contains a single user-defined database role namedBillingUsers.

All objects in Contoso are in the dbo schemA.

You need to grant EXECUTE permission for all stored procedures in Contoso to BillingUsers.

Which Transact-SQL statement should you use?

  1. CREATE ROLE proc_caller

    GRANT EXECUTE ON Schema: : dbo TO proc_caller ALTER ROLE proc_caller ADD MEMBER BillingUsers

  2. GRANT EXECUTE ON INFORMATION_SCHEMA.ROUTINES TO BillingUsers

  3. EXEC sp_addrolemember #39;executor#39;, #39;BillingUsers#39;

  4. CREATE ROLE proc_caller

GRANT EXECUTE ON ALL PROCEDURES TO proc_caller

ALTER MEMBER BillingUsers ADD TO ROLE proc_caller

Answer: D

Question No: 73 – (Topic 2)

Which of the following is NOT a potential Cluster resource when configuring clustering in SQL Server 2012?

  1. SQL Server Database Engine Service

  2. SQL Server Agent Service

  3. SQL Server Table Service

  4. All of the above

Answer: D

Question No: 74 – (Topic 2)

You administer a Microsoft SQL Server 2012 failover cluster that contains two nodes named Node A and Node B. A single instance of SQL Server is installed on the cluster.

An additional node named Node C has been added to the existing cluster.

You need to ensure that the SQL Server instance can use all nodes of the cluster. What should you do?

  1. Create a ConfigurationFile.ini file from Node B, and then run the AddNode command- line tool on Node A.

  2. Use Node A to install SQL Server on Node C.

  3. Run the Add Node to SQL Server Failover Cluster Wizard on Node C.

  4. Use Cluster Administrator to add a new Resource Group to Node B.

Answer: C

Question No: 75 DRAG DROP – (Topic 2)

You administer a Microsoft SQL Server 2012 server.

You need to install the Power View components on a stand-alone server.

Which three 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: 76 – (Topic 2)

You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN).

The financial database has the following characteristics:

->A data file of 2 terabytes is located on a dedicated LUN (drive D).

->A transaction log of 10 GB is located on a dedicated LUN (drive E).

->Drive D has 1 terabyte of free disk space.

->Drive E has 5 GB of free disk space.

The database is continually modified by users during business hours from Monday through

Friday between 09:00 hours and 17:00 hours.

Five percent of the existing data is modified each day.

The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT commands.

Each data load adds 3 GB of data to the database.

These data load operations must occur in the minimum amount of time. A full database backup is performed every Sunday at 10:00 hours.

Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours.

You implement log shipping of the financial database to another SQL Server 2012 instance.

You decide to failover to this secondary database.

You need to ensure that all transactions will be replicated to the secondary database. Which backup option should you use?

  1. Differential

  2. Transaction Log

  3. FULL

  4. SIMPLE

  5. SKIP

  6. RESTART

  7. STANDBY

  8. CHECKSUM

  9. DBO_ONLY

  10. COPY_ONLY

  11. NORECOVERY

  12. NO_CHECKSUM

  13. CONTINUE_AFTER_ERROR

  14. BULK_LOGGED

Answer: K

Reference:

http://technet.microsoft.com/en-us/library/ms187103.aspx http://msdn.microsoft.com/en-us/library/ms191233.aspx http://msdn.microsoft.com/en-us/library/ms178117.aspx

Question No: 77 – (Topic 2)

You administer a Microsoft SQL Server 2012 instance named SQL2012 that hosts an OLTP database of 1 terabyte in size.

The database is modified by users only from Monday through Friday from 09:00 hours to 17:00 hours. Users modify more than 30 percent of the data in the database during the week.

Backups are performed as shown in the following schedule:

Dumps4Cert 2018 PDF and VCE

The Finance department plans to execute a batch process every Saturday at 09:00 hours. This batch process will take a maximum of 8 hours to complete.

The batch process will update three tables that are 10 GB in size. The batch process will update these tables multiple times.

When the batch process completes, the Finance department runs a report to find out whether the batch process has completed correctly.

You need to ensure that if the Finance department disapproves the batch process, the batch operation can be rolled back in the minimum amount of time.

What should you do on Saturday?

  1. Perform a differential backup at 08:59 hours.

  2. Record the LSN of the transaction log at 08:59 hours. Perform a transaction log backup at 17:01 hours.

  3. Create a database snapshot at 08:59 hours.

  4. Record the LSN of the transaction log at 08:59 hours. Perform a transaction log backup at 08:59 hours.

  5. Create a marked transaction in the transaction log at 08:59 hours. Perform a transaction log backup at 17:01 hours.

  6. Create a marked transaction in the transaction log at 08:59 hours. Perform a transaction log backup at 08:59 hours.

Answer: C

Question No: 78 HOTSPOT – (Topic 2)

You administer a Microsoft SQL Server database. The database is in the Simple recovery mode.

You schedule the following backup plan:

->Full backup every day at midnight

->Differential backups every hour on the hour, except at midnight

The database fails at 20:45 hours.

You need to use SQL Server Management Studio (SSMS) to begin restoring the database to a new server instance with a minimum amount of data loss.

Which options should you select on the Options page of the Restore Database window? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Question No: 79 – (Topic 2)

Your database contains a table named SalesOrders. The table includes a DATETIME column named OrderTime that stores the date and time each order is placed. There is a non-clustered index on the OrderTime column. The business team wants a report that displays the total number of orders placed on the current day.

You need to write a query that will return the correct results in the most efficient manner. Which Transact-SQL query should you use?

  1. SELECT COUNT(*) FROM SalesOrders

    WHERE OrderTime = CONVERT(DATE, GETDATE())

  2. SELECT COUNT(*) FROM SalesOrders WHERE OrderTime = GETDATE()

  3. SELECT COUNT(*) FROM SalesOrders

    WHERE CONVERT(VARCHAR, OrderTime, 112) = CONVERT(VARCHAR, GETDATE(I, 112))

  4. SELECT COUNT(*) FROM SalesOrders

WHERE OrderTime gt;= CONVERT(DATE, GETDATE())

AND OrderTime lt; DATEADD(DAY, CONVERT(DATE, GETDATE()))

Answer: D

Question No: 80 – (Topic 2)

You are a database administrator for a Microsoft SQL Server 2012 environment.

You want to deploy a new application that will scale out the workload to at least five different SQL Server instances.

You need to ensure that for each copy of the database, users are able to read and write data that will then be synchronized between all of the database instances.

Which feature should you use?

  1. Database Mirroring

  2. Peer-to-Peer Replication

  3. Log Shipping

  4. Availability Groups

Answer: B

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

Comments are closed.