9.You need to implement the Sales Commission model to support theplanned reports and queries.What should you do? A. Create a date table that contains only one row for each date onwhich a sale is recorded.B. Use the existing transaction date column in the sales table for datecalculations. page 8 / 21
C. Create a date table that contains a row for every date since datastarted being recorded.D. Create a new calculated date column in the sales table for datecalculations.Answer: C 10.HOTSPOT A company maintains separate environments for development, test,and production. The company uses the project deployment model forSQL Server Integration Services (SSIS) deployments. You create anSSIS project to perform a daily refresh of the data warehouse and datamodels. The project has five packages. You need to configure theproject to ensure that the development, test, and production teams canrun each package without manually adding server-specific information.Which program should you use? To answer, select the appropriateprogram in the answer area. page 9 / 21
Answer: 11.You execute the SalesbyCategory report and receive the followingerror message: "Members, tuples, or sets must use the samehierarchies in the function."You need to ensure that the query executes successfully.Which two actions should you perform? Each correct answer presentspart of the solution. 12.You need to select the appropriate mode for the Sales database. Which mode should you select? page 10 / 21
13.A company runs SQL Server Database Engine and SQL ServerReporting Services (SSRS) in native mode. Reports are based on datathat is cached in multiple shared datasets. Source data is archivedeach day at midnight for regulatory compliance purposes. The shareddatasets may continue to cache data that should not be used inreports. Shared report schedules are often paused during nightlyserver maintenance windows. Reports must not return archived data.You need to create a fully automated solution to ensure that reports donot deliver archived data.What should you do? (More than one answer choice may achieve thegoal. Select the BEST answer.)
You've reached the end of your free preview.
Want to read all 21 pages?
- Winter '20
- Microsoft SQL Server, best answer, SQL Server Reporting, answer area, Server Reporting Services