Online Access Free 70-463 Practice Test

You are reviewing the design of a customer dimension table in an existing data warehouse hosted on SQL Azure.
The current dimension design does not allow the retention of historical changes to customer attributes such as Postcode.
You need to redesign the dimension to enable the full historical reporting of changes to multiple customer attributes including Postcode.
What should you do?

• A.Add StartDate and EndDate columns to the customer dimension.
• B.Add CurrentValue and PreviousValue columns to the customer dimension.
• C.Add an IsCurrent column to the customer dimension.
• D.Enable Snapshot Isolation on the data warehouse.

You are creating a SQL Server Integration Services (SSIS) package that implements a Type 3 Slowly Changing Dimension (SCD).
You need to add a task or component to the package that allows you to implement the SCD logic.
What should you use?

• A.a Merge component
• B.an Expression task
• C.a Data Conversion component
• D.an Execute SQL task that executes a MERGE statement on the database

You are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day.
Referential integrity must be enforced declaratively.
You need to design a solution that can join a single time dimension to both fact tables.
What should you do?

• A.Partition the fact tables by day.
• B.Create a surrogate key for the time dimension.
• C.Create a view on the sales table.
• D.Change the level of granularity in both fact tables to be the same.

You are designing a data warehouse that contains a customer dimension.
The customer dimension contains the original customer attributes as well as the most recent set of updated attributes. When a customer is updated, the original customer attributes must be preserved.
The customer dimension design must:
Support a Type 3 Slowly Changing Dimension (SCD) process
Minimize the total storage consumed
You need to design a solution that meets these requirements.
What should you do?

• A.Design a table to hold the surrogate key for each customer and its attributes. Add a column to store an indicator that identifies the record as original data or recent data.
• B.Design a table as a Type 2 SCD dimension that holds the surrogate key for each customer and its attributes. Limit the number of records per customer within the table to two.
• C.Design a table to hold the surrogate key for each customer and its attributes as well as additional columns to store the original attributes.
• D.Design two tables. One table will hold the original customer surrogate key and attributes. The other table will hold the most recent customer surrogate key and attributes.

You are the Master Data Services (MDS) administrator at your company.
An existing user must be denied access to a certain hierarchy node for an existing model.
You need to configure the user's permissions.
Which user management menu item should you select? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

Correct Answer:

Explanation