[Free] 2019(Nov) EnsurePass Microsoft 70-462 Dumps with VCE and PDF 81-90

Get Full Version of the Exam
http://www.EnsurePass.com/70-462.html

Question No.81 DRAG DROP

You administer a Microsoft SQL Server 2012 environment that contains a production SQL Server 2005 instance named SQL2005 and a development SQL Server 2012 instance named SQL2012. The development team develops a new application that uses the SQL Server 2012 functionality. You are planning to migrate a database from SQL2005 to SQL2012 so that the development team can test their new application. You need to migrate the database without affecting the production environment. 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.)

image

Correct Answer:

image

Question No.82 DRAG DROP

You administer three Microsoft SQL Server 2008 R2 instances. Database mirroring is configured in High-Safety mode with Automatic Failover between the following three servers:

SQL1 is the Principal server. SQL2 is the mirror server.

SQL3 is the witness server.

You need to upgrade SQL1 and SQL2 to SQL Server 2012. You need to ensure that downtime is minimized during the upgrade. Which six 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.)

image

Correct Answer:

image

Question No.83

You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables. You need to configure the SQL Server environment to support these packages. What should you do?

  1. Create SSIS configuration files for the packages.

  2. Create an Integration Services catalog.

  3. Install Data Quality Services.

  4. Install Master Data services.

Correct Answer: B

Question No.84

You administer a Microsoft SQL Server 2012 server. When transaction logs grow, SQL Server must send an email message to the database administrators. You need to configure SQL Server to send the email messages. What should you configure?

  1. SQL Mail

  2. An Extended Events session

  3. Alerts and operators in SQL Server Agent

  4. Policies under Policy-Based Management

Correct Answer: C

Question No.85

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. Use the Data Quality Client to configure the application.

  2. Start the SQL Server Browser Service.

  3. Use the Master Data Services Configuration Manager to configure the application.

  4. Start the SQL Server Integration Services Service.

Correct Answer: B

Question No.86 DRAG DROP

You administer a Microsoft SQL Server 2012 database. You use an OrderDetail table that has the following definition:

image

You need to create a non-clustered index on the SalesOrderID column in the OrderDetail table to include only rows that contain a value in the SpecialOfferID column. Which four Transact-SQL statements should you use? (To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.)

image

Correct Answer:

image

Question No.87

You administer a Microsoft SQL Server 2012 database. The database contains a table that has the following definition:

image

You want to export data from the table to a flat file by using the SQL Server Import and Export Wizard. You need to ensure that the following requirements are met:

The first row of the file contains the first row of data. Each record is of the same length.

The date follows the U.S. date format.

The file supports international characters.

What should you do? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

image

Correct Answer:

image

To achieve the requirements of the question you must do the following:

  1. The first row of the file contains the first row of data.

    The Checkbox 鈥渃olumn names in the first data row鈥?must be checked off

  2. Each record is of the same length.

    The Format-Listbox must be changed to 鈥淔ixed鈥? Then every line has the same length (Attention: Lines then are NOT separated by CrLf as usual).

    If you choose delimited then CrLf seperates the lines, but they have Differenz length. If you choose Ragged right then the last filed has different sizes.

  3. The date follows the U.S. date Format: Set the field Locale to 鈥淓nglish (US)鈥?/p>

  4. The file supports international characters The Checkbox 鈥淯nicode鈥?must be checked.

Why is that necessary? The field Customername in the table has Type nvarchar(50). That means it is a unicode-field and can be filled with international characters like german umlaute

It is described here:

http://msdn.microsoft.com/en-us/library/ms178430(v=sql.110).aspx?appid=dev10idef1amp;l=de- deamp;k=k(sql11.dts.impexpwizard.chooseadestination.f1)amp;rd=true

Question No.88

You administer a Microsoft SQL Server 2012 database. Users report that an application that accesses the database displays an error, but the error does not provide meaningful information. No entries are found in the SQL Server log or Windows event logs related to the error. You need to identify the root cause of the issue by retrieving the error message. What should you do?

  1. Update all stored procedure to use a TRY…CATCH block.

  2. Create a SQL Profiler session to capture all ErrorLog and EventLog events.

  3. Flag all stored procedures for recompilation by using sp_recompile.

  4. Execute sp_who.

Correct Answer: A

Question No.89

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

Correct Answer: K

Explanation:

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

What is the maximum number of SQL Server 2012 Enterprise edition Database Engine instances that you can deploy on a non-clustered server running Windows Server 2008 R2 Enterprise edition?

A.

10

B.

25

C.

50

D.

100

Correct Answer: C

Get Full Version of the Exam
70-462 Dumps
70-462 VCE and PDF

Leave a Comment

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