• platforms and products Online Quiz - 85
Back
0
Alien head

platforms and products Online Quiz - 85

Description: platforms and products Online Quiz - 85
Number of Questions: 20
Created by:
Tags: platforms and products
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

PowerCenter Domain _________

technology platforms and products

  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.

Show answer
Correct Option: A

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

technology platforms and products

  1. Domain Service and Licensing Service

  2. Gateway Service and Log Service

  3. Authentication Service and Admin Service

  4. Integration Service and Repository Service

Show answer
Correct Option: B

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

technology platforms and products

  1. infacmd

  2. infasetup

  3. pmcmd

  4. pmrep

Show answer
Correct Option: B

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?

technology platforms and products

  1. GET_DATE_PART (DATE_SHIPPED,'HH')

  2. GET_DATE_PART (DATE_SHIPPED,'HH12')

  3. GET_DATE_PART (DATE_SHIPPED,'HH24')

  4. All

Show answer
Correct Option: D

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

technology platforms and products

  1. WORKFLOWSTARTTIME

  2. PROC_RESULT

  3. SYSDATE

  4. STARTED

Show answer
Correct Option: D

Application Source Qualifier is used with_____________

technology platforms and products

  1. COBOL Sources

  2. XML Sources

  3. Salesforce.com Sources

  4. Relational DB Sources

Show answer
Correct Option: C
  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.
technology platforms and products

  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.

Show answer
Correct Option: D

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

technology platforms and products

  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.

Show answer
Correct Option: D

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

technology platforms and products

  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.

Show answer
Correct Option: D

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

technology platforms and products

  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.

Show answer
Correct Option: A

PowerCenter Domain _________

technology platforms and products

  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.

Show answer
Correct Option: A

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

technology platforms and products

  1. Domain Service and Licensing Service

  2. Gateway Service and Log Service

  3. Authentication Service and Admin Service

  4. Integration Service and Repository Service

Show answer
Correct Option: B

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

technology platforms and products

  1. infacmd

  2. infasetup

  3. pmcmd

  4. pmrep

Show answer
Correct Option: B

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?

technology platforms and products

  1. GET_DATE_PART (DATE_SHIPPED,'HH')

  2. GET_DATE_PART (DATE_SHIPPED,'HH12')

  3. GET_DATE_PART (DATE_SHIPPED,'HH24')

  4. All

Show answer
Correct Option: D

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

technology platforms and products

  1. WORKFLOWSTARTTIME

  2. PROC_RESULT

  3. SYSDATE

  4. STARTED

Show answer
Correct Option: D

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

technology platforms and products

  1. SSAS

  2. SSIS

  3. SSRS

  4. SQL RDBMS

Show answer
Correct Option: A

Application Source Qualifier is used with_____________

technology platforms and products

  1. COBOL Sources

  2. XML Sources

  3. Salesforce.com Sources

  4. Relational DB Sources

Show answer
Correct Option: C

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?

technology platforms and products

  1. GET_DATE_PART (DATE_SHIPPED,'HH')

  2. GET_DATE_PART (DATE_SHIPPED,'HH12')

  3. GET_DATE_PART (DATE_SHIPPED,'HH24')

  4. All

Show answer
Correct Option: A,B,C,D

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

technology platforms and products

  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%

Show answer
Correct Option: D

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

technology platforms and products

  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

Show answer
Correct Option: D
+ View questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3454 Quizzes
118905 Questions
 technology
291 Quizzes
36705 Questions
 sports
960 Quizzes
19148 Questions
 science & technology
550 Quizzes
11015 Questions
 history
371 Quizzes
7423 Questions
 softskills
0 Quizzes
7131 Questions
 programming languages
351 Quizzes
7021 Questions
 culture
335 Quizzes
6697 Questions
 databases
243 Quizzes
4862 Questions
 math & puzzles
226 Quizzes
4539 Questions