Category «70-767»

Exam 70-767: Implementing a SQL Data Warehouse (update January 17th, 2018)

Which four actions should you perform in sequence?

DRAG DROPYou 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 IntegrationServices (SSIS) package loads the data …

How should you configure the knowledge base?

HOTSPOTYou 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 IntegrationServices (SSIS) package loads the data into …

Which rule should you use?

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 …

How should you complete the Transact-SQL statement?

DRAG DROPYou deploy a Microsoft Server database that contains a staging table named EmailAddress_Import. Each night, a bulk process will import customer information from an external database, cleanse the data, and then insert it into the EmailAddress table. Both tables contain a column named EmailAddressValue that stores the email address.You need to implement the logic …

Which three actions should you perform in sequence?

DRAG DROPYou administer a Microsoft SQL Server Master Data Services (MDS) model. All model entity members have passed validation.The current model version should be committed to form a record of master data that can be audited and create a new version to allow the ongoing management of the master data.You lock the current version. You …

You need to split the output of the DQS Cleansing task to obtain only Correct values from the EmailAddress column.

HOTSPOTYou 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 …

How should you complete the Transact-SQL statement?

HOTSPOTYou have a database named DB1. You create a Microsoft SQL Server Integration Services (SSIS) package that incrementally imports data from a table named Customers. The package uses an OLE DB data source for connections to DB1. The package defines the following variables. To support incremental data loading, you create a table by running the …

You need to be able to interrogate the value of the Seed variable after the Script task completes execution.

HOTSPOTYou are testing a Microsoft SQL Server Integration Services (SSIS) package. The package includes the ControlFlow task shown in the Control Flow exhibit (Click the Exhibit button) and the Data Flow task shown in the DataFlow exhibit. (Click the Exhibit button.) You declare a variable named Seed as shown in the Variables exhibit. (Click the …

You need to debug the package and determine the value of the variable before each file is processed.

DRAG DROPYou have a Microsoft SQL Server Integration Services (SSIS) package that loads data into a data warehouse each night from a transactional system. The package also loads data from a set of Comma-Separated Values(CSV) files that are provided by your company’s finance department.The SSIS package processes each CSV file in a folder. The package …

You need to resolve the error with the package

HOTSPOTYou create a Microsoft SQL Server Integration Services (SSIS) package as shown in the SSIS Package exhibit.(Click the Exhibit button.) The package uses data from the Products table and the Prices table. Properties of the Prices source are shown in the OLE DB Source Editor exhibit (Click the Exhibit Button.) and the Advanced Editor for …