Most of our new customers arrive the same way: recommended by someone who already passed. In 2026, word of mouth still says more than advertising, and the 90 Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 practice questions at ActualPDF keep earning it.

Microsoft 070-458 Exam Overview:

Certification Vendor:	Microsoft
Exam Name:	Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2
Exam Number:	70-458
Passing Score:	700
Exam Price:	USD $165
Related Certifications:	MCSE: Business Intelligence MCSE: Data Platform MCP
Certificate Validity Period:	Retired since July 31, 2019; certification valid for lifetime if earned before retirement
Exam Format:	Active screen, Build list, Drag and drop, Hot area, Multiple choice, Case studies
Real Exam Qty:	85-90
Available Languages:	Japanese, English
Exam Duration:	120 minutes
Recommended Training:	Microsoft Official Course 20467: Designing Business Intelligence Solutions for SQL Server 2012 Microsoft Official Course 20465: Designing Database Solutions for SQL Server 2012
Exam Registration:	Microsoft Learning (Retired) Pearson VUE (Historical)
Sample Questions:	DOWNLOAD DEMO
Exam Way:	Proctored onsite at Pearson VUE test centers; no longer available for registration
Pre Condition:	Hold valid MCTS certification on SQL Server 2008 (e.g., 70-432, 70-433, 70-448)
Official Syllabus URL:	https://learn.microsoft.com/en-us/previous-versions//dn465929(v=technet.10)

Microsoft 070-458 Exam Syllabus Topics:

Section	Weight	Objectives
Topic 1: Implement Business Intelligence Solutions	25-30%	- Implement SSRS reports 1. Configure report security and delivery 2. Create and deploy reports - Use Power View and BI Semantic Model - Design and implement SSAS solutions 1. xVelocity in-memory engine 2. Tabular and Multidimensional models
Topic 2: Implement Data Integration Solutions	20-25%	- Deploy and maintain SSIS solutions 1. Project deployment model 2. Package configuration and execution - Import and export data 1. Bulk operations 2. Data Quality Services - Design and implement SSIS packages 1. Create control flow and data flow 2. Use transformations and sources/destinations
Topic 3: Manage and Maintain Databases	25-30%	- Implement high availability 1. Manage log shipping 2. Configure AlwaysOn Availability Groups 3. Implement database mirroring - Manage database files and storage - Backup and restore databases 1. Manage system databases 2. Perform point-in-time recovery 3. Implement backup strategies
Topic 4: Implement Security	20-25%	- Implement encryption and auditing 1. Transparent Data Encryption (TDE) 2. Configure audit specifications - Configure server security 1. Manage logins and server roles 2. Implement authentication modes - Manage database permissions 1. Create users and database roles 2. Apply permission hierarchies

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

What certification do I get for passing 070-458?

Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 is an official Microsoft certification exam, registered under the code 070-458. Passing it awards the MCSA: SQL Server 2012 certification, a credential at the Associate level. It also connects to MCP, MCSE: Data Platform, MCSE: Business Intelligence. The exam is demanding by design, and that difficulty is precisely what makes the credential meaningful for career development.

How many questions are on the 070-458 exam, and how long is it?

The Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 exam presents 85-90 questions within 120 minutes. That is a brisk pace, and the candidates who handle it best are the ones who rehearsed it. Use the ActualPDF engine for full timed simulations, practice flagging and returning, and arrive on exam day with a pacing strategy already proven.

What score do I need to pass 070-458, and what does it cost?

Passing Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 takes 700, and official registration costs USD $165. Retakes bill the full USD $165 again, so preparation is the least expensive insurance available. Let your ActualPDF practice scores guide the timing: book when you clear the requirement consistently, not occasionally.

Are there any prerequisites for the 070-458 exam?

Hold valid MCTS certification on SQL Server 2008 (e.g., 70-432, 70-433, 70-448)

Policies get revised, so confirm the current requirements before you register on the official exam page.

How do I register for the 070-458 exam?

Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 registration is handled through the official channels below.

For scheduling purposes: the exam is delivered Proctored onsite at Pearson VUE test centers; no longer available for registration.

Does Microsoft recommend training for the 070-458 exam?

Yes, Microsoft recommends the following training for Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 candidates.

Complement any training with the 90 practice questions in the ActualPDF 070-458 package, because repeated application is what turns course knowledge into a passing score.

Can I try the 070-458 material before I buy?

Yes. ActualPDF offers a free demo of the Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 questions, so you can verify the quality personally before purchasing. Your purchase then includes a one-year service warranty: updates are free for 365 days, and after expiry you can extend the update service at a 50% discount.

What if I fail the 070-458 exam, and how is delivery handled?

Your money is protected by a 100% money-back guarantee with defined conditions. Take the Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 exam within 60 days of purchase; if you fail, you may claim a full refund, provided the exam matches your product. Attempts within 3 days of purchase are ineligible, as are downloaded-but-unused products, free materials, and expired orders; the candidate name must match the payer name. Submit a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and claims are processed within 7 days. You may instead wait for the update version or change to other exam material: exchange for two other exam products of equal value, free, with your original purchase keeping its update service.

Delivery is instant: files unlock for download at payment and are emailed within one minute. If nothing arrives within 2 hours, check spam and contact customer service, online 7/24 even on official holidays. Installation is unlimited across your computers.

What topics are covered in the 070-458 exam?

Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 is organized into 4 official domains. The most heavily weighted are Implement Security (20-25%), Manage and Maintain Databases (25-30%), and Implement Business Intelligence Solutions (25-30%). The full breakdown appears above on this page; study the weightings and your preparation priorities set themselves.

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

Question #1

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. Availability Groups
B. Log Shipping
C. Peer-to-Peer Replication
D. Database Mirroring

Answer: C

Question #2

You administer a Windows Azure SQL Database database named Inventory that contains a stored procedure named p_AddInventory.
Users need to be able to SELECT from all tables in the database and execute the stored procedure. You need to grant only the necessary permissions.
What should you do?

A. Create a new database role. Grant EXECUTE permission on p_AddInventory to the newrole. Add all users to the role. Add all users to the db_datareader role.
B. Add all users to the db_datawriter role. Add all users to the db_datareader role.
C. Create a new database role. Grant EXECUTE permission on p_AddInventory to the new role. Grant VIEW DEFINITION to to the role. Add all users to the role.
D. Add EXECUTE AS OWNER to the stored procedure. Add all users to the db_datareader role.

Answer: D

Explanation: Only visible for ActualPDF members. You can sign-up / login (it's free).

Question #3

You administer a Microsoft SQL Server 2012 database.
You create an availability group named haContosoDbs. Your primary replica is available at Server01\Contoso01.
You need to configure the availability group to minimize transaction latency on any available secondary databases. In the event of a database failure, the designated secondary database should come online automatically.
Which Transact-SQL statement should you use?

A. Option C
B. Option B
C. Option A
D. Option D

Answer: D

Question #4

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

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 CarrierTrackingNumber 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.)

Answer:

Question #5

You are the senior database administrator for a Microsoft SQL Server environment that uses Windows Azure SQL Database.
You need to grant a junior database administrator only the permissions required to create new logins.
Which Windows Azure SQL Database role should you assign the junior database administrator?