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

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

Answer: 4

Which one is default view of report results?

  1. pivot

  2. tabular

  3. chart

  4. header

Answer: 2

Report data can be downloaded in following formats:

  1. pdf

  2. excel

  3. html

  4. text

Answer: 1,2,3

Answers is -

  1. place to create report request

  2. to see dashboard results

  3. shows list of subject areas

  4. all of above

Answer: 1,2

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

Answer: 4

SIL loads data into

  1. Staging OLAP

  2. Target OLAP

  3. Target OLAP

  4. None of above

Answer: 2

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

Answer: 2,4

Delivers deliver information to -

  1. email

  2. handheld

  3. wireless device

  4. all of above

Answer: 4

Below are types of graph can be generated from Analytics -

  1. pivot

  2. pie

  3. radar

  4. bubble

Answer: 1,2,3,4

What is DAC

  1. Data warehouse Admin Tool

  2. Data Administration Console

  3. Database Administration Console

  4. Data warehouse Administration Console

Answer: 4

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

Answer: 2

What is the use of DAC

  1. Schedule ETL,

  2. Change Capture

  3. Incremental/Full Load

  4. All of above

Answer: 4

Where do you create Informatica Mappings

  1. Designer

  2. Workflow Manager

  3. Workflow Monitor

  4. Source Analyser

Answer: 1

In OLAP db we find

  1. Staging tables

  2. Dimension Tables

  3. Fact Tables

  4. All of above

Answer: 4

ETL has following components

  1. Designer

  2. Workflow Manager

  3. Workflow Monitor

  4. All of above

Answer: 4

Application Source Qualifier is used with_____________

  1. COBOL Sources

  2. XML Sources

  3. Salesforce.com Sources

  4. Relational DB Sources

Answer: 3

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.

Answer: 4

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.

Answer: 4

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.

Answer: 4

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.

Answer: 1
+ View questions