0

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
  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
  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

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

Application Source Qualifier is used with_____________

  1. COBOL Sources

  2. XML Sources

  3. Salesforce.com Sources

  4. Relational DB Sources


Correct Option: C

ETL has following components

  1. Designer

  2. Workflow Manager

  3. Workflow Monitor

  4. All of above


Correct Option: D

In OLAP db we find

  1. Staging tables

  2. Dimension Tables

  3. Fact Tables

  4. All of above


Correct Option: D
  1. Designer

  2. Workflow Manager

  3. Workflow Monitor

  4. Source Analyser


Correct Option: A
  1. Schedule ETL,

  2. Change Capture

  3. Incremental/Full Load

  4. All of above


Correct Option: D
  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 DAC

  1. Data warehouse Admin Tool

  2. Data Administration Console

  3. Database Administration Console

  4. Data warehouse Administration Console


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

Delivers deliver information to -

  1. email

  2. handheld

  3. wireless device

  4. all of above


Correct Option: D
  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

SIL loads data into

  1. Staging OLAP

  2. Target OLAP

  3. Target OLAP

  4. None of above


Correct Option: 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
  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
- Hide questions