Carolyn Kinnear
Quiz by , created more than 1 year ago

Quiz on Cloud Data Integrations Specialist, created by Carolyn Kinnear on 24/01/2019.

69
0
0
No tags specified
Carolyn Kinnear
Created by Carolyn Kinnear almost 7 years ago
Close

Cloud Data Integrations Specialist

Cloud Data Integrations Specialist

Question 1 of 66

1

What information is contained in the Audit Log?

Select one of the following:

  • Field-level mapping changes.

  • User Logins.

  • Both User Logins and Create/Update/Delete operation on objects.

  • Informatica Cloud Task Errors.

Explanation

Question 2 of 66

1

Where are the detailed error logs for tasks located?

Select one of the following:

  • \main\logfiles from the root of the Secure Agent filepath

  • \main\rdtmDir\error from the root of the Secure Agent filepath

  • Informatica Cloud Admin Console

  • These are only available in the Informatica Cloud Application.

Explanation

Question 3 of 66

1

Configuring object-level permissions allow you to restrict or expand the permissions the user group has for the object.

Select one of the following:

  • True
  • False

Explanation

Question 4 of 66

1

What is the purpose of the Cloud Connector Toolkit?

Select one of the following:

  • To develop native connectors for the Informatica Cloud

  • To establish connectivity to custom salesforce objects

  • To connect integration templates to multiple targets

  • None of these

Explanation

Question 5 of 66

1

Which of the following could be used to invoke ICS REST API?

Select one of the following:

  • Java

  • force.com

  • JavaScript

  • cUrl

  • All of the above

Explanation

Question 6 of 66

1

Where can a user define parameters for use in Data Synchronization tasks?

Select one of the following:

  • Parameters are not definable for use in the Informatica Cloud

  • In the secure agent directory path /main/rdtmDir/files

  • In the parameters tab within the Informatica Cloud UI

  • In the secure agent directory path /main/rdtmDir/userparameters

Explanation

Question 7 of 66

1

What format is used in a parameter file for Data Synchronization tasks?

Select one of the following:

  • parameter=value

  • $$parameter=value

  • $value=parameter

  • parameter==value

Explanation

Question 8 of 66

1

If you make changes to an embedded guide, the changes will be propagated to all guides that use the embedded guide.

Select one of the following:

  • True
  • False

Explanation

Question 9 of 66

1

The embedded guide and the embedding guide must both be published in order to work together.

Select one of the following:

  • True
  • False

Explanation

Question 10 of 66

1

Connections can be created for which of the following?

Select one of the following:

  • Published service connectors.

  • Licensed Informatica Cloud connectors that are real-time enabled.

  • Deployed connectors created in BPEL using Informatica Process Developer

  • All of the above.

Explanation

Question 11 of 66

1

A Secure Agent is ___.

Select one of the following:

  • a 32- bit of 64-bit hosted instance of PowerCenter running in Amazon or Azure instance.

  • a lightweight 32-bit or 64-bit application that clients can chose to upgrade ad-hoc

  • a lightweight 32-bit or 64-bit application hosted by Informatica for customers to use

  • a lightweight 32-bit or 64-bit self upgrading program that runs on a machine in the customers network or an Amazon or Azure instance

Explanation

Question 12 of 66

1

In an assignment step, if you want the input fields to be populated with a numeric value, select a data source of:

Select one or more of the following:

  • Formula

  • Query

  • Content

Explanation

Question 13 of 66

1

You have a child object, a contact record that belongs to an account that's already in Salesforce but you don't have the external id to match it to. You do have the account name on the incoming contact record so you can match the incoming account name on the account name already stored in Salesforce. What feature or transformation do you need to use in the Data Synchronization Service to match those values together?

Select one of the following:

  • On Step 5 of the Data Synchronization Wizard use the lookup function to match the records and return the Salesforce ID field.

  • On Step 4 of the Data Synchronization Wizard, use the Related Objects Button to point to the related field in the parent object and then use the lookup function to match the records and return the Salesforce Id field.

  • On Step 5 of the Data Synchronization Wizard, use the Related Objects Button to point to the related field in the parent object and then use lookup function to match the records and return the Salesforce Id field.

Explanation

Question 14 of 66

1

After changes have been made to a mapping that is being used by one or more mapping configuration tasks, you can deploy these changes using which of the following:

