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

You need to build a knowledge base in Data Quality Services (DQS).
You need to ensure that the data is validated by using a third-party data source before DQS processes the data.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

정답:

Explanation

Building a DQS knowledge base involves the following processes and components:
Step 1: Perform Knowledge Discovery
A computer-assisted process that builds knowledge into a knowledge base by processing a data sample Step 2: Perform Domain Management An interactive process that enables the data steward to verify and modify the knowledge that is in knowledge base domains, each of which is associated with a data field. This can include setting field-wide properties, creating rules, changing specific values, using reference data services, or setting up term-based or cross-field relationships.
Step 3: Configure reference Data Services
A process of domain management that enables you to validate your data against data maintained and guaranteed by a reference data provider.
Step 4: Configure a Matching Policy
A policy that defines how DQS processes records to identify potential duplicates and non-matches, built into the knowledge base in a computer-assisted and interactive process.
References: https://docs.microsoft.com/en-us/sql/data-quality-services/dqs-knowledge-bases-and-domains

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a database named DB1 that has change data capture enabled.
A Microsoft SQL Server Integration Services (SSIS) job runs once weekly. The job loads changes from DB1 to a data warehouse by querying the change data capture tables.
Users report that an application that uses DB1 is suddenly unresponsive.
You discover that the Integration Services job causes severe blocking issues in the application. You need to ensure that the users can run the application as quickly as possible. Your SQL Server login is a member of only the ssis.admin database role.
Which stored procedure should you execute?

• A.catalog.stop.operation
• B.catalog.restore_project
• C.sys.sp_cdc.stopJob
• D.sys.sp.cdc.changejob
• E.sys.sp_cdc_enable_db
• F.sys.sp.cdc.addjob
• G.catalog.deploy_project
• H.sys.sp_cdc_disable_db

You have a data warehouse named DW1. All data files are located on drive E.
You expect queries that pivot hundreds of millions of rows for each report.
You need to modify the data files to minimize latency.
What should you do?

• A.Remove data files from tempdb
• B.Remove data files from DW1.
• C.Add more data files to DW1 on drive E.
• D.Add more data files to tempdb on drive E.

You are a data warehouse developer.
You need to create a Microsoft SQL Server Integration Services (SSIS) catalog on a production SQL Server instance.
Which features are needed? To answer, select the appropriate options in the answer area.

정답:

Explanation

Box 1: Yes
"Enable CLR Integration" must be selected because the catalog uses CLR stored procedures.
Box 2: Yes
Once you have selected the "Enable CLR Integration" option, another checkbox will be enabled named
"Enable automatic execution of Integration Services stored procedure at SQL Server startup". Click on this check box to enable the catalog startup stored procedure to run each time the SSIS server instance is restarted.

Box 3: No
References:
https://www.mssqltips.com/sqlservertip/4097/understanding-the-sql-server-integration-services-catalog-and-crea

You have a series of analytic data models and reports that provide insights into the participation rates for sports at different schools. Users enter information about sports and participants into a client application. The application stores this transactional data in a Microsoft SQL Server database. A SQL Server Integration Services (SSIS) package loads the data into the models.
When users enter data, they do not consistently apply the correct names for the sports. The following table shows examples of the data entry issues.

You need to improve the quality of the data.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

정답:

Explanation

References: https://docs.microsoft.com/en-us/sql/data-quality-services/perform-knowledge-discovery