Referring to the SQL Transformation: which statements is correct and true.
Suggested Answer: C
Get Premium PR000041 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
DE
Deandrea
1 year ago
Yeah, I've seen the exclamation marks used for binding parameters.
CR
Cristy
1 year ago
Wait, are you sure about D? I thought it was different!
CO
Corrinne
1 year ago
C is correct, query mode is only active in PowerCenter 9.
MI
Mirta
1 year ago
I think B is misleading, it can't vary that much.
DE
Denny
1 year ago
A is definitely true, it can handle multiple records.
ST
Stefan
1 year ago
I vaguely recall something about binding parameters, but I'm not sure if the exclamation question marks are the right symbols for identifying input ports in option D.
MA
Marta
1 year ago
I remember practicing with query mode, and I feel like option B is correct since it mentioned varying components in SQL statements.
TA
Tamala
1 year ago
I think option A sounds familiar, but I'm not entirely sure if the SQL transformation can handle multiple records in script mode.
TR
Trinidad
1 year ago
Option C seems a bit off to me; I thought the SQL transformation could be both active and passive in PowerCenter 9.
LO
Lovetta
1 year ago
I'm a bit confused here. Is the $val variable being passed by reference or by value? That could affect the output.
MA
Marjory
1 year ago
Okay, let's see. I think I need to add up the total costs for each vendor and compare them to the $310,000 budget. That should help me determine which vendor or vendors meet the criteria.
SH
Shizue
1 year ago
I've got a good feeling about Change Sets and Data Loader. Those are the two I'll focus on for this exam question.