Select one or more of the following:

  • Import the new mapping from PowerCenter

  • Save and deploy to mapping configuration tasks.

  • Save updates as a new mapping (retaining the previous version of the mapping).

Explanation

Question 15 of 66

1

To include all incoming fields from an upstream transformation except those with dates, what should you do?

Select one of the following:

  • Delete all of the date fields from the source.

  • Configure two field rules. First, use the All Fields rule to include all fields. Then, create a Fields by Datatype rule to exclude fields by data type and select Date/Time as the data type to exclude.

  • Configure a simple filter condition to exclude fields with data type of Date/Time.

Explanation

Question 16 of 66

1

Which of the following is not a valid incoming field rule type?

Select one of the following:

  • Choose fields by data type.

  • "All Fields"

  • Choose fields by Origin

  • Choose fields by field names

Explanation

Question 17 of 66

1

You want to load account records from a .csv source file where 'BillingState' =NY AND 'Annual Revenue' >=1000000000, you should use a simple filter to do this.

Select one of the following:

  • True
  • False

Explanation

Question 18 of 66

1

Which of the following could you use a field expression to do?

Select one or more of the following:

  • Trimming blank spaces from a source field.

  • Mapping multiple source fields to a single target field

  • Insert a value into a target field for all records

  • Covert date to the correct format for target field

Explanation

Question 19 of 66

1

How are data filters within Data Synchronization tasks used?

Select one of the following:

  • They filter source data using valid SQL or SOQL

  • They determine deltas in source data.

  • They filter data after the field-level mapping has been completed.

Explanation

Question 20 of 66

1

Salesforce Bulk API jobs run in parallel mode (batches are written to the target at the same time) by default.

Select one of the following:

  • True
  • False

Explanation

Question 21 of 66

1

Which of the following are supported pre-processing or post-processing commands?

Select one or more of the following:

  • SQL Command

  • Unix Command

  • Valid DOS or batch file

Explanation

Question 22 of 66

1

Which of the following can be used to write to multiple targets?

Select one of the following:

  • Mapplets

  • Mappings

  • Connections.

Explanation

Question 23 of 66

1

When adding parameters to a Cloud Mapping Designer mapping, it is a good idea to add them:

Select one of the following:

  • After the mapping has been configured and tested with specified objects or filters, then parameters can be added to replace those objects or filters.

  • During the initial configuration of the mapping.

  • In the mapping configuration task.

Explanation

Question 24 of 66

1

Active transformations do not change the number of rows that pass to the next step of the mapping.

Select one of the following:

  • True
  • False

Explanation

Question 25 of 66

1

What is the purpose of the field mapping in the Target transformation?

Select one of the following:

  • Allows fields from source to be mapped to fields in the Target.

  • Allows new fields to be created in the Target to match Source

  • Allows source fields to be deleted if they do not exist in Target

  • None of the above

Explanation

Question 26 of 66

1

Which transformation is used to define how data from 2 different sources can be combined?

Select one of the following:

  • Aggregator

  • Filter

  • Joiner

  • Expression

Explanation

Question 27 of 66

1

Which 'passive' transformation would you use to create a new field?

Select one of the following:

  • Filter

  • Joiner

  • Expression

Explanation

Question 28 of 66

1

How do you specify the set of fields that flow from one shape in the mapping to the next?

Select one of the following:

  • Draw a line for each field going out of a shape into the next shape

  • Specify a set of incoming field rules in the receiving shape

  • Select the set of fields in the line linking the two shapes

  • Fields cannot be selected. All fields leaving a shape flow into the subsequent shape

Explanation

Question 29 of 66

1

John has "SKU number" coming in from his Source data containing Order information. Each "SKU number" corresponds to product description, price. The details of the product description and price for particular "SKU number" exists in another database. In order to read this product information and augment that to the order details, what transformation would John be using?

Select one of the following:

  • Normalizer

  • Lookup

  • Filter

  • Aggregator

Explanation

Question 30 of 66

1

Jayden would like to build a mapping, but run it against 3 different sets of Sources and Targets, one each for Dev/Test/Prod. Which of the following is the best way for him to achieve this?

