Exam 1z0-447 topic 1 question 28 discussion

Actual exam question from Oracle's 1z0-447

Question #: 28
Topic #: 1

Which three are valid Extract or Replicat statements using the @RANGE function for an Acct table with a Primary Key on the AccountID column? (Select three.)

A. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID));
B. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID));
C. TABLE fin.Sales, FILTER (@RANGE (1, 2));
D. FILTER (@RANGE (2, 2, AccountID));
E. FILTER (@RANGE 2, 2, ID);

Show Suggested Answer

Suggested Answer: ABC 🗳️
Reference:
https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/column_conversion_functions022.htm#GWURF809

by kandid at Oct. 26, 2020, 8:17 a.m.

Comments

Submit Cancel

wiprooracle

11 months, 4 weeks ago

A,B,C looks to be the answer based on "Specify each range in a FILTER clause in a TABLE or MAP statement." from the GG documentation.

upvoted 1 times

...

arcan3

2 years, 4 months ago

B and E are eliminated by the wrong column name, so A C D would be correct

upvoted 1 times

arcan3

2 years, 4 months ago

(Column is an optional parameter in the Range function https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/column_conversion_functions022.htm#GWURF809 )

upvoted 1 times

...

DXan

3 years, 1 month ago

And A,B,C are all complete ones. As the question is looking for Extract and Replicat process commands, and not only the @RANGE syntax.

upvoted 1 times

...

DXan

3 years, 1 month ago

Then how B will be correct? nowhere in the question, anything is said about a column "ID". So if B is correct means SYNTAX correctness is considered, so by this C holds correct.

upvoted 1 times

...

kandid

3 years, 2 months ago

Seems C is wrong, because of tablename and column ID. Should be D instead

upvoted 1 times

...