070-767 무료 덤프문제 온라인 액세스

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 using SQL 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.

정답:

You are designing a warehouse named DW1.
A table named Table1 is partitioned by using the following partitioning scheme and function.

Reports are generated from the data in Table1.
You need to ensure that queries to DW1 return results as quickly as possible.
Which column should appear in the WHERE statement clause of the query?

• A.DueDate
• B.AccountNumber
• C.MyId
• D.OrderDate

You have a data quality project that focuses on the Products catalog for the company. The data includes a product reference number.
The product reference should use the following format: Two letters followed by an asterisk and then four or five numbers. An example of a valid number is XX*55522. Any reference number that does not conform to the format must be rejected during the data cleansing.
You need to add a Data Quality Services (DQS) domain rule in the Products domain.
Which rule should you use?

• A.value matches regular expression AZ[*]1234[5]
• B.value matches pattern [a-zA-Z][a-zA-Z]*[0-9][0-9] [0-9][0-9] [0-9]?
• C.value matches pattern ZA*9876[5]
• D.value matches pattern AZ[*]1234[5]

You manage a Data Quality Services (DQS) knowledge base.
You need to ensure that DQS will create a synonym relationship between identical tags.
What should you create?

• A.new knowledge base
• B.term-based relations
• C.new domain
• D.linked domain

You have a Microsoft SQL Server Integration Services (SSIS) package that contains a Data Flow task as shown in the Data Flow exhibit. (Click the Exhibit button.)

You install Data Quality Services (DQS) on the same server that hosts SSIS and deploy a knowledge base to manage customer email addresses. You add a DQS Cleansing transform to the Data Flow as shown in the Cleansing exhibit. (Click the Exhibit button.)

You create a Conditional Split transform as shown in the Splitter exhibit. (Click the Exhibit button.)

You need to split the output of the DQS Cleansing task to obtain only Correct values from the EmailAddress column.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.

정답:

Explanation

The DQS Cleansing component takes input records, sends them to a DQS server, and gets them back corrected. The component can output not only the corrected data, but also additional columns that may be useful for you. For example - the status columns. There is one status column for each mapped field, and another one that aggregated the status for the whole record. This record status column can be very useful in some scenarios, especially when records are further processed in different ways depending on their status. Is such cases, it is recommended to use a Conditional Split component below the DQS Cleansing component, and configure it to split the records to groups based on the record status (or based on other columns such as specific field status).
References: https://blogs.msdn.microsoft.com/dqs/2011/07/18/using-the-ssis-dqs-cleansing-component/