We're so confident of our products that we provide no hassle product exchange.
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 |
| Exam Format: | Scenario-based Questions, Case Studies, Multiple Choice |
| Related Certifications: | MCTS: SQL Server 2008 MCSA: SQL Server 2012 |
| Exam Price: | USD 165 (varies by region; retired exam pricing no longer active) |
| Certificate Validity Period: | Retired (no longer available; certification legacy) |
| Available Languages: | English, Japanese, Simplified Chinese |
| Exam Duration: | 120-150 |
| Passing Score: | 700 (on a 1000 scale) |
| Real Exam Qty: | 40-60 |
| Recommended Training: | SQL Server documentation Microsoft Learn SQL Server training |
| Exam Registration: | Microsoft Credentials (official certification portal) Pearson VUE Microsoft Exams Registration |
| Sample Questions: | Microsoft 070-458 Sample Questions |
| Exam Way: | Proctored exam delivered via Pearson VUE (online proctored or test center depending on region availability at time of exam). |
| Pre Condition: | Recommended prerequisite: MCTS certification on SQL Server 2008 technologies or equivalent SQL Server administration/development experience. |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/ |
Microsoft 070-458 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Implement SQL Server Integration Services (SSIS Solutions) | - Design and manage ETL workflows
|
| Topic 2: Implement Reporting Solutions (SSRS) | - Create and manage reports
|
| Topic 3: Implement SQL Server Analysis Services (SSAS) | - Design and manage OLAP solutions
|
| Topic 4: Manage and Maintain SQL Server BI Solutions | - Security and performance considerations
|
| Topic 5: Implement Data Warehouses | - Design and build data warehouse structures
|
Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 Sample Questions:
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_columns DMV.
- B. Use the Database Engine Tuning Advisor.
- C. Query the sys.dm_db_missing_index_details DMV.
- D. Query the sys.dm_db_index_usage_stats DMV.
Correct Answer: B 🗳️
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?
- A. setupadmin
- B. securityadmin
- C. loginmanager
- D. serveradmin
Correct Answer: C 🗳️
You administer two Microsoft SQL Server 2012 servers named ProdSrv1 and ProdSrv2. ProdSrv1 is configured as a Distributor. Both servers are configured to use the windows NT Service virtual accounts for all SQL Services.
You are configuring snapshot replication from ProdSrv1 to ProdSrv2 by using ProdSrv2 as a pull subscriber.
The distribution agent on ProdSrv2 regularly fails, displaying the following error message:
"Cannot access the file. Operating system error code 5 (Access is denied.)."
You need to configure the distribution agent by granting only the minimum required access to all accounts.
What should you do?
- A. Configure the SQL Server Agent service to run under a Windows domain account. Configure the Subscriber to use the SQL Server Agent service account. Grant FULL CONTROL access for the domain account to the ReplData share on ProdSrv1.
- B. Configure the Subscriber to use the Local System account.
- C. Configure the SQL Server Agent service to run under the Local System account. Configure the Subscriber to use the SQL Server Agent service account.
- D. Configure the Subscriber to use a Windows domain account. Grant READ access for the domain account to the ReplData share on ProdSrv1.
Correct Answer: D 🗳️
You are creating a Data Quality Services (DQS) solution. You must provide statistics on the accuracy of the data.
You need to use DQS profiling to obtain the required statistics.
Which DQS activity should you use?
- A. Matching Policy
- B. Cleansing
- C. Knowledge Discovery
- D. Matching
Correct Answer: B 🗳️
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system.
Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged to a CSV file for auditing purposes.
You need to establish the best technique to log these invalid rows while minimizing the amount of development effort.
What should you do?
- A. Add a data tap on the output of a component in the package data flow.
- B. Use the Project Deployment Wizard.
- C. Create an OnError event handler.
- D. Deploy the package to the Integration Services catalog by using dtutfl and use SQL Server to store the configuration.
- E. Run the package by using the dtexecui.exe utility and the SQL Log provider.
- F. Use the gacutil command.
- G. Use the dtutil /copy command.
- H. Deploy the package by using an msi file.
- I. Run the package by using the dtexec /dumperror /conn command.
- J. Run the package by using the dtexec /rep /conn command.
- K. Create a reusable custom logging component.
Correct Answer: A 🗳️
By Jerome
