Try Microsoft : 070-767 practice torrent pass for sure

You have a database that contains a table named Email. Change Data Capture (CDC) is enabled for the table.
You have a Microsoft SQL Server Integration Services (SSIS) package that contains the Data Flow task shown in the Data Flow exhibit. (Click the Exhibit button.)

You have an existing CDC source as shown in the CDC Source exhibit (Click the Exhibit button)


and a CDC Splitter transform as shown in the CDC Splitter exhibit. (Click the Exhibit button.)


You need to perform an incremental import of customer email addresses. Before importing email addresses, you must move all previous email addresses to another table for later use.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

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.
You remove the Integration Services job.
You need to stop tracking changes to the database. The solution must remove all the change data capture configurations from DB1.
Which stored procedure should you execute?

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

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 are loading data from an OLTP database to a data warehouse. The database contains a table named Sales.
Sales contains details of records that have a type of refund and records that have a type of sales.
The data warehouse design contains a table for sales data and a table for refund data.
Which component should you use to load the data to the warehouse?

• A. an Execute SQL task
• B. the Slowly Changing Dimension transformation
• C. the Lookup transformation
• D. the Data Conversion transformation
• E. the Aggregate transformation
• F. the Merge transformation
• G. the Conditional Split transformation

You 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 reads the file name for the current file into a variable and uses that value to write a log entry to a database table.
You need to debug the package and determine the value of the variable before each file is processed.
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.

Note: This question is part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenarios is exactly the same in each question in this series.
You are developing a Master Data Management (MDM) solution for a company by using Microsoft SQL Server Integration Services (SSIS), SQL Server Master Data Services (MDS), and SQL Server Data Quality Services (DQS).
You have an MDS model named Geography that contains the entities described in the following table.

You define a domain-based attribute in the State entity that references the CountryRegion entity. You define another domain-based attribute in the city entity that references the State and CountryRegion entities. A single derived hierarchy named Geography supports navigation between the CountryRegion, State, and City levels.
Subscription views exist for all entities. The subscription views have the same name as the entity on which they are based.
You initialize each entity member. New City entity members are imported daily based on customer city values in a Customer Relationship Management (CRM) database. The CRM database is a SQL Server relational database. When new cities are imported from the CRM database, the state codes must be standardized to those already defined in the State entity.
In the CRM database, sales managers and assigned to countries/regions. A sales manager may be assigned to one or more countries/regions. A country/region may have one or more assigned sales managers. The CRM database contains a table named ManagerCountryRegion that stores a row for each manager-country/region relationship.
You create the following MDS users and map each user to an Active Directory Domain Services (AD DS) user account: User1, User2, and User3. Both User1 and User2 belong to the Explorer functional area.
Users must be able to complete the tasks described in the following table.

You need to perform the initial data loading process of the DQS knowledge base, based on the CountryRegion Entity in the MDS model.
Which three 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.