0

platforms and products Online Quiz - 85

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

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

  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


Correct Option: D

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

  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%


Correct Option: D

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?

  1. GET_DATE_PART (DATE_SHIPPED,'HH')

  2. GET_DATE_PART (DATE_SHIPPED,'HH12')

  3. GET_DATE_PART (DATE_SHIPPED,'HH24')

  4. All


Correct Option: A,B,C,D

Application Source Qualifier is used with_____________

  1. COBOL Sources

  2. XML Sources

  3. Salesforce.com Sources

  4. Relational DB Sources


Correct Option: C

AI Explanation

To answer this question, you need to understand the purpose and functionality of the Application Source Qualifier transformation in Informatica PowerCenter.

The Application Source Qualifier transformation is used to read data from various data sources and apply business rules or transformations on that data before loading it into the target. It helps in extracting, filtering, and transforming data from different types of sources.

Let's go through each option to understand why it is correct or incorrect:

Option A) COBOL Sources - This option is incorrect because the Application Source Qualifier transformation is not specifically designed for COBOL sources. However, it can be used with COBOL sources if the data can be extracted and transformed using standard connectors or plugins.

Option B) XML Sources - This option is incorrect because the Application Source Qualifier transformation is not specifically designed for XML sources. However, it can be used with XML sources if the data can be extracted and transformed using standard connectors or plugins.

Option C) Salesforce.com Sources - This option is correct because the Application Source Qualifier transformation can be used with Salesforce.com sources. It allows you to extract data from Salesforce objects and apply transformations on that data before loading it into the target.

Option D) Relational DB Sources - This option is incorrect because the Application Source Qualifier transformation is not specifically designed for relational database sources. However, it is commonly used with relational database sources to extract and transform data before loading it into the target.

The correct answer is: C) Salesforce.com Sources. This option is correct because the Application Source Qualifier transformation can be used with Salesforce.com sources to extract and transform data from Salesforce objects.

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

  1. SSAS

  2. SSIS

  3. SSRS

  4. SQL RDBMS


Correct Option: A

AI Explanation

To answer this question, you need to understand the Microsoft SQL BI tool and its components.

Option A) SSAS - This option is correct because SSAS (SQL Server Analysis Services) is the service/server in the Microsoft SQL BI tool that supports the creation and design of OLAP (Online Analytical Processing) databases. SSAS provides tools for creating multidimensional and tabular models that can be used for data analysis and reporting.

Option B) SSIS - This option is incorrect because SSIS (SQL Server Integration Services) is a service/server in the Microsoft SQL BI tool that is used for data integration and ETL (Extract, Transform, Load) processes. While SSIS can be used to extract data from various sources and load it into an OLAP database, it is not specifically designed for the creation and design of OLAP databases.

Option C) SSRS - This option is incorrect because SSRS (SQL Server Reporting Services) is a service/server in the Microsoft SQL BI tool that is used for creating and managing reports. SSRS is not specifically designed for the creation and design of OLAP databases.

Option D) SQL RDBMS - This option is incorrect because SQL RDBMS (Relational Database Management System) refers to the underlying database engine that powers the Microsoft SQL BI tool. While SQL RDBMS is used for storing and managing relational data, it is not specifically designed for the creation and design of OLAP databases.

The correct answer is A) SSAS. This option is correct because SSAS is the service/server in the Microsoft SQL BI tool that supports the creation and design of OLAP databases.

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

  1. WORKFLOWSTARTTIME

  2. PROC_RESULT

  3. SYSDATE

  4. STARTED


Correct Option: D

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?

  1. GET_DATE_PART (DATE_SHIPPED,'HH')

  2. GET_DATE_PART (DATE_SHIPPED,'HH12')

  3. GET_DATE_PART (DATE_SHIPPED,'HH24')

  4. All


Correct Option: D

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

  1. infacmd

  2. infasetup

  3. pmcmd

  4. pmrep


Correct Option: B

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

  1. Domain Service and Licensing Service

  2. Gateway Service and Log Service

  3. Authentication Service and Admin Service

  4. Integration Service and Repository Service


Correct Option: B

PowerCenter Domain _________

  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.


Correct Option: A

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

Application Source Qualifier is used with_____________

  1. COBOL Sources

  2. XML Sources

  3. Salesforce.com Sources

  4. Relational DB Sources


Correct Option: C

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

  1. infacmd

  2. infasetup

  3. pmcmd

  4. pmrep


Correct Option: B
  1. Domain Service and Licensing Service

  2. Gateway Service and Log Service

  3. Authentication Service and Admin Service

  4. Integration Service and Repository Service


Correct Option: B

PowerCenter Domain _________

  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.


Correct Option: A
- Hide questions