Online Access Free 70-452 Exam Questions

You are the administrator of your company network. And you??re in charge of a Microsoft SQL Server 2005 Reporting Services (SSRS) instance which has the following features: It is set as a single server and configured to use Native mode and a custom data extension is developed by using Microsoft .NET Framework 2.0You intend to upgrade the instance to SQL Server 2008 Reporting Services while ensure that there??s no loss of functionality.So what should you do?

• A.You should install a new instance of SSRS and move the existing configuration files and database to the new instance.
• B.You should edit the RSWebapplication.config file to refer to the upgraded SSRS endpoint location.
• C.You should upgrade the data extension to .NET Framework 3.5.
• D.You should uninstall Internet Information Services (IIS).

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. A SQL Server 2008 Reporting Services (SSRS) instance contains a report which will be delivered to multiple recipients. The report includes a subreport but doesn??t contain parameters. When the user clicks a report heading, the subreport is displayed. Potential recipients use the Web site to indicate their preferences to receive the report. Internal employees and external customers have access to the report. You intend to create a report subscription strategy for the report. You notice that the recipient list varies every week. So what should you do to make sure that all potential recipients receive the report?

• A.You should use the e-mail delivery method to create a data-driven subscription.
• B.You should use the e-mail delivery method to create a standard subscription.
• C.You should use the file share delivery method to create a data-driven subscription.
• D.You should use the file share delivery method to create a standard subscription.

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design a logging
strategy for all SQL Server 2008 Integration Services (SSIS) packages for your company. You want to log
errors that occur in all existing and future packages to a SQL Server 2008 table.
You need to design the strategy to meet the following requirements:
-The logging mechanism must be reused by each package.
-Changes to the logging mechanism must be applied to all packages by using the minimum amount of administrative effort.
What should you do?

• A.Create an event handler in a package. Configure the event handler to perform logging. Enable package configurations in the package. Store the properties of the event handler in an XML configuration file. Configure all the packages to use the configuration file during execution.
• B.Enable and configure logging in a package. Create all other packages by using the first package as the template.
• C.Create an event handler in a package. Configure the event handler to perform logging. Create all other packages by using the first package as the template.
• D.Enable and configure logging in a package. Save the log settings to an XML file. Enable logging in all other packages. Load the log settings on each package by using the XML file.

You administer a SQL Server 2008 Reporting Services (SSRS) environment. You restore the ReportServer and ReportServerTempDB databases to a new server. When you browse to the Report Manager Web page, you receive an error message. You are unable to view the folder structure and the reports. You need to view the folder structure and the reports. What should you do?

• A.Restore the msdb database.
• B.Configure the IIS virtual directory.
• C.Restore the symmetric key.
• D.Restore the master database.

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.Use a Lookup Transformation in each of the child table data flows to find the EmployeeID based on first name and last name.
• 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.Store the EmployeeID values in SSIS variables and use the variables to populate the FK columns in each of the child tables.