Cloud Data Integrations Specialist

Description

Quiz on Cloud Data Integrations Specialist, created by Carolyn Kinnear on 24/01/2019.
Carolyn Kinnear
Quiz by Carolyn Kinnear, updated more than 1 year ago
Carolyn Kinnear
Created by Carolyn Kinnear over 6 years ago
67
0
1 2 3 4 5 (1)

Resource summary

Question 1

Question
What information is contained in the Audit Log?
Answer
  • Field-level mapping changes.
  • User Logins.
  • Both User Logins and Create/Update/Delete operation on objects.
  • Informatica Cloud Task Errors.

Question 2

Question
Where are the detailed error logs for tasks located?
Answer
  • \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.

Question 3

Question
Configuring object-level permissions allow you to restrict or expand the permissions the user group has for the object.
Answer
  • True
  • False

Question 4

Question
What is the purpose of the Cloud Connector Toolkit?
Answer
  • 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

Question 5

Question
Which of the following could be used to invoke ICS REST API?
Answer
  • Java
  • force.com
  • JavaScript
  • cUrl
  • All of the above

Question 6

Question
Where can a user define parameters for use in Data Synchronization tasks?
Answer
  • 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

Question 7

Question
What format is used in a parameter file for Data Synchronization tasks?
Answer
  • parameter=value
  • $$parameter=value
  • $value=parameter
  • parameter==value

Question 8

Question
If you make changes to an embedded guide, the changes will be propagated to all guides that use the embedded guide.
Answer
  • True
  • False

Question 9

Question
The embedded guide and the embedding guide must both be published in order to work together.
Answer
  • True
  • False

Question 10

Question
Connections can be created for which of the following?
Answer
  • 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.

Question 11

Question
A Secure Agent is ___.
Answer
  • 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

Question 12

Question
In an assignment step, if you want the input fields to be populated with a numeric value, select a data source of:
Answer
  • Formula
  • Query
  • Content

Question 13

Question
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?
Answer
  • 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.

Question 14

Question
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:
Answer
  • 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).

Question 15

Question
To include all incoming fields from an upstream transformation except those with dates, what should you do?
Answer
  • 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.

Question 16

Question
Which of the following is not a valid incoming field rule type?
Answer
  • Choose fields by data type.
  • "All Fields"
  • Choose fields by Origin
  • Choose fields by field names

Question 17

Question
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.
Answer
  • True
  • False

Question 18

Question
Which of the following could you use a field expression to do?
Answer
  • 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

Question 19

Question
How are data filters within Data Synchronization tasks used?
Answer
  • 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.

Question 20

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

Question 21

Question
Which of the following are supported pre-processing or post-processing commands?
Answer
  • SQL Command
  • Unix Command
  • Valid DOS or batch file

Question 22

Question
Which of the following can be used to write to multiple targets?
Answer
  • Mapplets
  • Mappings
  • Connections.

Question 23

Question
When adding parameters to a Cloud Mapping Designer mapping, it is a good idea to add them:
Answer
  • 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.

Question 24

Question
Active transformations do not change the number of rows that pass to the next step of the mapping.
Answer
  • True
  • False

Question 25

Question
What is the purpose of the field mapping in the Target transformation?
Answer
  • 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

Question 26

Question
Which transformation is used to define how data from 2 different sources can be combined?
Answer
  • Aggregator
  • Filter
  • Joiner
  • Expression

Question 27

Question
Which 'passive' transformation would you use to create a new field?
Answer
  • Filter
  • Joiner
  • Expression

Question 28

Question
How do you specify the set of fields that flow from one shape in the mapping to the next?
Answer
  • 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

Question 29

Question
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?
Answer
  • Normalizer
  • Lookup
  • Filter
  • Aggregator

Question 30

Question
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?
Answer
  • 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.

Question 31

Question
Once a MCT is defined, any further changes to the mapping will not affect the mapping configuration task until:
Answer
  • The mapping is deployed.
  • The mapping is Saved.
  • The mapping is Deleted.
  • The mapping is executed.

Question 32

Question
Which of the following is an Active transformation?
Answer
  • Expression
  • Filter
  • Aggregator
  • None of the above

Question 33

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

Question 34

Question
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?
Answer
  • Aggregator
  • Expression
  • Filter
  • Lookup

Question 35

Question
Which of these statements is true?
Answer
  • 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.

Question 36

Question
Sources and Targets in a mapping can be __.
Answer
  • Relational databases
  • Cloud applications
  • Files
  • Any of the above.

Question 37

Question
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?
Answer
  • 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.

Question 38

