Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan - 70-448 Exam Practice Test
You develop a SQL Server 2008 Reporting Services (SSRS) solution.
You add a report that contains a single dataset and a query parameter.
You need to ensure that the report executes without user interaction from the Report Manager.
What should you do?
You add a report that contains a single dataset and a query parameter.
You need to ensure that the report executes without user interaction from the Report Manager.
What should you do?
Correct Answer: B
Vote an answer
You maintain for SQL Server 2008 Integration (SSIS) instance. You develop an SSIS package by using development environment database connections.
The package fails to execute in the production environment. Connection strings in the package are empty.
You need to change the package protection levels. What should you do?
The package fails to execute in the production environment. Connection strings in the package are empty.
You need to change the package protection levels. What should you do?
Correct Answer: B
Vote an answer
You are working as reporting administrator for a product development company. The company uses SQL
Server 2008 Reporting Services (SSRS) deployed in a native mode.
You need to deploy multiple reports via InstallShield.
Which three components are you required to use? (Each correct answer presents part of the solution.
Choose three.)
Server 2008 Reporting Services (SSRS) deployed in a native mode.
You need to deploy multiple reports via InstallShield.
Which three components are you required to use? (Each correct answer presents part of the solution.
Choose three.)
Correct Answer: B,D,E
Vote an answer
You develop reports by using SQL Server 2008 Reporting Services (SSRS) Enterprise Edition. You need to use data-driven subscription to distribute reports based on dynamic subscription data. Which role should you use?
Correct Answer: A
Vote an answer
You maintain a SQL Server 2008 Analysis Services (SSAS) database that contains a Product dimension.
The dimension contains the Category and Subcategory attributes.
The attributes have a Rigid relationship typE.The data source for the Product dimension changes the
relationship between the Category and Subcategory values.
You need to execute an XML for Analysis (XMLA) command to process the dimension to successfully
reflect the changE.What should you do?
The dimension contains the Category and Subcategory attributes.
The attributes have a Rigid relationship typE.The data source for the Product dimension changes the
relationship between the Category and Subcategory values.
You need to execute an XML for Analysis (XMLA) command to process the dimension to successfully
reflect the changE.What should you do?
Correct Answer: C
Vote an answer
You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to run the Usage-Based Optimization Wizard.
You need to enable query logging.
What should you do?
You plan to run the Usage-Based Optimization Wizard.
You need to enable query logging.
What should you do?
Correct Answer: D
Vote an answer
You implement a SQL Server 2008 Integration Services (SSIS) package.
The package contains the following components:
A Foreach Loop container for the Collection property as shown in the following exhibit. (Click the Exhibit
button.)
A Foreach Loop container for the Variable Mappings property as shown in the following exhibit. (Click the
Exhibit button.)
A String variable named FileName.
A String variable named DirectoryPath.
You need to update the package so that the DirectoryPath variable returns the directory path for the file
path stored in the FileName variable.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
The package contains the following components:
A Foreach Loop container for the Collection property as shown in the following exhibit. (Click the Exhibit
button.)
A Foreach Loop container for the Variable Mappings property as shown in the following exhibit. (Click the
Exhibit button.)
A String variable named FileName.
A String variable named DirectoryPath.
You need to update the package so that the DirectoryPath variable returns the directory path for the file
path stored in the FileName variable.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
Correct Answer: D,E
Vote an answer
You are implementing a disaster recovery strategy for SQL Server 2008 Reporting Services (SSRS).
You want to be able to restore the report catalog database in the event of a failure.
You need to back up the encryption key.
Which command line utility should you use?
You want to be able to restore the report catalog database in the event of a failure.
You need to back up the encryption key.
Which command line utility should you use?
Correct Answer: B,D
Vote an answer