Question 1

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:

technology platforms and products

is equal to/is in
is needed
is not equal to/is not in
is prompted

Answer

Answer: 1,2,3

Answer

Answer: 1,2

Answer

Answer: 2,4

Answer

Answer: 1,2,3,4

Question 2

Which one is default view of report results?

technology platforms and products

pivot
tabular
chart
header

Question 3

Report data can be downloaded in following formats:

technology platforms and products

pdf
excel
html
text

Question 4

Answers is -

technology platforms and products

place to create report request
to see dashboard results
shows list of subject areas
all of above

Question 5

What is scheduler in analytics?

technology platforms and products

runs analytics server
runs analytics web server
used for chart types of reports
none of above

Question 6

SIL loads data into

technology platforms and products

Staging OLAP
Target OLAP
Target OLAP
None of above

Question 7

LDAP authentication refers to -

technology platforms and products

LDAP will be used to login user in analytics
DB Users to be created to make sure users gets into Analytic
password need to set in repository
No need to create Repository users

Question 8

Delivers deliver information to -

technology platforms and products

email
handheld
wireless device
all of above

Question 9

Below are types of graph can be generated from Analytics -

technology platforms and products

pivot
pie
radar
bubble

Question 10

What is DAC

technology platforms and products

Data warehouse Admin Tool
Data Administration Console
Database Administration Console
Data warehouse Administration Console

Question 11

What is star Schema

technology platforms and products

Dimension is surrounded by Facts
Fact is surrounded by Dimensions
Dimension is surrounded by Dimensions
All of above

Question 12

What is the use of DAC

technology platforms and products

Schedule ETL,
Change Capture
Incremental/Full Load
All of above

Question 13

Where do you create Informatica Mappings

technology platforms and products

Designer
Workflow Manager
Workflow Monitor
Source Analyser

Question 14

In OLAP db we find

technology platforms and products

Staging tables
Dimension Tables
Fact Tables
All of above

Question 15

ETL has following components

technology platforms and products

Designer
Workflow Manager
Workflow Monitor
All of above

Question 16

Application Source Qualifier is used with_____________

technology platforms and products

COBOL Sources
XML Sources
Salesforce.com Sources
Relational DB Sources

Question 17

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

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

Question 18

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

technology platforms and products

Use the cache calculator to enter the cache size based on Group by ports.
Choose “Auto”.
Enter the default cache sizes in the mapping properties.
Type a number value in KB, MB or GB.

Question 19

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

technology platforms and products

Aggregate or Non-Aggregate expressions, provided they are not used together in a single variable port.
Aggregate and Non-Aggregate expressions, together in the same variable port.
Aggregate, Non-Aggregate and conditional expressions, together in the same variable port, provided that the variable port is also made a ‘group-by’ port.
Non-Aggregate and conditional expressions only.

Question 20

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

technology platforms and products

$$$SessStartTime returns the session start time as string and SESSSTARTTIME returns as a date/time.
$$$SessStartTime returns the session start time as an integer and SESSSTARTTIME returns as a date/time.
$$$SessStartTime returns the session start time as string and SESSSTARTTIME returns as an integer.
There is no difference in practice. Either can be used to used to return the Session start time.

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

platforms and products Online Quiz - 84

Find more quizzes from top tags