### platforms and products Online Quiz - 85

 Description: platforms and products Online Quiz - 85 Number of Questions: 20 Created by: Aliensbrain Bot Tags: platforms and products

PowerCenter Domain _________

1. Consists of Zero or more Grids.

2. Consists of One or more Grids.

3. Can not have a Grid.

4. Can have only one Grid.

What are the ‘Core Services’ that can be configured by users (admin)?

1. Domain Service and Licensing Service

2. Gateway Service and Log Service

3. Authentication Service and Admin Service

4. Integration Service and Repository Service

To define a Node or Domain in PowerCenter 8.x, which type of command is used?

1. infacmd

2. infasetup

3. pmcmd

4. pmrep

A database field requires the hour that an order is shipped. The date is stored in 24 Hr format. Which of the following examples will return the value 22 for an order shipped on Aug 15 2009, at 10.15 PM?

1. GET_DATE_PART (DATE_SHIPPED,'HH')

2. GET_DATE_PART (DATE_SHIPPED,'HH12')

3. GET_DATE_PART (DATE_SHIPPED,'HH24')

4. All

Which of the following is a reserved word for Workflow Expressions only?

1. WORKFLOWSTARTTIME

2. PROC_RESULT

3. SYSDATE

4. STARTED

Application Source Qualifier is used with_____________

1. COBOL Sources

2. XML Sources

3. Salesforce.com Sources

4. Relational DB Sources

1. PowerCenter 8. X - One Repository Service can manage only one Repository. 2. PowerCenter 7.X – One Repository Server can manage multiple repositories. Choose the correct option.
1. Statement 1 is true and Statement 2 is false.

2. Statement 1 is false and Statement 2 is true.

3. Both are false.

4. Both are true.

Which of the following methods is not a valid way to enter the Aggregator transformation cache size?

1. Use the cache calculator to enter the cache size based on Group by ports.

2. Choose “Auto”.

3. Enter the default cache sizes in the mapping properties.

4. Type a number value in KB, MB or GB.

What type of expressions can be used in an Aggregator transformation variable port?

1. Aggregate or Non-Aggregate expressions, provided they are not used together in a single variable port.

2. Aggregate and Non-Aggregate expressions, together in the same variable port.

3. Aggregate, Non-Aggregate and conditional expressions, together in the same variable port, provided that the variable port is also made a ‘group-by’ port.

4. Non-Aggregate and conditional expressions only.

What is the difference between the system variables $$SessStartTime and SESSSTARTTIME? 1.$$$SessStartTime returns the session start time as string and SESSSTARTTIME returns as a date/time. 2. $$SessStartTime returns the session start time as an integer and SESSSTARTTIME returns as a date/time. 3.$$$SessStartTime returns the session start time as string and SESSSTARTTIME returns as an integer.

4. There is no difference in practice. Either can be used to used to return the Session start time.

PowerCenter Domain _________

1. Consists of Zero or more Grids.

2. Consists of One or more Grids.

3. Can not have a Grid.

4. Can have only one Grid.

What are the ‘Core Services’ that can be configured by users (admin)?

1. Domain Service and Licensing Service

2. Gateway Service and Log Service

3. Authentication Service and Admin Service

4. Integration Service and Repository Service

To define a Node or Domain in PowerCenter 8.x, which type of command is used?

1. infacmd

2. infasetup

3. pmcmd

4. pmrep

A database field requires the hour that an order is shipped. The date is stored in 24 Hr format. Which of the following examples will return the value 22 for an order shipped on Aug 15 2009, at 10.15 PM?

1. GET_DATE_PART (DATE_SHIPPED,'HH')

2. GET_DATE_PART (DATE_SHIPPED,'HH12')

3. GET_DATE_PART (DATE_SHIPPED,'HH24')

4. All

Which of the following is a reserved word for Workflow Expressions only?

1. WORKFLOWSTARTTIME

2. PROC_RESULT

3. SYSDATE

4. STARTED

What Service / Server in the Microsoft SQL BI tool support Creation / Design of OLAP dB?

1. SSAS

2. SSIS

3. SSRS

4. SQL RDBMS

Application Source Qualifier is used with_____________

1. COBOL Sources

2. XML Sources

3. Salesforce.com Sources

4. Relational DB Sources

A database field requires the hour that an order is shipped. The date is stored in 24 Hr format. Which of the following examples will return the value 22 for an order shipped on Aug 15 2009, at 10.15 PM?

1. GET_DATE_PART (DATE_SHIPPED,'HH')

2. GET_DATE_PART (DATE_SHIPPED,'HH12')

3. GET_DATE_PART (DATE_SHIPPED,'HH24')

4. All

What should be the contributions of the participating companies when Passthrough company is involved ?

1. Passthrough - 0% and end client - 100%

2. Passthrough - 0% and local Company - 50%

3. Passthrough - 100% and Local Company - 100%

4. Passthrough - 100% and Local Company - 0%

You have received an e-mail message from someone you know with an unexpected file attached to it. What should you do?

1. Make sure the sender actually sent you the file, being cautious not to open the attached file until you can trace its source.

2. Go to antivirus Web sites that monitor possible virus attacks to see if this file is known to be bad.

3. Do not open it.

4. Both 1 & 2