You need to ensure that the package runs and loads additional files even if an error occurs during the loading
You are developing a SQL Server 2008 Integration Services (SSIS) package. The package
extracts data from text files and loads the data to a SQL Server 2008 database. You
configure the data flows to fail on a single error.
The control flow package is as shown in the following exhibit. (Click the Exhibit button.)
The package extracts data from files that are stored in two folders. Each folder can store a
maximum of 10 files.
You need to ensure that the package runs and loads additional files even if an error occurs
during the loading of a file.
What should you do?
Which command line utility should you use?
You maintain a SQL Server 2008 Reporting Services (SSRS) instance.
You plan to implement a failure recovery plan.
You need to back up the report server encryption key.
Which command line utility should you use?
Which rendering extensions should the users select?
You administer an instance of SQL Server 2008 Reporting Services.
You deploy various drill-down reports to the server. When users render these reports, detail
information that must be hidden by default is always present.
You need to ensure that users use an appropriate rendering extension that supports the
toggling of visibility.
Which rendering extensions should the users select?
Which partition query WHERE clauses should you use?
You create a SQL Server 2008 Analysis Services (SSAS) solution.
You have a table named FactSales that contains columns named Country and Year.
You discover that data is frequently queried for the following values:
The Country column as USA
The Year column as 2008
You decide to implement two partitions for the measure group based on the FactSales table.
The first partition contains the frequently queried data and the second partition contains the
remaining fact table data.
Which partition query WHERE clauses should you use?
You need to ensure that the following requirements are met: The data source view uses the altered table name a
You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a data source
view.
You add a table named Customer from the data source to the data source view.
You alter the name of the table from Customer to DimCustomer in the data source.
You need to ensure that the following requirements are met:
The data source view uses the altered table name as the source.
All existing relationships and table references are preserved.
What should you do?
You need to configure the server so that all reports render only to Microsoft Excel
You maintain a SQL Server 2008 Reporting Services (SSRS) instance.
Your instance supports several different rendering extensions.
You need to configure the server so that all reports render only to Microsoft Excel.
What should you do?
Which expression should you use?
You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution contains a
time dimension named DimTime that contains a hierarchy named Yr-Qtr-Mth.
You have a measure named Amount from a measure group named Measures.
You need to create a calculated member to display the Amount measure in the previous time
period for the current level of the Yr-Qtr-Mth hierarchy.
Which expression should you use?
Which DTExec command line option should you use?
You develop a SQL Server 2008 Integration Services (SSIS) package.
You discover that the package fails and returns an error code of 0x80040E4D.
You need to ensure that the package generates the debug dump files that are associated
with the package only when this error code occurs.
Which DTExec command line option should you use?
You need to modify the package so that the Script task can assign the value of the variable
You design a SQL Server 2008 Integration Services (SSIS) package.
The package assigns a value to a variable by using a Script task. When the package
executes successfully, the value of the variable is not updated.
You need to modify the package so that the Script task can assign the value of the variable.
What should you do?
Which code segment should you use in the report header?
You create a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a table that displays a list of products. The list of products includes the
three fields named ProductName, ProductCategory, and ProductPrice. The table contains a
textbox named ProductCategory that displays the ProductCategory field.
The dataset is sorted by ProductCategory.
You need to ensure that the report header displays the ProductCategory of the first product
listed on each page of the report.
Which code segment should you use in the report header?