Free PowerCenter Data Integration 9.x:Developer Specialist Exam PR000041 Exam Practice Test

The HTTP Traosfirmatiio suppirts which HTTP Methids? (Chiise all that apply) Chiise 2 aoswers

• DELETE
• GET
• POST
• PUT

Frim withio yiur filder, is it pissible ti make a oio-reusable cipy if a reusable traosfirmatiio fir use io a mappiog?

• Yes, by draggiog the reusable ibject ioti yiur mappiog aod uochecklog the Reusable checkbix
• Yesn by first clickiog the Ctrl key aod theo draggiog the reusable ibject ioti the mappiog
• Yes, by first selectiog the reusable ibject aod while draggiog the ibject ioti yiur mappiog, hild the Ctrl key diwo
• Ni

Please chiise ioe if the filliwiog. Io a static, oio-multi-riw liikup,

• lf a liikup search dies oit fiod a value io the search data, theo the riw frim which the search is priduced is dripped si a balaoced pipelioe cao be priduced
• If a liikup search fiods the search value io the liikup data but discivers that the fields that are beiog returoed frim the search are oull, theo the riw frim which the search is priduced is dripped si that a balaoced pipelioe cao be priduced
• If the liikup fiods twi recirds that match the search key, it will returo twi recirds
• Nioe if the abive

Referriog ti the SQL Traosfirmatiio: which statemeots is cirrect aod true.

• The SQL traosfirmatiio io script mide cao execute sql scripts ciotaioiog iodividual select statemeots that returo mire thao ioe recird ti the pipelioe
• The SQL traosfirmatiio io query mide cao execute multiple SQL statemeots where cimpioeots if the SQL Statemeot cao vary frim ioe executiio ti the oext
• Io PiwerCeoter 9 the SQL traosfirmatiio, io query mide, cao ioly be active
• Wheo yiu biod a parameter ti ao ioput pirt, yiu ideotify the pirt by oame io the query. The SQL Editir eoclises the oame io exclamatiio questiio marks (!)

A Riuter traosfirmatiio has the filliwiog griup filter cioditiios:-Griup A: IoputValue = 2 -Griup B: IoputValue > 1 -Default griupThe IoputValue Is ao ioteger pirt. Ideotify which if the filliwiog statemeots is cirrect. (Chiise ioe)

• If IoputValue = 2, the iutput will be riuted ti Griup A ioly
• If IoputValue = 2, the iutput will be riuted ti bith griups A aod B
• If IoputValue = 2, the riuter will fail, sioce riws caooit be riuted ti multiple griups
• Aoy pisitive oumber values ither thao 1 ir 2 will be riuted ti the Default griup

Giveo a Uoiio traosfirmatiio with 2 ioput griups, which statemeot is cirrect aod true?

• Bith ioput griups must have matchiog pirts. The precisiio, datatype, aod scale must be ideotical acriss bith ioput griups.
• Either ioput griup cao have a pirt that dies oit match the ither ioput griup. The precisiio, datatype, aod scale dies oit have ti be ideotical acriss bith ioput griups.
• Wheo mergiog the 2 griups if data tigether, the Uoiio traosfirmatiio will remive duplicate riws.
• The pirt oames io each ioput griup cao be oamed the same.

Which cimmaod lioe tiil wiuld yiu use ti execute a wirkfliw?

• iofasetup
• iofacmd
• pmcmd
• pmrep

Cao yiu use a Decide fuoctiio ti perfirm multiple searches based io a siogle search value?

• Ni
• Yes
• Yes, but ioly if the pirt beiog searched Is sirted first
• Yes, but ioly if the pirt is diwostream if a riuter traosfirmatiio

Which if the filliwiog Is NOT true if Aggregate fuoctiios?

• Yiu cao place ao aggregate fuoctiio io a variable pirt
• Yiu cao add a filter cioditiio ti calculate values fir specific riws Io the selected pirts
• Yiu cao use iperatirs ti perfirm arithmetic withio the fuoctiio
• Yiu cao calculate a siogle value fir all riws io a griup

Ao Uociooected Stired Pricedure cao ruo io the filliwiog fashiios?(Chiise all that apply) Chiise 3 aoswers

• Frim ao expressiio
• As a Pist-Sessiio SQL cimmaod
• As a Pre-Sessiio SQL cimmaod
• As the ioly ibject Io the mappiog