We're so confident of our products that we provide no hassle product exchange.
Microsoft 70-448 Exam Overview:
| Certification Vendor: | Microsoft |
| Exam Name: | TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance |
| Exam Number: | 70-448 |
| Available Languages: | English |
| Real Exam Qty: | Approximately 40-60 |
| Certificate Validity Period: | Retired certification (historically no expiration while active; now discontinued) |
| Exam Duration: | 120 minutes |
| Related Certifications: | MCTS: SQL Server 2008 Database Development MCTS: SQL Server 2008 Implementation and Maintenance |
| Passing Score: | 700/1000 |
| Exam Price: | $165 USD (varies by region) |
| Exam Format: | Multiple Choice, Case Studies, Build List and Reorder, Drag and Drop |
| Recommended Training: | Microsoft SQL Server 2008 Business Intelligence Training Kit (70-448) |
| Exam Registration: | Microsoft Certification / Exam Registration (retired) |
| Sample Questions: | Microsoft 70-448 Sample Questions |
| Exam Way: | Computer-based exam at test center or online proctored (historical Microsoft certification delivery model) |
| Pre Condition: | Familiarity with SQL Server 2008 BI components (SSIS, SSAS, SSRS) and basic database concepts is recommended. |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/previous-versions/ |
Microsoft 70-448 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| SQL Server Integration Services (SSIS) | - Deployment and Maintenance
|
| BI Solution Management | - Maintenance and Monitoring
|
| SQL Server 2008 Business Intelligence Platform | - BI Architecture Overview
|
| SQL Server Analysis Services (SSAS) | - Cube Development
|
| SQL Server Reporting Services (SSRS) | - Report Deployment
|
Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan Sample Questions:
1. You maintain a SQL Server 2008 Analysis Service (SSAS) database in a test environment. You plan to deploy changes from as SSAS project in a development environment to the test environment are replaced by the deployment.
What should you do?
A) Update the database by using the Deployment Wizard.
B) Back up the development database and restore it to the test environment.
C) Update the database by using the Synchronize Database Wizard.
D) Process the database by using the Business Intelligence Design Studio (BIDS).
2. You administer a SQL Server 2008 Analysis Services (SSAS) instancE.You plan to troubleshoot query
performance by using a Dynamic Management View (DMV).
You need to identify query sessions that execute a query for more than 30,000 ms.
Which DMV should you use?
A) Discover_Traces
B) Discover_Connections
C) Discover_Sessions
D) Discover_Commands
3. You are editing a SQL Server 2008 Integration Services (SSIS) package by using Business Intelligence
Development Studio. The package uses a custom data flow component. The package runs successfully.
You attempt to add another instance of the custom data flow component to the package. The data flow
component does not appear in the toolbox or in the Choose Toolbox Items dialog box.
You need to add the custom data flow component to the toolbox.
What should you do?
A) Register the assembly by using the Assembly Registration utility (REGASM.EXE).
B) Register the assembly by using the REGSVR32 utility.
C) Add the assembly to the Global Assembly Cache.
D) Copy the assembly to the appropriate folder.
4. You develop a SQL Server 2008 Analysis Services (SSAS) database.
Your database includes several measure groups. A measure group named Sales Data requires frequent
updates than other measure groups.
You need to ensure that the Sales Data measure group will automatically process on a schedule managed
by SSAS.
What should you do?
A) Modify the ProactiveCaching property.
B) Modify the ProcessingPriority property.
C) Modify the ProcessingMode property.
D) Modify the DataAggregation property.
5. You create a report by using SQL Server 2008 Reporting Services (SSRS).
The report is complex and takes several minutes to generate.
You need to configure the report server to cache the report for 30 minutes after the initial request.
What should you do?
A) Configure the data source to use a database snapshot.
B) Implement report execution caching.
C) Configure the data source to use snapshot isolation.
D) Implement report snapshots.
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: D | Question # 3 Answer: D | Question # 4 Answer: A | Question # 5 Answer: B |
By Naomi
