70-463 Real Exam Questions

You are reviewing the design of an existing fact table named factSales, which is loaded from a SQL Azure database by a SQL Server Integration Services (SSIS) package each day. The fact table has approximately 1 billion rows and is dimensioned by product, sales date, and sales time of day. The database administrator is concerned about the growth of the database. Users report poor reporting performance against this database. Reporting requirements have recently changed and the only remaining report that uses this fact table reports sales by product name, sale month, and sale year. No other reports will be created against this table. You need to reduce the report processing time and minimize the growth of the database. What should you do?

You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables. You have the following requirements: - Ensure that the deployment model supports changing the content of connection strings by using parameters at execution time. - Ensure that the deployment model automatically starts from calls to the catalog.start_execution stored procedure in the SSISDB database. - Maximize performance at execution time. - Minimize development effort. You need to design a solution that meets the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are designing a complex SQL Server Integration Services (SSIS) project that uses the Project Deployment model. The project will contain between 15 and 20 packages. All the packages must connect to the same data source and destination. You need to define and reuse the connection managers in all the packages by using the least development effort. What should you do?

You are the administrator for a Master Data Services (MDS) environment. A user who is not an administrator must be able to access Master Data Manager. You need to assign permissions to the user. Which function should you use?

You are preparing to install SQL Server 2012 Master Data Services (MDS). You need to ensure that the database requirements are met. What should you install?