Microsoft 70-448 Actual Free Exam Questions & Community Discussion
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: C,D
Vote an answer
You develop a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a parameter named @SalesTaxRateID.
You set the value of the @SalesTaxRateID parameter in the report by selecting a specific region.
You need to configure the report to prevent users from modifying the value of the @SalesTaxRateID
parameter. What should you do?
The report contains a parameter named @SalesTaxRateID.
You set the value of the @SalesTaxRateID parameter in the report by selecting a specific region.
You need to configure the report to prevent users from modifying the value of the @SalesTaxRateID
parameter. What should you do?
Correct Answer: D
Vote an answer
You manage the security in SQL Server 2008 R2 Reporting Services (SSRS).
You create a new role.
You need to grant the following permissions to the role:
View and modify security settings for reports, folders, resources, and shared data sources.
Create and delete reports.
Modify report properties.
View content, definition, and property for reports.
Which three actions should you perform? (Each correct answer presents part of the solution, Choose
three.)
You create a new role.
You need to grant the following permissions to the role:
View and modify security settings for reports, folders, resources, and shared data sources.
Create and delete reports.
Modify report properties.
View content, definition, and property for reports.
Which three actions should you perform? (Each correct answer presents part of the solution, Choose
three.)
Correct Answer: B,C,E
Vote an answer
You maintain a SQL Server 2008 Integration Services (SSIS) instancE.The instance stores packages in
a SQL Server 2008 instance.
You need to deploy the package of an instance of SSIS to another SSIS instance that stores its packages in
a shared directory.
What should you do?
a SQL Server 2008 instance.
You need to deploy the package of an instance of SSIS to another SSIS instance that stores its packages in
a shared directory.
What should you do?
Correct Answer: D
Vote an answer
Note: This question is part of a series of questions that use the same or 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 a SQL Server 2008 Reporting Services (SSRS) instance for a shoe company.
An existing report on shoe sales allows the user to see the company's revenue across many different
attributes.
You need to create a drop down list that filters the report by one or more shoe colors.
You alter the main dataset and configure the report parameter to accept multiple values.
What should you do next?
You maintain a SQL Server 2008 Reporting Services (SSRS) instance for a shoe company.
An existing report on shoe sales allows the user to see the company's revenue across many different
attributes.
You need to create a drop down list that filters the report by one or more shoe colors.
You alter the main dataset and configure the report parameter to accept multiple values.
What should you do next?
Correct Answer: F
Vote an answer
You create a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a tablE.You need to ensure that alternate rows in the table have a pale green
backgrounD.Which code segment should you use for each text box?
The report contains a tablE.You need to ensure that alternate rows in the table have a pale green
backgrounD.Which code segment should you use for each text box?
Correct Answer: A
Vote an answer
0
0
0
10