Microsoft MCTS 70-463

Microsoft MCTS 70-463

Access Routing and LAN Switching;Advanced Routing and Switching;APE;APE for Validating Knowledge;Architecture;
CCDA;CCDE; CCDP;CCENT;CCIE;CCIE Data Center;CCIP; CCNA;
CCNA Security;CCNA Wireless;CCNA Voice;CCNP;CCNP Data Center
;CCNP Service Provider; CCNP Wireless;CCNP Security;CCNP SP Operations; CCNP Voice;CCSP;CCVP;Cisco Express Foundation Field Specialist;Cisco Security Sales Specialist;Cisco Specialist;Cisco Virtual Classroom;Connected Grid;Content Networking;Data-Center;Field Technician;IP Communications;IronPort; Network Management; Optical;Others
;Proctored Exams for Validating Knowledge;Sales Expert; Security Specialist;Service Provider Video;SMB;SP Video
;Storage Networking; Substation Automation;TelePresence Video
;Unified Communications;VPN and Security; WAASSE; Wireless LAN

70-463 Implementing a Data Warehouse with SQL Server 2012 Der einfachste Weg für die IT-Prüfung vorzubereiten, ist die Praxis-Tests auf Zertifizierungsprüfung Muster zu nehmen und zu verstehen, die richtige sowie falsche Antwort Erklärungen Deine Zweifel klären. Lesen Sie dazu auch relevante technische Artikel zu versierter in der damit verbundenen Technologie.

Microsoft MCTS 70-463

QUESTION: 1
You are designing a data warehouse for a fresh food distribution business that stores sates by individual product. It stores sales targets by product category. Products are classified into subcategories and categories. Each product is included in only a single product subcategory, and each subcategory is included in only a single category. The data
warehouse will be a data source for an Analysis Services cube. The data warehouse
contains two fact tables:
- factSales, used to record daily sales by product
- factProductTarget, used to record the monthly sales targets by product category Reports
must be developed against the warehouse that reports product sales by product, category
and subcategory, and product sales targets. You need to design the product dimension.
The solution should use as few tables as possible while supporting all the requirements.
What should you do?

A. Create two product tables, dimProduct and dimProductCategory. Connect
factSales to dimProduct and factProductTarget to dimProductCategory with foreign key
constraints. Direct the cube developer to use key granularity attributes.
B. Create one product table, dimProduct, which contains product detail, category, and
subcategory columns. Connect factSales to dimProduct with a foreign key constraint.
Direct the cube developer to use a non-key granularity attribute for factProductTarget.
C. Create three product tables, dimProduct, dimProductCategory, and dimProductSubcategory, and a fourth bridge table that joins products to their appropriate
category and subcategory table records with foreign key constraints. Direct the cube
developer to use key granularity attributes.
D. Create three product tables, dimProduct, dimProductCategory, and
dimProductSubcategory. Connect factSales to all three product tables and connect
factProductTarget to dimProductCategory with foreign key constraints. Direct the cube developer to use key granularity attributes.

Answer: B

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

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

Answer: C

Microsoft MCTS 70-463