Microsoft 70-463 Exam Practice Questions (P. 3)
- Full Access (218 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #11
The data warehouse contains two fact tables:
✑ factSales, used to record daily sales by software title
✑ factTarget, used to record the monthly sales targets by software category
Reports must be developed against the warehouse that reports sales by software title, category and subcategory, and sales targets.
You need to design the software title dimension. The solution should use as few tables as possible while supporting all the requirements.
What should you do?
- ACreate three software tables, dimSoftware, dimSoftwareCategory, and dimSoftwareSubcategory and a fourth bridge table that joins software titles to their appropriate category and subcategory table records with foreign key constraints. Direct the cube developer to use key granularity attributes.
- BCreate three software tables, dimSoftware, dimSoftwareCategory, and dimSoftwareSubcategory. Connect factSales to all three tables and connect factTarget to dimSoftwareCategory with foreign key constraints. Direct the cube developer to use key granularity attributes.
- CCreate one table, dimSoftware, which contains Software Detail, Category, and Subcategory columns. Connect factSales to dimSoftware with a foreign key constraint. Direct the cube developer to use a non-key granularity attribute for factTarget.
- DCreate two tables, dimSoftware and dimSoftwareCategory. Connect factSales to dimSoftware and factTarget to dimSoftwareCategory with foreign key
C

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #12
The system is accessed by users from certain districts, as well as by area supervisors and users from the corporate headquarters.
You need to design a table structure to ensure that certain users can see sales data for only certain districts. Some users must be permitted to see sales data from multiple districts.
What should you do?
- AAdd a district column to the dimUser table.
- BPartition the factSales table on the district column.
- CCreate a userDistrict table that contains primary key columns from the dimUser and dimDistrict tables.
- DFor each district, create a view of the factSales table that includes a WHERE clause for the district.
C

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #13
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?
- AAdd StartDate and EndDate columns to the customer dimension.
- BAdd an IsCurrent column to the customer dimension.
- CEnable Snapshot Isolation on the data warehouse.
- DAdd CurrentValue and PreviousValue columns to the customer dimension.
A
Adding a start and end date will give you this ability as when a record is inserted and given a start and end date, youll have the ability to determine when they were active therefore giving you a retention of historical changes

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #14
✑ [ID]
✑ [QuoteDate]
✑ [Open]
✑ [Close]
✑ [High]
✑ [Low]
✑ [Volume]
Each of the following queries must be able to use a columnstore index:
✑ SELECT AVG ([Close]) AS [AverageClose] FROMQuotes WHERE [QuoteDate] BETWEEN '20100101' AND '20101231'.
✑ SELECT AVG([High] - [Low]) AS [AverageRange] FROM Quotes WHERE [QuoteDate] BETWEEN '20100101' AND '20101231'.
SELECT SUM([Volume]) AS [SumVolume] FROM Quotes WHERE [QuoteDate] BETWEEN '20100101' AND '20101231'.

You need to ensure that the indexing strategy meets the requirements. The strategy must also minimize the number and size of the indexes.
What should you do?
- ACreate one columnstore index that contains [ID], [Close], [High], [Low], [Volume], and [QuoteDate].
- BCreate three coiumnstore indexes:One containing [QuoteDate] and [Close]One containing [QuoteDate], [High], and [Low]One containing [QuoteDate] and [Volume]
- CCreate one columnstore index that contains [QuoteDate], [Close], [High], [Low], and [Volume].
- DCreate two columnstore indexes:One containing [ID], [QuoteDate], [Volume], and [Close]One containing [ID], [QuoteDate], [High], and [Low]
C
References: http://msdn.microsoft.com/en-us/library/gg492088.aspx http://msdn.microsoft.com/en-us/library/gg492153.aspx

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #15
Most of the dimensions have the same structure and content. However, the geography dimension is slightly different in each data mart.
You need to design a consolidated dimensional structure that will be easy to maintain while ensuring that all dimensional data from the three original solutions is represented.
What should you do?
- ACreate a junk dimension for the geography dimension.
- BImplement change data capture.
- CCreate a conformed dimension for the geography dimension.
- DCreate three geography dimensions.
C

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
All Pages