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 |
| Related Certifications: | MCITP: Business Intelligence Developer 2008 MCTS: SQL Server 2008 |
| Exam Format: | Simulation / Performance-based, Multiple choice |
| Available Languages: | French, English, German, Japanese |
| Passing Score: | 700 out of 1000 |
| Certificate Validity Period: | Retired (since July 31, 2013) |
| Exam Price: | $125 USD |
| Exam Duration: | 120 minutes |
| Real Exam Qty: | 45-50 |
| Recommended Training: | Self-Paced Training Kit (Exam 70-448) Microsoft Official Course 6235: Implementing and Maintaining SQL Server 2008 BI |
| Exam Registration: | Prometric Registration |
| Sample Questions: | Microsoft 70-448 Sample Questions |
| Exam Way: | Proctored onsite test at authorized Prometric centers |
| Pre Condition: | No formal prerequisites; recommended experience with SQL Server 2008 BI components |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/previous-versions//gg697607(v=technet.10) |
Microsoft 70-448 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Implementing SQL Server Analysis Services (SSAS) Solutions | 20-25% | - Design and implement dimensions and hierarchies - Design and implement cubes and measures - Implement data mining models - Implement MDX queries and calculations |
| Implementing SQL Server Reporting Services (SSRS) Solutions | 15-20% | - Implement custom code and embedded resources - Implement parameters, expressions, and interactivity - Design and develop reports and datasets |
| Configuring and Managing SSRS Solutions | 10-15% | - Deploy, deliver, and schedule reports - Monitor and troubleshoot report execution - Configure report server settings and security |
| Configuring and Managing SSAS Solutions | 10-15% | - Configure security roles and permissions - Optimize storage and query performance - Process and maintain cubes and dimensions |
| Implementing SQL Server Integration Services (SSIS) Solutions | 25-30% | - Implement package configurations and deployments - Design and implement control flow - Design and implement data flow - Configure package logging and error handling |
| Configuring, Deploying, and Maintaining SSIS Solutions | 20-25% | - Troubleshoot and optimize SSIS performance - Manage package execution and security - Use checkpoints and transactions |
Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan Sample Questions:
Question 1
You are developing a SQL Server 2008 Integration Services (SSIS) project in Business Intelligence
Development Studio.
You configure the project properties as shown in the following image.
You need to create a deployment manifest for all packages in the project.
What should you do?
A. View the code of each Data Transformation Services (DTS) package. Copy the first <DTS:Property> xml node to a file with a .SSISDeploymentManifest file extension.
B. Modify the AllowConfigurationChanges property of the project.
C. Copy each package. Rename each copy with a .SSISDeploymentManifest file extension.
D. Build the Integration Services project.
Question 2
Note: This question is part of a series of questions that use the same of 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 maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare device manufacturing company.
You develop a package named Memberinformation.dtsx with Windows authentication. You deploy it to SQL Server.
You need to validate Memberinformation.dtsx packages without package execution.
Which command syntax should you use?
A. dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /COPY SQL; Memberinformation.dtsx
B. dtexec /f " Z:\ Memberinformation.dtsx " /conf "
Z: \Memberinformationconfig,cfg "
C. dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /DestServer DBPROD /COPY SQL; Memberinformation.dtsx
D. dtexec /f "c: \ Memberinformation .dtsx" /1 " DTS.LogProviderTextFile;Y:\Loginformation.txt"
E. dtutil /SQL Memberinformation /COPY DTS;c:\SSISpackages\Memberinformation
F. dtexec /sq Memberinformation / verify (a400e860-38d5-11c5-11ce-ae62-08002b2b79ef)
G. dtexec /sq Memberinformation /ser productionServer / va
H. dtutil /FILE c:\SSISpackages\Memberinformation.dtsx /COPY FILE;W: \ProdSSISpackages\ Memberinformation_Prod.dtsx
Question 3
You manage the security in SQL Server 2008 Reporting Services (SSRS). The report server contains a
folder named Management Reports.
All groups can view and modify reports in any folder.
You need to ensure that only the Managers group can view and modify reports in the Management Reports
folder.
What should you do?
A. Create a Managers rolE. Assign the Managers role to the root folder. Remove all groups from the Management Reports folder.
B. Add the Managers group to the root folder and assign the Content Manager rolE. Remove all groups from the Management Reports folder.
C. Create a Managers role. Assign the Managers role to the Management Reports folder. Remove all other groups from the Management Reports folder.
D. Remove all groups from the Management Reports folder. Add the Managers group to the folder and assign the Content Manager role.
Question 4
Note: This question is part of a series of questions that use the same of 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 maintain the SQL Server 2008 Integration Services (SSIS) instances for a an insurance company.
You develop a package named Memberinformation.dtsx and save it in the SSISpackages folder on the company network. The package is configured externally to the file Mamberinformationconfig.cfg.
You need to execute the package.
Which command syntax should you use?
A. dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /COPY SQL; Memberinformation.dtsx
B. dtexec /f " Z:\ Memberinformation.dtsx " /conf "
Z: \Memberinformationconfig,cfg "
C. dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /DestServer DBPROD /COPY SQL; Memberinformation.dtsx
D. dtexec /f "c: \ Memberinformation .dtsx" /1 " DTS.LogProviderTextFile;Y:\Loginformation.txt"
E. dtutil /SQL Memberinformation /COPY DTS;c:\SSISpackages\Memberinformation
F. dtexec /sq Memberinformation / verify (a400e860-38d5-11c5-11ce-ae62-08002b2b79ef)
G. dtexec /sq Memberinformation /ser productionServer / va
H. dtutil /FILE c:\SSISpackages\Memberinformation.dtsx /COPY FILE;W: \ProdSSISpackages\ Memberinformation_Prod.dtsx
Question 5
You are a server administrator of a SQL Server 2008 Analysis Services (SSAS) instance. The instance
contains a database that is used by the members of the Sales group.
You configure a new role named Northern Region by using the "{[Customers].[Region].[Region].[Northern]}"
allowed permission set.
You assign the Sales group to the Northern Region role.
You need to verify that users in the Northern Region role can view data only for their region.
What should you do?
A. Select the Enable Visual Totals check box for the Northern Region role.
B. Add the Roles=Northern Region; parameter to the connection string.
C. Temporarily add your account to the Northern Region role.
D. Add the User ID=Northern Region; parameter to the connection string.
Solutions:
| Question 1 Answer: D | Question 2 Answer: G | Question 3 Answer: D | Question 4 Answer: B | Question 5 Answer: B |
By Nelly
