Study with 70-458 Actual Test Questions

A Microsoft credential tells employers that your skills meet the vendor's own standard. Prepare for the 70-458 exam with 90 expert-verified practice questions from Actualtests4sure, and walk into the test center knowing exactly what to expect.

Microsoft 70-458 Exam Overview:

Microsoft 70-458 Exam Syllabus Topics:

Your Microsoft 70-458 Exam Questions, Answered

Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 Sample Questions:

Question 1

You are developing a SQL Server Integration Services (SSIS) project with multiple packages to copy data to a Windows Azure SQL Database database.
An automated process must validate all related Environment references, parameter data types, package references, and referenced assemblies. The automated process must run on a regular schedule.
You need to establish the automated validation process by using the least amount of administrative effort.
What should you do?

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

Question 2

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 certificates.
B. Configure firewalls to allow Windows Logins.
C. Use SQL Authenticated Logins.
D. Use Kerberos authentication.

Question 3

You are the lead database administrator (DBA) of a Microsoft SQL Server 2012 environment.
All DBAs are members of the DOMAIN\JrDBAs Active Directory group. You grant DOMAIN\JrDBAs access to the SQL Server.
You need to create a server role named SpecialDBARole that can perform the following functions:
- View all databases.
- View the server state.
- Assign GRANT, DENY, and REVOKE permissions on logins.
You need to add DOMAIN\JrDBAs to the server role. You also need to provide the least level of privileges necessary.
Which SQL statement or statements should you use? Choose all that apply.

A. ALTER SERVER ROLE [SpecialDBARole] ADD MEMBER [DOMAIN\JrDBAs];
B. GRANT VIEW DEFINITION TO [SpecialDBARole];
C. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION securityadmin;
D. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION serveradmin;
E. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION setupadmin;
F. GRANT VIEW SERVER STATE, VIEW ANY DATABASE TO [SpecialDBARole];

Question 4

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 Foundation 2010 SP1
B. SQL Server 2012 Enterprise (64-bit) x64 on the database server
C. Microsoft SharePoint Server 2010 Enterprise Edition SP1
D. SQL Server 2008 Enterprise (64-bit) x64 on the database server

Question 5

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database.
The recovery model and backup schedule are configured as shown in the following table:

One of the hard disk drives that stores the reporting database fails at 16:40 hours.
You need to ensure that the reporting database is restored. You also need to ensure that
data loss is minimal.
What should you do?

A. Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup.
B. Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup.
C. Perform a point-in-time restore.
D. Perform a page restore.
E. Restore the latest full backup. Then, restore the latest differential backup.
F. Restore the latest full backup.
G. Perform a partial restore.
H. Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup.

Solutions: