Exam 70-767 topic 1 question 100 discussion

Actual exam question from Microsoft's 70-767

Question #: 100
Topic #: 1

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 developing a Microsoft SQL Server Integration Services (SSIS) package.
You need to ensure that the package records the current Log Sequence Number (LSN) in the source database before the package begins reading source tables.
Which SSIS Toolbox item should you use?

A. CDC Control task
B. CDC Splitter
C. Union All
D. XML task
E. Fuzzy Grouping
F. Merge
G. Merge Join

Show Suggested Answer

Suggested Answer: A 🗳️
The CDC Control task is used to control the life cycle of change data capture (CDC) packages. It handles CDC package synchronization with the initial load package, the management of Log Sequence Number (LSN) ranges that are processed in a run of a CDC package.
References:
https://docs.microsoft.com/en-us/sql/integration-services/control-flow/cdc-control-task

by [deleted] at April 4, 2025, 4:43 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!