Online Access Free 070-458 Exam Questions

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 S 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 failoverto this secondary database.
You need to ensure that all transactions will be replicated to the secondary database.
Which backup option should you use?

• A.CHECKSUM
• B.NO_CHECKSUM
• C.DBO_ONLY
• D.Transaction log
• E.FULL
• F.CONTINUE_AFTER_ERROR
• G.Differential
• H.RESTART
• I.NORECOVERY
• J.STANDBY
• K.SKIP
• L.BULK_LOGGED
• M.COPY_ONLY
• N.SIMPLE

You administer a Microsoft SQL Server 2012 server. You plan to deploy new features to an application.
You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance.
What should you do?

• A.Query the sys.dm_db_missing_index_details DMV.
• B.Use the Database Engine Tuning Advisor.
• C.Query the sys.dm_db_missing_index_columns DMV.
• D.Query the sys.dm_db_index_usage_stats DMV.

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. The package contains a user-defined variable named @Queue which has an initial value of 10.
The package control flow contains many tasks that must repeat execution until the @Queue variable equals 0.
You need to enable the tasks to be grouped together for repeat execution.
Which item should you add to the package? (To answer, select the appropriate item in the answer area.)

Correct Answer:

You are preparing to install SQL Server 2012 Master Data Services (MDS).
You need to ensure that the database requirements are met.
What should you install?

• A.Microsoft SharePoint Server 2010 Enterprise Edition SP1
• B.SQL Server 2012 Enterprise (64-bit) x64 on the database server
• C.SQL Server 2008 Enterprise (64-bit) x64 on the database server
• D.Microsoft SharePoint Foundation 2010 SP1

You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS).
You need to complete the post-installation configuration.
What should you do?

• A.Run the DQSInstaller.exe command.
• B.Install ADOMD.NET.
• C.Make the data available for DQS operations.
• D.Run the Configuration component in the Data Quality Client.