Implementing-a-SQL-Data-Warehouse-(70-767).pdf - Microsoft...

This preview shows page 1 - 4 out of 10 pages.

70-767MicrosoftImplementing a SQL Data Warehouse
QUESTION:227You plan to deploy a package to a server that has SQL Server installed. The servercontains a SQL Server Integration Services Catalog. You need to ensure that thepackage credentials are encrypted. Which protection level should you set for thepackage?D
QUESTION:228DRAG DROPYou are maintaining a SQL Server Integration Services (SSIS) package. The packageuses custom functionality that is implemented in Microsoft Visual C#.The implementation of the custom functionality changes overtime. The design of thepackage allows you to deploy new releases of the custom functionality withoutredeploying the entire package. You need to implement and deploy an update to thecustom functionality without requiring package redeployment. Which three actionsshould you perform in sequence? (To answer, move the appropriate actions from the listof actions to the answer area and arrange them in the correct order.)
Answer:ExhibitQUESTION:229You are designing a data warehouse with two fact tables. The first table contains salesper month and the second table contains orders per day. Referential integrity must beenforced declaratively. You need to design a solution that can join a single timedimension to both fact tables. What should you do?A. Join the two fact tables.B. Merge the fact tables.C. Change the level of granularity in both fact tables to be the same.D. Partition the fact tables by day.Answer:

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 10 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
N/A
Tags
Data Management, Database management system, Microsoft SQL Server, SQL Server Integration Services

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture