单项选择题
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? ()
单项选择题 YoudesignaBusinessIntelligence(BI)solutionbyusingSQLServer2008.ThesolutionincludesaSQLServer2008ReportingServices(SSRS)infrastructureinascale-outdeployment.AllreportsuseaSQLServer2008relationaldatabaseasthedatasource.Youimplementrow-levelsecurity.Youneedtoensurethatallreportsdisplayonlytheexpecteddatabasedontheuserwhoisviewingthereport.Whatshouldyoudo?()
单项选择题 You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services (SSAS) database. The database contains a cube named Financials. The cube contains objects as shown in the exhibit. (Click the Exhibit button.) A calculated member named Gross Margin references both Sales Details and Product Costs. You need to ensure that the solution meets the following requirements: Managers must be able to view only their cost centers percentage of the companys gross margin. The impact on query performance is minimal. What should you do?()