Question
Name the feature used to sequentially run tasks in a specified order
Answer
  • PowerCenter Service
  • Workflows
  • Task Flows
  • Plug-ins

Question 39

Question
A Related Object is an object that is related to another object based on a relationship defined in Informatica Cloud.
Answer
  • True
  • False

Question 40

Question
Which operation would be best to use when synchronizing data between two systems?
Answer
  • Insert
  • Update
  • Upsert

Question 41

Question
Where can you find Informatica Cloud log files?
Answer
  • 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

Question 42

Question
Incremental Processing is built into Data Replication for all source types.
Answer
  • True
  • False

Question 43

Question
What source data types are valid for use in a Data Replication Service?
Answer
  • Salesforce data
  • Salesforce and database data
  • Salesforce, flat files, and database data
  • Database and flatfile data

Question 44

Question
Where does the data get processed?
Answer
  • In the Informatica Cloud servers
  • In the Informatica Cloud Secure Agent (typically behind customer firewall)
  • In the informatica cloud repository

Question 45

Question
How does the Secure Agent communicate with Informatica Cloud?
Answer
  • 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

Question 46

Question
Which statement best describes the Secure Agent?
Answer
  • 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.

Question 47

Question
Within the Guide Designer, you can view the following report(s) on guide usage:
Answer
  • Outcome Chart
  • Detailed Activity
  • Current Activity

Question 48

Question
By default, only Admin profiles have access to the Guide Designer tab:
Answer
  • True
  • False

Question 49

Question
Guide execution details are only available for a guide if the Guide Execution Logging property is enabled
Answer
  • True
  • False

Question 50

Question
When you view the Outcome Chart for a guide, it displays data about the end of guide outcomes:
Answer
  • for all time
  • for a customizable period of time
  • for today

Question 51

Question
Service connectors can be used to access (pick 2)
Answer
  • SOAP-based web services
  • JMS queues containing XML
  • REST services using JSON

Question 52

Question
A data decision step almost always has an Otherwise answer
Answer
  • True
  • False

Question 53

Question
Data decision steps can perform tests for which of the following?
Answer
  • Text values
  • Numeric values
  • Date values
  • All of the above

Question 54

Question
Customization of the guide themes is possible in the following ways:
Answer
  • Using an HTML WYSIWIG editor
  • Using CSS
  • On desktop/tablets and smart phones

Question 55

Question
In order to install Real Time in your Salesforce org, you must:
Answer
  • Have the managed package link
  • Have the Professional edition of Salesforce
  • Be a system administrator

Question 56

Question
Screen steps are typically used to ___.
Answer
  • Present different answers.
  • Display instructions.
  • Show data to the user and to have the user update data.
  • Accomplish tasks automatically.

Question 57

Question
What types of Objects can a Screenflow guide read/write?
Answer
  • Standard Objects
  • Custom Objects
  • Junction Objects
  • All of the above

Question 58

Question
What happens in a screenflow guide if there is a validation rule defined in Salesforce?
Answer
  • 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.

Question 59

Question
If you want a guide to perform a hand-off from one person to another, use a milestone step.
Answer
  • True
  • False

Question 60

Question
If you want to prevent a user from stepping backwards in a guide, be sure to disable the following option(s).
Answer
  • Allow User to Go Back on Milestone Step
  • Allow Restart
  • Show Guide Only When

Question 61

Question
With a Screenflow Guide, which of the following options are available to make fields required?
Answer
  • 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.

Question 62

Question
How do you make a Screenflow Guide launch from a button on a Salesforce page?
Answer
  • That is not supported.
  • Modify an existing Visualforce page and link it to the button.
  • Write Apex code.

Question 63

Question
With mobile guides, we recommend setting the Applies To:
Answer
  • Home
  • Any Object
  • Event
  • Content

Question 64

Question
Without Real Time Apps in Salesforce1, users are limited to single-step actions.
Answer
  • True
  • False

Question 65

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

Question 66

Question
Customer integration data is stored in the Informatica Cloud Application.
Answer
  • True
  • False
Show full summary Hide full summary

0 comments

There are no comments, be the first and leave one below:

Similar

AS Psychology - Research Methods
kirstygribbin
Chemistry 3 Extracting Metals Core GCSE
Chloe Roberts
English Language Techniques
Zakiya Tabassum
Spanish Subjunctive
MrAbels
Calculus I
GraceEChem
P1 quiz
I M Wilson
Camera Angles
saradevine97
Globalisation Case Studies
annie
Plato's philosophy
Sumahlor
Flame tests
Joshua Rees