单项选择题

You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to design the report strategy for a new report project that will be used by a financial application. The application uses five calculations that are implemented in Microsoft .NET Framework 3.5 assemblies. The assemblies are written in the C# language and use the static methods. You need to ensure that the calculations can be used by the expressions in all reports. You also need to ensure consistency within the reports by using the least amount of development effort. What should you do？（）

A. Add a reference to the assemblies in the Report Properties References tab.
B. Write the calculation logic used by the calculations by using T-SQL functions.
C. Write the code of the calculation logic into the Report Properties Custom Code tab.
D. Write the calculation logic in each report by using the mathematical functions available natively to SQL Server 2008 Reporting Services （SSRS）.

点击查看答案&解析

上一题目录下一题

相关考题

单项选择题

You design a Business Intelligence （BI） solution by using SQL Server 2008. A SQL Server 2008 Analysis Services （SSAS） solution contains a cube that has the following objects： ·Dimensions named DimCustomer，DimProduct，and DimGeography ·Measures named InternetSales and TotalSales Users run reports against all dimensions and measures by authenticating with their Windows accounts. You need to provide a basic view of data to the users to display only DimGeography， DimProduct，and TotalSales by using the least amount of storage space. What should you do？（）

A. Create a new perspective for the current cube. Select DimGeography， DimProduct， and TotalSales.
B. Create a new cube. Add DimGeography， DimProduct， and TotalSales.
C. Create a new role. Grant access only to DimGeography， DimProduct， and TotalSales.
D. Create a new data source view. Add the tables used for DimGeography， DimProduct， and TotalSales.

单项选择题

You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Integration Services （SSIS） package to perform an extract， transform， and load （ETL） process to load data to a DimCustomer dimension table that contains 1 million rows. Your data flow uses the following components： A SQL Destination data flow task to insert new customers An OLE DB Command transform that updates existing customers On average， 25 percent of existing customer records is updated each night. You need to reduce the amount of time required to update customer records. What should you do？（）

A. Modify the UPDATE statement in the OLE DB Command transform to use the PAGLOCK table hint.
B. Modify the UPDATE statement in the OLE DB Command transform to use the TABLOCK table hint.
C. Stage the data in the data flow. Replace the OLE DB Command transform in the data flow with an Execute SQL task in the control flow.
D. Stage the data in the data flow. Replace the UPDATE statement in the OLE DB Command transform with a DELETE statement followed by an INSERT statement.

单项选择题

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. The safer ，easier way to help you pass any IT exams.
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. Store the EmployeeID values in SSIS variables and use the variables to populate the FK columns in each of the child tables.
C. 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.
D. 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.