70-463MicrosoftImplementing a Data Warehouse with Microsoft SQL Server 2012/2014
QUESTION: 57 You are designing a SQL Server Integration Services (SSIS) 2012 package that imports data from a Windows Azure SQL Database database into a SQL Server database. The SSIS package has the following requirements: Every night, a very large amount of data is imported into the staging database. Package processing time must be minimized. The package must run on its own dedicated server when it is deployed to production. Transaction log activity when data is imported must be minimized. You need to design the package to meet the requirements. Which destination component should you use? B QUESTION: 58 You are administering SQL Server Integration Services (SSIS) permissions on a production server that runs SQL Server 2012. Quality Assurance (QA) testers in the company must have permission to perform the following tasks on specific projects: View and validate projects and packages View Environments and Environment variables Execute packages You need to grant the minimum possible privileges to the QA testers. What should you do? (Each correct answer presents part of the solution. Choose all that apply.) QUESTION: 59 You are designing a data warehouse that uses SQL Server 2012. The data warehouse contains a table named factSales that stores product sales. The table has a clustered 49
index on the primary key, four foreign keys to dimension tables, and an aggregate column for sales totals. All key columns use the int data type and the aggregate column uses the money data type. You need to increase the speed of data retrieval from the factSales table. Which index type should you add to the table? C QUESTION: 60 DRAG DROP You are building a fact table in a data warehouse. The table must have a columnstore index. The table cannot be partitioned. You need to design the fact table and load it with data. Which three actions should you perform in sequence?