Microsoft MCSA 70-457

Certification exams change, and Getcertkey keeps pace: the 70-457 practice question set is reviewed continuously and updated free of charge for 365 days. Your Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 preparation stays aligned with the current exam throughout 2026 and beyond.

Microsoft 70-457 Exam Overview:

Certification Vendor:	Microsoft
Exam Name:	Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1
Exam Number:	70-457
Real Exam Qty:	Varies
Certificate Validity Period:	Retired
Passing Score:	700
Exam Price:	USD 150
Related Certifications:	MCTS: SQL Server 2008 MCSA: SQL Server 2012
Exam Duration:	300 minutes
Available Languages:	Chinese (Traditional), English, German, Japanese, French, Spanish, Russian, Portuguese (Brazil), Chinese (Simplified)
Exam Format:	Case studies, Build list, Drag and drop, Active screen, Multiple choice
Recommended Training:	Microsoft Learn
Exam Registration:	Microsoft Certification Exam Registration
Sample Questions:
Exam Way:	Testing center or online proctored exam through Microsoft exam delivery partners
Pre Condition:	Candidates must hold a qualifying MCTS certification on SQL Server 2008. This was a transition exam for upgrading to MCSA: SQL Server 2012.
Official Syllabus URL:	https://learn.microsoft.com/en-us/credentials/certifications/exams/70-457/

Microsoft 70-457 Exam Syllabus Topics:

Common Questions About the Microsoft 70-457 Exam

What is the Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 exam all about?

The 70-457 exam is the official Microsoft exam behind the MCSA: SQL Server 2012 certification, validating the skills measured by the Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 credential. It sits at the Associate level of the Microsoft certification program. It also connects to MCTS: SQL Server 2008, MCSA: SQL Server 2012, so the knowledge you build here carries over to those tracks as well.

How many questions are on the 70-457 exam, and how much time do I get?

The 70-457 exam contains Varies questions to be completed within 300 minutes. Before exam day, divide the available time by the question count to work out a comfortable per-question pace, and mark any item that eats into it so you can return later instead of getting stuck. Timed sessions in the Getcertkey test engines make that pacing automatic — run at least two full-length mock exams under the clock so time pressure never becomes the reason you drop points.

What score do I need to pass the 70-457 exam, and what does it cost?

The passing score for the 70-457 exam is 700, and the official registration fee is USD 150. Retakes are not discounted — every new attempt means paying the full fee again — so it pays to measure yourself before you book. Work through the 172 practice questions on Getcertkey, sit a timed practice test, and schedule your exam only when your scores are consistently comfortable. That simple habit is the cheapest exam strategy there is.

Are there any prerequisites for the 70-457 exam?

Candidates must hold a qualifying MCTS certification on SQL Server 2008. This was a transition exam for upgrading to MCSA: SQL Server 2012. Requirements can change when Microsoft revises its certification program, so confirm the current eligibility rules on the official exam page before you register.

How do I register for the 70-457 exam?

You can book the Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 exam through the official registration channels below:

• Microsoft Certification Exam Registration

As for delivery, the exam is offered in the following format: Testing center or online proctored exam through Microsoft exam delivery partners. Choose the option that suits you best when you book your seat.

What official training is recommended for the 70-457 exam?

Microsoft recommends the following training resources for the Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 exam:

• Microsoft Learn

Official courses build the foundation; the 172 practice questions from Getcertkey then show you how that knowledge is examined, so the two work best together.

Can I try the 70-457 practice questions before I buy?

Yes. Getcertkey provides a free 70-457 PDF demo so you can review the question style and answer quality before purchasing. Every purchase also includes 365 days of free updates — if Microsoft revises the exam during that period, the updated material reaches you at no cost. Once the free-update year ends, you can extend your update service at a 50% discount.

What if I fail the 70-457 exam, and how is my order delivered?

Every Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 purchase on Getcertkey is covered by a 100% money-back guarantee with clear conditions: if you take the corresponding exam within 60 days of your purchase and do not pass, you can claim a full refund by submitting a scanned copy of your exam enrollment slip and your official score report as a PDF within two days of the exam date; claims are processed within seven days of submission. The guarantee does not apply to exams taken within three days of purchase, to material that was downloaded but never used in an exam attempt, or to free products and expired orders, and the candidate name must match the payer name. If you would rather not take a refund, you can instead exchange your purchase for two free exam preparation products of equal value and keep the update service on your original product.

Delivery is instant: your download is sent to your email within one minute of payment, with no limit on how many computers you may install the material on. If nothing arrives within two hours, check your spam folder and contact customer service for help.

What topics are covered in the 70-457 exam?

The Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 exam blueprint is organized into 4 domains. The first three are:

• Implementing Database Objects
• Implementing T-SQL Queries
• Implementing Data Storage

For the complete domain-by-domain breakdown, scroll up to the full exam topics outline above and use it to plan how you distribute your study time.

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

Question 1

