Exam 70-767 All Questions

View all questions & answers for the 70-767 exam

Exam 70-767 topic 1 question 34 discussion

Actual exam question from Microsoft's 70-767

Question #: 34
Topic #: 1

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

Suggested Answer:

by CGLUE at May 8, 2020, 8:28 a.m.

Comments

Submit Cancel

kimalto452

4 years, 8 months ago

its "?" TESTED

upvoted 3 times

...

kimalto452

4 years, 9 months ago

DML statements use "?" or "@" i don't think so... the answer is correct.

upvoted 1 times

kimalto452

4 years, 9 months ago

dml statenment use "@" *

upvoted 1 times

...

othman_ee

4 years, 11 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, 11 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

5 years, 1 month ago

Because of DML statements...the answer is correct.

upvoted 2 times

eceb

5 years 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, 11 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

5 years, 2 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

5 years ago

I agree. Within a package you should use "?" and the map parameters-variables

upvoted 1 times

...

CGLUE

5 years, 2 months 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

...