Assume that SAS Data Integration Studio Table Loader is being used in a job. The load style selected is Update/Insert. Which statement is true regarding theAssume that SAS Data Integration Studio?…

Question

Options

• AFrom the source table, matching rows are updated in the target table and new rows are added.
• BFrom the source table, matching rows AND new rows are added, but the original matching row in
• CFrom the source table, matching rows are skipped, and new rows are added.
• DA or C, depending on further options chosen.

• A
  8% (2)
• B
  23% (6)
• C
  12% (3)
• D
  58% (15)

Explanation

Option D is correct because the Update/Insert load style in SAS Data Integration Studio is not rigidly fixed to a single behavior - additional configuration options within the Table Loader transformation determine whether matching rows from the source are updated in the target (producing behavior A) or skipped entirely while only new rows are inserted (producing behavior C). The actual outcome is conditional on those further settings, making neither A nor C universally correct on its own.

Why A is wrong alone: While updating matches and inserting new rows is one valid configuration, it is not the only possible outcome, so stating it as an absolute truth is incomplete.

Why C is wrong alone: Skipping matching rows and inserting only new rows is also a valid configuration, but again, it is not the only outcome - same problem as A.

Why B is wrong: B describes a behavior where both the original matching row and a new copy are added - essentially duplicating rows. No standard Update/Insert load style works this way; that would be a data integrity issue, not a feature.

Memory tip: Think of "Update/Insert" as a dial, not a switch - SAS lets you turn it toward either "update matches" or "ignore matches," so when you see this load style on the exam, remember the answer hinges on what extra options are set, pointing you straight to "it depends" = D.

No community discussion yet for this question.