| Exam | Credit For | Selected Topics |
| 70-461: Querying Microsoft SQL Server 2012 |
- MCSA for SQL Server 2012
- MCSE for SQL Server 2012 Data Platform
- MCSE for SQL Server 2012 Business Intelligence
|
- Create/design tables and views
- Use joins, sub-queries, new data types and query features
- Create/design/modify stored process, aggregate functions, triggers
- Modify data with INSERT/UPDATE/DELETE/MERGE
- Design/apply user-defined functions
|
| 70-462: Administering Microsoft SQL Server 2012 Databases |
- MCSA for SQL Server 2012
- MCSE for SQL Server 2012 Data Platform
- MCSE for SQL Server 2012 Business Intelligence
|
- Install SQL Server 2012 and related services
- Create and manage SQL Server instances, including a clustered instance
- Diagnose and respond to blocking, locking, deadlocking
- Backup and restore databases
- Implement and maintain indexes
- Contrast and compare AlwaysOn technologies
|
| 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012 |
- MCSA for SQL Server 2012
- MCSE for SQL Server 2012 Data Platform
- MCSE for SQL Server 2012 Business Intelligence
|
- Design/implement star vs. snowflake schemas, fact tables, dimensions, keys
- Create/apply project level connection managers, slowly changing dimensions, fuzzy lookups
- Execute SSIS packages with SSMS, DTEXEC, SQL Server Agent
- Create, assign, read variables and parameters
- Plan and implement full and incremental loads for data warehouses
- Implement solutions with Data Quality Services
|
| 70-464: Developing Microsoft SQL Server 2012 Databases | MCSE for SQL Server 2012 Data Platform |
- Create/implement database objects without using built-in tools
- Apply data types: CLR, sequential GUID values, spatial
- Understand relative advantages of database tables, temporary tables, and table variables
- Create, assign, read variables and parameters
- Create and alter indexes, including filtered, semantic, XML
- Optimize queries with execution plans and DTA
|
| 70-465: Designing Database Solutions for Microsoft SQL Server 2012 | MCSE for SQL Server 2012 Data Platform |
- Apply physical database issues, such as filestream and file groups
- Monitor an instance using such tools as Profiler, Perfmon and DMVs
- Automate (setup, maintenance, monitoring) across multiple databases and multiple instances
- Design instance-level security, such as logon triggers, transparent data encryption, DDL triggers
- Manage maintenance administration, such as rebuild vs. defrag indexes, online vs. offline index rebuild
- Implement high availability via clustered servers, mirroring, replication
|
| 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012 | MCSE for SQL Server 2012 Business Intelligence |
- Implement cubes: build cube with SQL Server Data Tools, configure additive and non-additive measures, and implement many-to-many relationships
- Create and debug MDX queries
- Contrast multidimensional and tabular data models
- Deploy SSAS databases
- Know SSRS report and design issues, such as crosstab report, drill-down reports, report parameters
- Configure report data sources and datasets
|
| 70-467: Designing Database Solutions for Microsoft SQL Server 2012 | MCSE for SQL Server 2012 Business Intelligence |
- Specify and optimize MDX and DAX queries
- Use partitioning to speed up the loading of a fact table
- Design a BI reporting architecture, including such features as linked reports, drill-down reports, sub reports
- Know when to choose between UDM and BISM
- Possess a working knowledge of how to implement MDX calculations
- Design SSIS deployments using the project deployment model, passing values at execution time, sharing parameters between packages
|
