Online Access Free 070-452 Exam Questions

You design a Business Intelligence (BI) solution by using SQL Server 2008. A SQL Server 2008 Reporting Services (SSRS) instance contains a report. Employees execute the report by using Report Manager. Each employee has his own specific set of parameters to execute the report. Data for the report is updated once daily. For each employee, the report takes more than five minutes to execute. You discover that data retrieval takes most of the time during report execution. You need to reduce the execution time of the report. What should you do?

• A.Create a standard subscription that uses the file share delivery method.
• B.Create a data-driven subscription that uses the NULL delivery method.
• C.Create a data-driven subscription that uses the file share delivery method.
• D.Create a report execution snapshot.

You design a SQL Server 2008 Reporting Services (SSRS) solution. The solution contains a report. The
report includes information that is grouped into hierarchical levels. You need to ensure that the solution
meets the following requirements:
When you click each level, the next level of information must be displayed. When you click the last level,
detailed information must be displayed. When the report is exported to a Microsoft Excel spreadsheet, all
the levels and all detailed information must be available in the spreadsheet.
Which feature should the report use?

• A.drilldown
• B.filter
• C.drillthrough
• D.a document map

You design a Business Intelligence (BI) solution by using SQL Server 2008. You are building an extract,
transform, and load (ETL) process by using SQL Server 2008 Integration Services (SSIS).
You stage data in a SQL Server 2008 database. You load a data warehouse that has 15 dimension tables
and 3 fact tables.
You need to design a control flow that meets the following requirements:
-Each table must be loaded with its own SSIS package. All packages must be controlled from a master
package.
-Dimension tables must have no interdependencies.
-Dimension tables must load without error before the Fact tables are loaded.
-Master package parallelism must be maximized.
What should you do?

• A.Place an Execute Package task inside a Foreach Loop container and change the connection string for the Execute Package task on each iteration. Connect the Fact packages to the end of the Foreach Loop container by using a precedence constraint set to Success. Set the FailPackageOnFailure property to True for the Foreach Loop container.
• B.Connect the dimension packages by using a precedence constraint set to Success. Connect the Fact packages to the end of the dimension packages by using a precedence constraint set to Success. Set the FailPackageOnFailure property to True for each dimension package.
• C.Place the dimension packages in a sequence container and connect them by using a precedence constraint set to Success. Use a precedence constraint set to Success to connect another sequence container holding the Fact packages.
• D.Place the dimension packages in a sequence container. Use a precedence constraint set to Success to connect another sequence container holding the Fact packages. Set the FailParentOnFailure property to True for each dimension package.

You are the administrator of your company network. You use Server 2008 to develop a Business Intelligence (BI) solution. Now you??re in charge of designing SQL Server2008 Integration Services (SSIS) projects. You intend to deploy the projects in the following manner: A parent package on an instance that is named SSIS1.Three child packages individually on three instances that are named SSIS2, SSIS3, and SSIS4. So what should you do to make sure that the parent package can discover the execution state of the child packages?

• A.You should configure the parent package to log its events to a SQL Server Profiler log provider.
• B.You should configure the child packages to log their events to a SQL Server log provider.
• C.You should configure the child packages to log their events to a SQL Server Profiler log provider.
• D.You should configure the parent package to log its events to a SQL Server log provider.

You design a Business Intelligence (BI) solution by using SQL Server 2008. You need to load data into your online transaction processing (OLTP) database once a week by using data from a flat file. The file contains all the details about new employees who joined your company last week. The data must be loaded into the tables shown in the exhibit. (Click the Exhibit button.) Employee.EmployeeID is an identity.

A SQL Server 2008 Integration Services (SSIS) package contains one data flow for each of the destination
tables. In the Employee Data Flow, an OLE DB Command transformation executes a stored procedure that
loads the Employee record and returns the EmployeeID value.
You need to accomplish the following tasks:
-Ensure that the EmployeeID is used as a foreign key (FK) in all child tables for the correct Employee
record.
-Minimize the number of round trips to the database.
-Ensure that the package performs in the most efficient manner possible.
What should you do?

• A.Store the EmployeeID values in SSIS variables and use the variables to populate the FK columns in each of the child tables.
• B.After the Employee table is loaded, write the data to a Raw File Destination and use the raw file as a source for each of the subsequent Data Flows.
• C.After the Employee table is loaded, write the data to a Flat File Destination and use the flat file as a source for each of the subsequent Data Flows.
• D.Use a Lookup Transformation in each of the child table data flows to find the EmployeeID based on first name and last name.