Select one of the following:

  • Define a single mapping with the Source and Target connections parameterized. Configure 3 MCTs, one for each set of Sources and Targets: Dev/Test/Prod

  • Create 3 copies of the mapping, one for each set of Sources and Targets: Dev/Test/Prod

  • Define a single mapping with the Source and Target Objects parameterized. Create 3 copies of this mapping for this different Source and Target connection

  • None of the above.

Explanation

Question 31 of 66

1

Once a MCT is defined, any further changes to the mapping will not affect the mapping configuration task until:

Select one of the following:

  • The mapping is deployed.

  • The mapping is Saved.

  • The mapping is Deleted.

  • The mapping is executed.

Explanation

Question 32 of 66

1

Which of the following is an Active transformation?

Select one or more of the following:

  • Expression

  • Filter

  • Aggregator

  • None of the above

Explanation

Question 33 of 66

1

In a Filter transformation, can the value to filter the data by be defined as a parameter that can be configured at runtime?

Select one of the following:

  • True
  • False

Explanation

Question 34 of 66

1

Jennifer is working on creating a report. She has Sales data for all regions. She would like to determine the total Sales per region. She would also like to get the average deal size per region. Which transformation should she be using?

Select one of the following:

  • Aggregator

  • Expression

  • Filter

  • Lookup

Explanation

Question 35 of 66

1

Which of these statements is true?

Select one of the following:

  • A Cloud Mapping Designer mapping can only move data from a single Source to a single Target.

  • A Cloud Mapping Designer mapping can only be used to build integrations between Cloud applications.

  • A Cloud Mapping Designer mapping can integrate data from multiple Cloud and On-Premise Sources with multiple Cloud and On-Premise Targets.

  • None of the above.

Explanation

Question 36 of 66

1

Sources and Targets in a mapping can be __.

Select one of the following:

  • Relational databases

  • Cloud applications

  • Files

  • Any of the above.

Explanation

Question 37 of 66

1

A mapping has 2 parameters. A MCT has been defined with values for the 2 parameters. The MCT is scheduled to run every night at 10pm. The mapping designer modified the mapping to add another parameter and deploys his changes to the dependent MCT. What is to be expected at the next scheduled execution of the task?

Select one of the following:

  • The task will ignore the changes until it has been un-scheduled

  • The task will be rendered incompatible and must be deleted and re-created.

  • A mapping has 2 parameters. A MCT has been defined with values for the 2 parameters.

  • The task will fail with a notification that additional configuration is needed. Once the task is edited and the value for the newly added parameter is configured, it will run successfully.

Explanation

Question 38 of 66

1

Name the feature used to sequentially run tasks in a specified order

Select one of the following:

  • PowerCenter Service

  • Workflows

  • Task Flows

  • Plug-ins

Explanation

Question 39 of 66

1

A Related Object is an object that is related to another object based on a relationship defined in Informatica Cloud.

Select one of the following:

  • True
  • False

Explanation

Question 40 of 66

1

Which operation would be best to use when synchronizing data between two systems?

Select one of the following:

  • Insert

  • Update

  • Upsert

Explanation

Question 41 of 66

1

Where can you find Informatica Cloud log files?

Select one or more of the following:

  • On the agent machine, in the Secure Agent installation directory, under rdtmDir

  • Error rows preview and job log file can be accessed from the activity log and job details pages in Informatica Cloud.

  • By logging into the IC Repository

Explanation

Question 42 of 66

1

Incremental Processing is built into Data Replication for all source types.

Select one of the following:

  • True
  • False

Explanation

Question 43 of 66

1

What source data types are valid for use in a Data Replication Service?

Select one of the following:

  • Salesforce data

  • Salesforce and database data

  • Salesforce, flat files, and database data

  • Database and flatfile data

Explanation

Question 44 of 66

1

Where does the data get processed?

Select one of the following:

  • In the Informatica Cloud servers

  • In the Informatica Cloud Secure Agent (typically behind customer firewall)

  • In the informatica cloud repository

Explanation

Question 45 of 66

1

How does the Secure Agent communicate with Informatica Cloud?

Select one of the following:

  • All communication is outbound through HTTPS protocol (port 443)

  • Communication is initiated over telnet

  • There is no communication between the secure agent and Informatica Cloud

  • Communication is initiated by Informatica

Explanation

Question 46 of 66

1

Which statement best describes the Secure Agent?

