We're so confident of our products that we provide no hassle product exchange.
Microsoft 70-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 |
| Related Certifications: | MCSA: SQL Server 2012 MCTS: SQL Server 2008 |
| Available Languages: | Simplified Chinese, English, Japanese |
| Certificate Validity Period: | Retired (no longer available; certification legacy) |
| Exam Duration: | 120-150 |
| Exam Format: | Multiple Choice, Scenario-based Questions, Case Studies |
| Passing Score: | 700 (on a 1000 scale) |
| Real Exam Qty: | 40-60 |
| Exam Price: | USD 165 (varies by region; retired exam pricing no longer active) |
| 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 70-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 70-458 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Manage and Maintain SQL Server BI Solutions | - Security and performance considerations
|
| Topic 2: Implement SQL Server Analysis Services (SSAS) | - Design and manage OLAP solutions
|
| Topic 3: Implement Reporting Solutions (SSRS) | - Create and manage reports
|
| Topic 4: Implement SQL Server Integration Services (SSIS Solutions) | - Design and manage ETL workflows
|
| 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 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. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION setupadmin;
- B. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION serveradmin;
- C. GRANT VIEW DEFINITION TO [SpecialDBARole];
- D. GRANT VIEW SERVER STATE, VIEW ANY DATABASE TO [SpecialDBARole];
- E. ALTER SERVER ROLE [SpecialDBARole] ADD MEMBER [DOMAIN\JrDBAs];
- F. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION securityadmin;
Correct Answer: D,E,F 🗳️
You are installing the Data Quality Server component of Data Quality Services.
You need to provision the hardware and install the software for the server that runs the
Data Quality Server.
You must ensure that the minimum Data Quality Server prerequisites are met.
What should you do?
- A. Install SQL Server 2012 Database Engine.
- B. Install the .NET Framework 4.0.
- C. Install Microsoft Internet Explorer 6.0 SP1 or later.
- D. Install Microsoft SharePoint Server 2010 Enterprise Edition with PowerPivot.
Correct Answer: A 🗳️
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 S 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 implement log shipping of the financial database to another SQL Server 2012 instance. You decide to failoverto this secondary database.
You need to ensure that all transactions will be replicated to the secondary database.
Which backup option should you use?
- A. FULL
- B. SIMPLE
- C. CHECKSUM
- D. CONTINUE_AFTER_ERROR
- E. Differential
- F. SKIP
- G. COPY_ONLY
- H. STANDBY
- I. BULK_LOGGED
- J. Transaction log
- K. RESTART
- L. NO_CHECKSUM
- M. DBO_ONLY
- N. NORECOVERY
Correct Answer: N 🗳️
DRAG DROP
You are building a SQL Server Integration Services (SSIS) package to load product data sourced from aWindows Azure SQL Database database to a data warehouse. Before the product data is loaded, you create a batch record by using an Execute SQL task named Create Batch. After successfully loading the product data, you use another Execute SQL task named Set Batch Success to mark the batch as successful.
You need to create and execute an Execute SQL task to mark the batch as failed if either the Create Batch or Load Products taskfails.
Which three steps should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Correct Answer:
You administer a SQL Server 2012 database instance.
You need to configure the SQL Server Database Engine service on a failover cluster.
Which user account should you use?
- A. a domain user
- B. the BUILTIN\SYSTEM account
- C. a local user with Run as Service permissions
- D. the SQLBrowser account
Correct Answer: A 🗳️
By Ingram
