70-446 - PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005

Go back to Microsoft

Example Questions

You need to ensure the marketing department is able to implement cross-selling requirements. Which data mining model should you choose? You need to maintain the partitions on the ProductOrderStatus measure group. What should you do? You need to resolve the blocking issue that is affecting the performance of the CRM system. What should you do? You need to modify the PartnerAirmilesLoad SSIS package to avoid duplicate customers in the BlueCRM system. Which SSIS transformation task should you use? You need to resolve the double counting of transactions issue in the existing reports. What should you do? You need to create the PromotionResponse mining model for the promotions department. What should you do first? You need to include the attributes of the Region dimension within the SSRS report. What should you do? You need to modify the cube to support the Shipping Work by Location report. What should you do? You need to train the marketing teams clustering model. What should you do? You need to ensure the Order Control team is able to track the number of orders that reach the production department. What should you do? You need to modify the CorporateCustomer dimension table to support the logical design. What should you do? You need to redesign the data flow for the ImportWineOrder SSIS package to meet the ETL requirements. Which transformation task should you use? You need to redesign the TicketSalesByFlight report. Which component should you use? You need to calculate the average quantity of products sold by each store. What should you do? You need to meet the processing requirements of the ContosoSSAS solution. What should you do? You need to help the HR team improve the resource allocation process. What should you do? You need to modify the BlueDWLoad SSIS package to ensure that TicketSale records can be loaded when the Customer data is not yet available. What should you do? You need to minimize the amount of space required for the SSAS cube. You must achieve this goal while maximizing the performance of business user queries. What should you do? You need to generate the Schedule.xls file from the BlueDW database. What should you do? You need to reduce the number of inserts into the Customer dimension table in the BlueDW database. You also need to meet the reporting requirements. What should you do? You need to redesign the TransformPriceBand data flow to record data lineage. What should you do? You need to ship a copy of the FabrikamASDB metadata to Contoso, Ltd. What should you do? You are configuring the UploadSupportScreenShot package. You need to load the bitmap (BMP) files into a data flow. Which transformation task should you use? You need to meet the fraud detection requirements. What should you do? You need to modify the Customer dimension table to support the design and reporting constraints. What should you do? You need to modify the Executive Dashboard suite reports to allow testing to occur per the requirements. What should you do? You need to ensure the Point-Of-Sales system supports cross-selling functionality. What should you do? You need to select the appropriate edition of SQL Server 2005 for the portable computers that are used in the Mortgage Data Cleansing project. Which edition should you use? You need to implement the security requirements of the SupplierData report. What should you do? You need to alter the StaffMember dimension and measure group relationship to resolve the processing errors. You also need to meet the requirements for handling NULL values in the StaffMember dimension. What should you do? You need to select appropriate processing methods for the EmployeeAssignment measure group and the Employee dimension. Which method should you choose? You need to ensure that the TownStore hierarchical structure is displayed accurately in reports. How should you modify the Store dimension? You need to modify the CustomerBalance measure group to meet the reporting requirements. What should you do? You need to modify the SalesExtract SSIS package to meet all business and technical requirements. Which transaction isolation level should you use? You need to ensure that the ContosoSSAS measure groups remain available after the ReloadWine SSIS package is executed. What should you do? You install the Reporting Services component on the CustomerServer server. You need to identify the additional SQL Server component that must be installed to ensure SSRS functions correctly. Which SQL Server component should you install? You need to modify the SecurityAgencyLoad SSIS package to meet the audit trail requirements. What should you do? You need to ensure the Client dimension is able to support new orders and new client records. Which setting should you configure? You need to design a storage mode for the ProductOrderStatus measure group. What should you do? You need to ensure that all blank rows in the PivotTable reports are hidden. Which property of the Product dimension should you set? You need to meet the requirements of the accounts team. What should you do? You need to reduce the duration of the daily full database backup process. What should you do? You need to identify the data mining algorithm that meets the requirements of the credit department. Which algorithm should you use? You need to ensure that the new sales manager is able to view clients within only the North and South regions. You need to create the TransferPurchaseOrders SSIS package per the ETL requirements. Which data flow destination configuration should you use? You need to record package and task outcome in the ETLAudit table. Which components of SSIS should you use? You need to create a data mining model to support the SalesProjections report. How should you modify the SSAS solution? You need to configure event handling within the TransferResellerSales SSIS package. What should you do? You need to ensure that the new sales manager is able to view clients within only the North and South regions. What should you do? You need to redesign the LoadResellerSales package to meet the ETL requirements. What should you do?