0
Alien head

platforms and products Online Quiz - 84

Description: platforms and products Online Quiz - 84
Number of Questions: 20
Created by:
Tags: platforms and products
Attempted 0/20 Correct 0 Score 0

What option is to be selected for filter criteria to make sure report data will be filtered as per dashboard prompt values, operator should be:

  1. is equal to/is in

  2. is needed

  3. is not equal to/is not in

  4. is prompted


Correct Option: D

Which one is default view of report results?

  1. pivot

  2. tabular

  3. chart

  4. header


Correct Option: B

Report data can be downloaded in following formats:

  1. pdf

  2. excel

  3. html

  4. text


Correct Option: A,B,C

Answers is -

  1. place to create report request

  2. to see dashboard results

  3. shows list of subject areas

  4. all of above


Correct Option: A,B

What is scheduler in analytics?

  1. runs analytics server

  2. runs analytics web server

  3. used for chart types of reports

  4. none of above


Correct Option: D

SIL loads data into

  1. Staging OLAP

  2. Target OLAP

  3. Target OLAP

  4. None of above


Correct Option: B

LDAP authentication refers to -

  1. LDAP will be used to login user in analytics

  2. DB Users to be created to make sure users gets into Analytic

  3. password need to set in repository

  4. No need to create Repository users


Correct Option: B,D

Delivers deliver information to -

  1. email

  2. handheld

  3. wireless device

  4. all of above


Correct Option: D

Below are types of graph can be generated from Analytics -

  1. pivot

  2. pie

  3. radar

  4. bubble


Correct Option: A,B,C,D

What is DAC

  1. Data warehouse Admin Tool

  2. Data Administration Console

  3. Database Administration Console

  4. Data warehouse Administration Console


Correct Option: D

What is star Schema

  1. Dimension is surrounded by Facts

  2. Fact is surrounded by Dimensions

  3. Dimension is surrounded by Dimensions

  4. All of above


Correct Option: B

What is the use of DAC

  1. Schedule ETL,

  2. Change Capture

  3. Incremental/Full Load

  4. All of above


Correct Option: D

Where do you create Informatica Mappings

  1. Designer

  2. Workflow Manager

  3. Workflow Monitor

  4. Source Analyser


Correct Option: A

In OLAP db we find

  1. Staging tables

  2. Dimension Tables

  3. Fact Tables

  4. All of above


Correct Option: D

ETL has following components

  1. Designer

  2. Workflow Manager

  3. Workflow Monitor

  4. All of above


Correct Option: D

Application Source Qualifier is used with_____________

  1. COBOL Sources

  2. XML Sources

  3. Salesforce.com Sources

  4. Relational DB Sources


Correct Option: C

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.


Correct Option: D

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.


Correct Option: D

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.


Correct Option: D

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.


Correct Option: A
+ View questions