Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

SAS A00-260 Exam - Topic 10 Question 107 Discussion

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? Table Loader is being used in a job. The load style selected is Update/Insert. Which statement is true regarding the relationship between the source table and the target table?
D) A or C, depending on further options chosen.
A) From the source table, matching rows are updated in the target table and new rows are added.
B) From the source table, matching rows AND new rows are added, but the original matching row in the target table is marked as inactive.
C) From the source table, matching rows are skipped, and new rows are added.

SAS A00-260 Exam - Topic 10 Question 107 Discussion

Actual exam question for SAS's A00-260 exam
Question #: 107
Topic #: 10
[All A00-260 Questions]

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? Table Loader is being used in a job. The load style selected is Update/Insert. Which statement is true regarding the relationship between the source table and the target table?

Show Suggested Answer Hide Answer
Suggested Answer: D

Contribute your Thoughts:

0/2000 characters
Barabara
1 day ago
I feel B could be true too. Marking as inactive is a common practice.
upvoted 0 times
...
Barabara
6 days ago
I lean towards D. It depends on the options we choose later.
upvoted 0 times
...
Trinidad
12 days ago
I think A is correct. It makes sense to update and add new rows.
upvoted 0 times
...
Zona
17 days ago
Is it really true that matching rows can be marked inactive? Sounds confusing!
upvoted 0 times
...
Jannette
22 days ago
I always thought it was just A. Glad to see others agree!
upvoted 0 times
...
Lynette
27 days ago
Wait, so matching rows can be skipped? That seems odd.
upvoted 0 times
...
Justine
1 month ago
I think D makes more sense, though.
upvoted 0 times
...
Sage
1 month ago
A is definitely correct! That's how it works.
upvoted 0 times
...
Lewis
1 month ago
I remember there being a discussion about how options can change the behavior, so D might be correct if there are additional settings involved.
upvoted 0 times
...
Ivette
2 months ago
I thought that with Update/Insert, matching rows are usually updated, but I can’t recall if they can be skipped. Option C seems possible too.
upvoted 0 times
...
Wilda
2 months ago
I’m not entirely sure, but I feel like there was a question similar to this where marking rows as inactive was mentioned. That makes me think of option B.
upvoted 0 times
...
Marguerita
2 months ago
I remember practicing with the Update/Insert load style, and I think it updates matching rows and adds new ones, so I’m leaning towards A.
upvoted 0 times
...

Save Cancel