| トピック | 出題範囲 |
|---|
| トピック 1 | - Change Binding Options For Partitions; Choose The Appropriate Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP)
|
| トピック 2 | - Choose The Proper Partitioning Strategy For The Data Warehouse And Cube, Implement A Parallel Load To Fact Tables By Using Partition Switching
|
| トピック 3 | - Configure Security And Impersonation Between SQL Server Service, Analysis Services, And Front End
|
| トピック 4 | - Install And Configure Power View, Publish Powerpivot And Power View To Sharepoint
- Linked Drill-Down Reports, Drill-Through Reports, And Sub Reports; Design Report Migration Strategies
|
| トピック 5 | - Identify The Data Sources That Need To Be Used To Pull In The Data, Determine The Changes (Incremental Data) In The Data Source (Time Window)
|
| トピック 6 | - Design A Recovery Strategy, Back Up And Restore SSAS Databases, Back Up And Restore SSRS Databases, Move And Restore The SSIS Catalog, Design An Alwayson Solution
|
| トピック 7 | - Design Authentication Mechanisms; Design Security Tests; Build Secure Solutions End To End; Design Roles For Calculated Measures
|
| トピック 8 | - Appropriately Index A Fact Table; Optimize Analysis Services Cubes In SQL Server Data Tools; Create Aggregations
|
| トピック 9 | - Including Multidimensional Expression (MDX) And Data Analysis Expression (DAX) Queries
|
| トピック 10 | - Integration Services (SSIS)
- SQL And Processing Phase In Analysis Services
|
| トピック 11 | - Understand Performance Consequences Of Named Queries In A Data Source View; Analyze And Optimize Performance
|
| トピック 12 | - Hybrid OLAP (HOLAP) Storage Modes
- Design A Logging And Auditing Strategy
|
| トピック 13 | - Configure Proactive Caching Within SQL Server Analysis Services (SSAS) For Different Scenarios
|
| トピック 14 | - Configure Data Refresh Schedules For Powerpivot Published To Sharepoint, Publish BI Info To Sharepoint, Use Sharepoint To Accomplish BI Administrative Tasks
|
| トピック 15 | - Understand The Tradeoffs Between Regular SSAS Security And Dynamic Security
- Design A SQL Partitioning Strategy
|
| トピック 16 | - Validate Data Is Balancing And Reconciling Correctly
- Choose The Appropriate Reporting Services Requirements (Including Native Mode And Sharepoint Mode)
|
| トピック 17 | - Understand The Difference Between Partitioning For Load Performance Versus Query Performance In SSAS
|
| トピック 18 | - Plan And Manage Reporting Services Configuration
- Manage Excel Services
- Reporting For Sharepoint
- Design Appropriate Data Query Parameters, Create Appropriate SQL Queries
|
| トピック 19 | - Design A High Availability And Disaster Recovery Strategy
- Design A New SSIS Logging Infrastructure (For Example, Information Available Through The Catalog Views)
|
| トピック 20 | - Optimize Batch Procedures: Extract, Transform, Load (ETL) In SQL Server
|
| トピック 21 | - Implement Dynamic Dimension Security Within A Cube; Configure Security For An Extranet Environment; Configure Kerberos Security|\
|