Câu 13: 70-767: Implementing a SQL Data Warehouse

HOTSPOT -You manage the data warehouse for a large retail company. The company has many store locations. Each location runs their own independent sales systems. They report daily sales and receipt information to a central system every night. You plan to load data from all locations into a fact table named fact. Sales by usingSQL Server Integration Services (SSIS) packages. You create the following Transact-SQL statement: You need to select the columns for the primary key and clustered column key. The keys must meet the following requirements: ✑ Prevent duplicate rows from being entered by a single system. ✑ Allow for point lookups of a single sale. ✑ Minimize storage requirements for nonclustered indexes. ✑ Store rows in the order that they are inserted into the table. How should you configure the keys? To answer, select the appropriate column type in the answer area. Hot Area:

1. A. SalesID : primary key column SystemID : clustered key column ReceiptID : clustered key column StoredID : primary key column — đáp án hiện tại