Select one of the following:

  • Included templates for building jobs in the Informatica Cloud

  • A group of services without a user interface that executes jobs that were created using the Informatica Cloud web based interfaces.

  • Holds security modules for a client running in the Informatica Cloud

  • Allows clients to run Data Quality Mappings in the Cloud.

Explanation

Question 47 of 66

1

Within the Guide Designer, you can view the following report(s) on guide usage:

Select one or more of the following:

  • Outcome Chart

  • Detailed Activity

  • Current Activity

Explanation

Question 48 of 66

1

By default, only Admin profiles have access to the Guide Designer tab:

Select one of the following:

  • True
  • False

Explanation

Question 49 of 66

1

Guide execution details are only available for a guide if the Guide Execution Logging property is enabled

Select one of the following:

  • True
  • False

Explanation

Question 50 of 66

1

When you view the Outcome Chart for a guide, it displays data about the end of guide outcomes:

Select one of the following:

  • for all time

  • for a customizable period of time

  • for today

Explanation

Question 51 of 66

1

Service connectors can be used to access (pick 2)

Select one or more of the following:

  • SOAP-based web services

  • JMS queues containing XML

  • REST services using JSON

Explanation

Question 52 of 66

1

A data decision step almost always has an Otherwise answer

Select one of the following:

  • True
  • False

Explanation

Question 53 of 66

1

Data decision steps can perform tests for which of the following?

Select one of the following:

  • Text values

  • Numeric values

  • Date values

  • All of the above

Explanation

Question 54 of 66

1

Customization of the guide themes is possible in the following ways:

Select one of the following:

  • Using an HTML WYSIWIG editor

  • Using CSS

  • On desktop/tablets and smart phones

Explanation

Question 55 of 66

1

In order to install Real Time in your Salesforce org, you must:

Select one or more of the following:

  • Have the managed package link

  • Have the Professional edition of Salesforce

  • Be a system administrator

Explanation

Question 56 of 66

1

Screen steps are typically used to ___.

Select one of the following:

  • Present different answers.

  • Display instructions.

  • Show data to the user and to have the user update data.

  • Accomplish tasks automatically.

Explanation

Question 57 of 66

1

What types of Objects can a Screenflow guide read/write?

Select one of the following:

  • Standard Objects

  • Custom Objects

  • Junction Objects

  • All of the above

Explanation

Question 58 of 66

1

What happens in a screenflow guide if there is a validation rule defined in Salesforce?

Select one of the following:

  • The Screenflow Guide uses the validation rule without notifying the user.

  • The Screenflow Guide ignores the validation rule.

  • The Screenflow Guide does not advance until the user corrects the input data for the validation rule.

  • The Screenflow Guide crashes.

Explanation

Question 59 of 66

1

If you want a guide to perform a hand-off from one person to another, use a milestone step.

Select one of the following:

  • True
  • False

Explanation

Question 60 of 66

1

If you want to prevent a user from stepping backwards in a guide, be sure to disable the following option(s).

Select one of the following:

  • Allow User to Go Back on Milestone Step

  • Allow Restart

  • Show Guide Only When

Explanation

Question 61 of 66

1

With a Screenflow Guide, which of the following options are available to make fields required?

Select one of the following:

  • Make the field required in Salesforce Administrative setup.

  • You never need required fields with Screenflow Guides.

  • Screenflow guides ignore required fields in Salesforce.

  • Make the field required at any step in a Screenflow Guide.

Explanation

Question 62 of 66

1

How do you make a Screenflow Guide launch from a button on a Salesforce page?

Select one of the following:

  • That is not supported.

  • Modify an existing Visualforce page and link it to the button.

  • Write Apex code.

Explanation

Question 63 of 66

1

With mobile guides, we recommend setting the Applies To:

Select one of the following:

  • Home

  • Any Object

  • Event

  • Content

Explanation

Question 64 of 66

1

Without Real Time Apps in Salesforce1, users are limited to single-step actions.

Select one of the following:

  • True
  • False

Explanation

Question 65 of 66

1

If you want to use the same guide on smart phones and on desktop/tablets, you need to create two version of the guide.

Select one of the following:

  • True
  • False

Explanation

Question 66 of 66

1

Customer integration data is stored in the Informatica Cloud Application.

Select one of the following:

  • True
  • False

Explanation

Previous
Check answer
Next