You administer a SQL Server 2012 server that contains a database named SalesDb. SalesDb contains a schema named Customers that has a table named Regions. A user named UserA is a member of a role named Sales. UserA is granted the Select permission on the Regions table. The Sales role is granted the Select permission on the Customers schema. You need to ensure that the Sales role, including UserA, is disallowed to select from any of the tables in the Customers schema. Which Transact-SQL statement should you use?

A. DENY SELECT ON Schema::Customers FROM Sales
B. REVOKE SELECT ON Schema::Customers FROM UserA
C. EXEC sp_addrolemember 'Sales', 'UserA'
D. REVOKE SELECT ON Object::Regions FROM Sales
E. REVOKE SELECT ON Object::Regions FROM UserA
F. DENY SELECT ON Schema::Customers FROM UserA
G. EXEC sp_droprolemember 'Sales', 'UserA'
H. DENY SELECT ON Object::Regions FROM Sales
I. DENY SELECT ON Object::Regions FROM UserA
J. REVOKE SELECT ON Schema::Customers FROM Sales

Question 2

You develop three Microsoft SQL Server 2012 databases named Database1, Database2, and Database3. You have permissions on both Database1 and Database2. You plan to write and deploy a stored procedure named dbo.usp_InsertEvent in Database3. dbo.usp_InsertEvent must execute other stored procedures in the other databases. You need to ensure that callers that do not have permissions on Database1 or Database2 can execute the stored procedure. Which Transact-SQL statement should you use?

A. EXECUTE AS OWNER
B. EXECUTE AS CALLER
C. USE Database2
D. USE Database1

Question 3

DRAG AND DROP You administer a Microsoft SQL Server database that is used by an application. Users of the application report performance issues. You need to choose the appropriate tool for performance-tuning of SQL Server databases. Which tool or tools should you use? (To answer, drag the appropriate tool or tools to their corresponding task or tasks in the answer area. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.)
Select and Place:

Question 4

You use a Microsoft SQL Server 2012 database that contains a table named BlogEntry that has the following columns:

Id is the Primary Key.
You need to append the "This is in a draft stage" string to the Summary column of the recent 10 entries
based on the values in EntryDateTime. Which Transact-SQL statement should you use?

A. UPDATE BlogEntry SET Summary = CAST(N' This is in a draft stage' as nvarchar(max)) WHERE Id IN(SELECT TOP(10) Id FROM BlogEntry ORDER BY EntryDateTime DESC)
B. UPDATE BlogEntry SET Summary.WRITE(N' This is in a draft stage', NULL, 0) FROM ( SELECT TOP(10) Id FROM BlogEntry ORDER BY EntryDateTime DESC) AS s WHERE BlogEntry.Id = s.ID
C. UPDATE TOP(10) BlogEntry SET Summary.WRITE(N' This is in a draft stage', NULL, 0)
D. --this option was diferent im my exam UPDATE BlogEntry SET Summary.WRITE(N' This is in a draft stage', 0, 0) WHERE Id IN(SELECT TOP(10) Id FROM BlogEntry ORDER BY EntryDateTime DESC)

Question 5

You develop a Microsoft SQL Server 2012 database that has two tables named SavingAccounts and LoanAccounts. Both tables have a column named AccountNumber of the nvarchar data type. You use a third table named Transactions that has columns named TransactionId, AccountNumber, Amount, and TransactionDate. You need to ensure that when multiple records are inserted in the Transactions table, only the records that have a valid AccountNumber in the SavingAccounts or LoanAccounts are inserted. Which Transact-SQL statement should you use?

A. CREATE TRIGGER TrgValidateAccountNumber ON Transactions FOR INSERT AS BEGIN
INSERT INTO Transactions SELECT TransactionID,AccountNumber,Amount,TransactionDate FROM inserted WHERE AccountNumber IN (SELECT AccountNumber FROM LoanAccounts UNION SELECT AccountNumber FROM SavingAccounts)) END
B. CREATE TRIGGER TrgValidateAccountNumber ON Transactions FOR INSERT AS BEGIN
IF EXISTS (
SELECT AccountNumber FROM inserted EXCEPT
(SELECT AccountNumber FROM LoanAccounts
UNION SELECT AccountNumber FROM SavingAccounts))
BEGIN
ROLLBACK TRAN
END
END
C. CREATE TRIGGER TrgValidateAccountNumber ON Transactions INSTEAD OF INSERT AS BEGIN
IF EXISTS (
SELECT AccountNumber FROM inserted EXCEPT
(SELECT AccountNumber FROM LoanAccounts
UNION SELECT AccountNumber FROM SavingAccounts))
BEGIN
ROLLBACK TRAN
END
END
D. CREATE TRIGGER TrgValidateAccountNumber ON Transactions INSTEAD OF INSERT AS BEGIN
INSERT INTO Transactions SELECT TransactionID,AccountNumber,Amount,TransactionDate FROM inserted WHERE AccountNumber IN (SELECT AccountNumber FROM LoanAccounts UNION SELECT AccountNumber FROM SavingAccounts)) END

Solutions: