ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-767 All Questions

View all questions & answers for the 70-767 exam
Go to Exam

Exam 70-767 topic 1 question 34 discussion

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

HOTSPOT -
You 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 following Transact-SQL segment:


You need to create a DML statements that updates the LastKeyByTable table.
How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segments in the dialog box in the answer area.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
by CGLUE at May 8, 2020, 8:28 a.m.

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
Submit Cancel
kimalto452
4 years, 5 months ago
its "?" TESTED
upvoted 3 times
...
kimalto452
4 years, 6 months ago
DML statements use "?" or "@" i don't think so... the answer is correct.
upvoted 1 times
kimalto452
4 years, 6 months ago
dml statenment use "@" *
upvoted 1 times
...
...
othman_ee
4 years, 9 months ago
If you're using the OLE DB source you have to specify ? else you get an error. If you're using the ADO.NET source you can use the "@LastKey" and map this. (i tried this on a SSIS package) I don't really get from the question what they're using to perform the update, it specifies only what source is used to fetch the data.
upvoted 2 times
othman_ee
4 years, 9 months ago
Personally i would go for the "?", because the question refers only to OLE DB and since that is the default source connection type in a SSIS Sql Task. They did not specify otherwise.
upvoted 2 times
...
...
ialberto
4 years, 10 months ago
Because of DML statements...the answer is correct.
upvoted 2 times
eceb
4 years, 9 months ago
why? can you be more specific? To use variables within a query in a ssis package you use "?" and then you map the parameters to the variables. If inside data flow task, you need to use OLEDB Command, and if outside you need to use execute sql task, but with "?"
upvoted 2 times
...
othman_ee
4 years, 9 months ago
All update statements are DML statements, but if it's used within ssis it depends on the source that is used to connect to the db (OLEDB or ADO.NET).
upvoted 2 times
...
...
Godize
4 years, 12 months ago
I think for DML (outside data warehouse Control Flow and Data Tasks) the variables are specified by "@", while OLE DB source is "?"
upvoted 4 times
eceb
4 years, 9 months ago
I agree. Within a package you should use "?" and the map parameters-variables
upvoted 1 times
...
...
CGLUE
5 years ago
Do the variables in OLEDB sources not have to be specified with "?" ? https://docs.microsoft.com/en-us/sql/integration-services/data-flow/ole-db-source?view=sql-server-ver15
upvoted 3 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago