Free Microsoft 070-458 Exam Dumps Questions & Answers

You administer two Microsoft SQL Server 2012 servers. Each server resides in a different,
untrusted domain.
You plan to configure database mirroring.
You need to be able to create database mirroring endpoints on both servers.
What should you do?

• A.  Use Kerberos authentication.
• B.  Use certificates.
• C.  Use SQL Authenticated Logins.
• D.  Configure firewalls to allow Windows Logins.

You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Mode.
The project will be deployed to an SSIS catalog folder where Environments have already been created.
You need to deploy the project.
What should you do?

• A.  Deploy the .ispac file by using the Integration Services Deployment Wizard.
• B.  Create a SQL Server Agent job to execute the SSISDB.catalog.validate_project stored procedure.
• C.  Enable the SSIS log provider for SQL Server for OnError in the package control flow.
• D.  View the job history for the SQL Server Agent job.
• E.  Create a SQL Server Agent job to execute the SSISDB.catalog.validate_package stored procedure.
• F.  Store the System::ServerExecutionID variable in the custom log table.
• G.  Create a table to store error information. Create an error output on each data flow destination that writes OnTaskFailed event text to the table.
• H.  Use an event handler for OnTaskFailed for the package.
• I.  Create a table to store error information. Create an error output on each data flow destination that writes OnError event text to the table.
• J.  Enable the SSIS log provider for SQL Server for OnTaskFailed in the package control flow.
• K.  Store the System::SourceID variable in the custom log table.
• L.  Deploy the project by using dtutil.exe with the /COPY DTS option.
• M.  Store the System::ExecutionInstanceGUID variable in the custom log table.
• N.  Create a SQL Server Agent job to execute the SSISDB.catalog.create_execution and SSISDB.catalog.*tart_execution stored procedures.
• O.  Use an event handler for OnError for the package.
• P.  Deploy the project by using dtutil.exe with the /COPY SQL option.
• Q.  Use an event handler for OnError for each data flow task.
• R.  View the All Messages subsection of the All Executions report for the package.

----
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 need to ensure that your backup will continue if any invalid checksum is encountered.
Which backup option should you use?

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

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?

• A.  Peer-to-Peer Replication
• B.  Log Shipping
• C.  Availability Groups
• D.  Database Mirroring

You administer a Microsoft SQL Server 2012 database instance.
You plan to migrate the database to Windows Azure SQL Database. You verify that all objects contained in the database are compatible with Windows Azure SQL Database. You need to ensure that database users and required server logins are migrated to
Windows Azure SQL Database. What should you do?

• A.  Use the Copy Database wizard.
• B.  Use SQL Server Management Studio to deploy the database to Windows Azure SQL Database.
• C.  Back up the database from the local server and restore it to Windows Azure SQL Database.
• D.  Use the Database Transfer wizard.