exam questions

Exam 70-767 All Questions

View all questions & answers for the 70-767 exam

Exam 70-767 topic 1 question 30 discussion

Actual exam question from Microsoft's 70-767
Question #: 30
Topic #: 1
[All 70-767 Questions]

You have a Microsoft SQL Server Integration Services (SSIS) package that includes the control flow shown in the following diagram.


You need to choose the enumerator for the Foreach Loop container.
Which enumerator should you use?

  • A. Foreach SMO Enumerator
  • B. Foreach ADO.Net Schema Rowset Enumerator
  • C. Foreach NodeList Enumerator
  • D. Foreach ADO Enumerator
  • E. Foreach HDS File Enumerator
  • F. Foreach File Enumerator
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
Use the Foreach ADO enumerator to enumerate rows in tables. For example, you can get the rows in an ADO recordset.
References:
https://docs.microsoft.com/en-us/sql/integration-services/control-flow/foreach-loop-container?view=sql-server-2017

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Lukis92
4 years, 5 months ago
Can someone explain how ADO enumerator relates to web service task?
upvoted 1 times
Hoglet
4 years, 4 months ago
Actually the important bit is the "Get Table" task before it. It's being called to generate the list (of web services) to be looped over. Having populated that list, as a "recordset", you will then use the ADO enumerator to work through it None of the others make sense. The SMO and ADO.Net Schema are great for getting a list of database objects you want to enumerate over. If you then want to perform the same admin task on them. No way this would map to a web service The File and HDFS File are great if you want to enumerate over a list of files, and say import that data. No way this would map to a web service
upvoted 2 times
...
kimalto452
4 years, 5 months ago
its not important, the important thing is that there sey ROW by ROW in the name of containter, ado enumeratos is using for row by row processing
upvoted 4 times
Lukis92
4 years, 5 months ago
Thank you for your explanation. Now I see the point.
upvoted 2 times
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago