Cloud DI Cert Exam - 101 Quizzes

"101.07.03 Saved Queries can be used to perform which of the following? Select one or more: a. Complicated join of multiple tables b. Aggregations in SQL c. Limit or qualify the data that is being pulled from a source"

"a. Complicated join of multiple tables b. Aggregations in SQL"

"101.04.02 Where can you find Informatica Cloud log files? Select one or more: a. Error rows preview and job log file can be accessed from the activity log and job details pages in Informatica Cloud b. On the agent machine, in the Secure Agent installation directory, under rdtmDir c. By logging into the IC Repository"

"a. Error rows preview and job log file can be accessed from the activity log and job details pages in Informatica Cloud b. On the agent machine, in the Secure Agent installation directory, under rdtmDir"

"101.06.03 Which of the following could you use a field expression to do? Select one or more: a. Insert a value into a target field for all records b. Mapping multiple source fields to a single target field c. Convert date to the correct format for target field d. Trimming blank spaces from a source field"

"a. Insert a value into a target field for all records b. Mapping multiple source fields to a single target field c. Convert date to the correct format for target field d. Trimming blank spaces from a source field (all are correct)"

"101.09.01 Data replication tasks can be used for: Select one or more: a. Offline Reporting b. Data back-up c. Synchronizing data between systems"

"a. Offline Reporting b. Data back-up"

"101.13.03 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: a. Save and deploy to mapping configuration tasks. b. Import the new mapping from PowerCenter. c. Save updates as a new mapping (retaining the previous version of the mapping)."

"a. Save and deploy to mapping configuration tasks. c. Save updates as a new mapping (retaining the previous version of the mapping)."

"101.02.02 Which of the following are stored in the Informatica Cloud Repository? Select one or more: a. Source and Target Metadata b. Saved Queries c. Schedules"

"a. Source and Target Metadata c. Schedules"

"101.14.02 Which of the following is a supported pre- or post-processing commands? Select one or more: a. Valid DOS or batch file b. Unix Command c. SQL Command"

"a. Valid DOS or batch file b. Unix Command c. SQL Command"

"101.15.02 Which of the following explains why you might want to change the Salesforce target batch size? Select one or more: a. You want to avoid writing duplicate data from your source. b. You are loading a million or more rows of data from your source. c. You are using APEX triggers which require that you load one record at a time to function properly."

"a. You want to avoid writing duplicate data from your source. c. You are using APEX triggers which require that you load one record at a time to function properly."

"101.17.01 Which of the following might be a reason your company would use the Contact Validation App in Informatica Cloud? Select one or more: a. Your company sends direct mail marketing pieces. b. Your company purchases lead lists from tradeshows. c. Your company uses the Territory Management feature in Salesforce."

"a. Your company sends direct mail marketing pieces. b. Your company purchases lead lists from tradeshows. c. Your company uses the Territory Management feature in Salesforce."

"101.13.01 Mapping Configuration Tasks allow you to process data based on the data flow logic defined in: Select one or more: a. Mapplets b. Mappings c. Integration Templates"

"b. Mappings c. Integration Templates"

"101.16.02 Data Masking can be used in which of the following scenarios? Select one or more: a. SQL Server source data loaded and masked into Salesforce target b. Oracle data masked in place c. Salesforce source data loaded and masked into separate Salesforce target"

"b. Oracle data masked in place c. Salesforce source data loaded and masked into separate Salesforce target"

"101.07.02 Muliple object source type can be used with the following: Select one or more: a. Flat files b. Salesforce objects c. Database tables"

"b. Salesforce objects c. Database tables"

"101.07.04 Which of the following is/are best practices for using Saved Queries? Select one or more: a. Use the SQL COUNT function b. Use a SELECT statement c. Do not use conversion functions (like TO_CHAR, etc)"

"b. Use a SELECT statement c. Do not use conversion functions (like TO_CHAR, etc)"

"101.02.01 Where does the data get processed? a. In the Informatica Cloud servers b. In the Informatica Cloud Repository c. In the Informatica Cloud Secure Agent (behind customer firewall)"

"c. In the Informatica Cloud Secure Agent (behind customer firewall)"

"101.12.01 It is best practice to handle naming conflicts in a mapping as close to the target as possible. (T/F)"

FALSE

101.01.03 Views marked as private can be accessed by your user and admin users only. (T/F)

FALSE

101.07.01 Data from multiple source Connections can be combined using multiple object source. (T/F)

FALSE

101.09.02 Incremental Processing is built into Data Replication for all source types. (T/F)

FALSE

101.11.03 Active transformations do not change the number of rows that pass to the next step of the mapping. (T/F)

FALSE

101.14.03 If pre- or post-processing command(s) fails, your task will complete successfully. (T/F)

FALSE

101.17.02 Running a Contact Validation task will update a source database with corrected/normalized data based on parameters you specify in the task. (T/F)

FALSE

101.05.02 A Related Object is an object that is related to another object based on a relationship defined in Informatica Cloud. (T/F)

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

"101.11.02 It is recommended that you follow the Velocity Methodology to name the elements of a mapping. (T/F)"

TRUE

101.01.01 Informatica Cloud allows business users to integrate data across both cloud-based applications and on-premise applications and databases. (T/F)

TRUE

101.03.03 A Flat File connection points to a single folder/directory. (T/F)

TRUE

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

TRUE

101.16.01 The Data Masking application masks the sensitive columns in source data with realistic test data for non-production environments. (T/F)

TRUE

101.18.02 Configuring object-level permissions allows you to restrict or expand the permissions the user group has for the object. (T/F)

TRUE

"101.02.04 How does the Secure Agent communicate with Informatica Cloud? Select one: a. All communication is outbound through HTTPS protocol (port 443) b. There is no communication between the secure agent and Informatica Cloud c. Communication is initiated over telnet"

a. All communication is outbound through HTTPS protocol (port 443)

"101.11.04 It is recommended that the Mapping Designer be used with which browser? Select one: a. Chrome b. IE version 8 c. Firefox"

a. Chrome

"101.17.03 If you want to validate shipping and billing address fields, what is the best method for setting up the Contact Validation task? Select one: a. Create two Contact Validation tasks - one for each set of address fields. b. Check the multiple source object option. c. Map the shipping and billing address fields separately."

a. Create two Contact Validation tasks - one for each set of address fields.

"101.01.02 Which Informatica Cloud application is best to use for performing regular backups of data? a. Data Replication b. Data Sync c. Mapping Configuration"

a. Data Replication

"101.12.03 Which transformation type would you use to create a new field, performing non-aggregate calculations? Select one: a. Expression b. Filter c. Joiner"

a. Expression

"101.15.01 Which method is used to achieve real time integration when Salesforce is the integration source? Select one: a. Salesforce Outbound Messaging b. Salesforce Trigger c. Third Party Scheduler"

a. Salesforce Outbound Messaging

"101.06.01 You want to load account records from a SQL Server source where 'BillingState' = NY AND 'Annual Revenue' >= 10000000. Should you use a simple or advanced filter to do this? Select one: a. Simple b. Advanced"

a. Simple

"101.08.01 You have a child object, for example, a contact that belongs to an Account in Salesforce but youI don't have the external id to match it up to. You do have the account name on the incoming contact record so you can match that up to the account name on the account record in Salesforce. What do you need to do in the Data Synchronization Wizard to match those values together? Select one: a. 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. b. On Step 5 of the Data Synchronization Wizard use the lookup function to match the records and return the Salesforce Id field. c. 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."

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

"101.14.01 Where are parameter files located that are used by the Data Synchronization Wizard? Select one: a. On the Informatica Cloud under the Configuration tab b. On the Informatica Secure Agent machine under the userparameters directory c. The parameters are passed in by the developer at run time"

b. On the Informatica Secure Agent machine under the userparameters directory

"101.18.03 Which of the following objects cannot be migrated from one Informatica Cloud org to another? Select one: a. Connections b. Schedules c. Mappings"

b. Schedules

"101.16.03 Which of the following masking rules use a set of dictionary files located in the agent installation directory? Select one: a. Key Masking b. Substitution Masking c. Random Masking"

b. Substitution Masking

"101.10.01 What is the smallest increment of time allowed for creating a schedule in Informatica Cloud to run jobs automatically? Select one: a. 1 minute b. 10 minutes c. 5 minutes"

c. 5 minutes

"101.13.02 When adding parameters to a mapping, it is a good idea to add them: Select one: a. In the mapping configuration task. b. During the initial configuration of the mapping. c. After the mapping has been configured and tested with specified objects or filters, then parameters can be added to replace those objects or filters."

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

"101.12.02 To include all incoming fields from an upstream transformation except those with dates, what should you do? Select one: a. Configure a simple filter condition to exclude fields with data type of Date/Time. b. Delete all of the date fields from the source. c. 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."

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

"101.09.03 Which of the following is NOT a function available from the Data Replication tasks page? Select one: a. Create Target b. Reset Target c. Download Mapping XML"

c. Download Mapping XML

"101.03.02 What information is required in order to access Salesforce via their API? (select best answer) Select one: a. Trusted IP Range b. Security Token c. Either Security Token or Trusted IP Range"

c. Either Security Token or Trusted IP Range

"101.03.01 Which of the following lists includes three types of Native connectors? Select one: a. Salesforce, FTP/SFTP, Netsuite b. MS Dynamics CRM, Amazon Redshift, Zuora c. Flat File, SAP, Web Service"

c. Flat File, SAP, Web Service

"101.06.02 Filtering on Informatica Cloud system variables $LastRunDate or $LastRunTime is referred to as which of the following? a. Date-Based Filtering b. Pre-Processing Command c. Incremental Processing"

c. Incremental Processing

"101.02.03 Where do you enter proxy server settings? Select one: a. Organization settings page b. Agent Log File c. Informatica Cloud Agent Console"

c. Informatica Cloud Agent Console

"101.08.02 You have a data synchronization task that is performing a lookup on the Salesforce account object to return the Salesforce Id and match contacts to their correct account records, but that task is running really slowly. Why might that be and what can you do to speed up the task? Select one: a. Run the task off hours so that performance is not impacted by normal intraday processing. b. Informatica Cloud uses one API call per lookup which is expensive and slows the process down. Create smaller source files and run more frequent jobs to increase performance. c. Informatica Cloud uses one API call per lookup which is expensive and slows the process down. To increase performance, create a Data Replication task that extracts the Salesforce ID and the lookup value (Name for example and the Salesforce ID for that record) into a file or database table and use this in lookup function."

c. Informatica Cloud uses one API call per lookup which is expensive and slows the process down. To increase performance, create a Data Replication task that extracts the Salesforce ID and the lookup value (Name for example and the Salesforce ID for that record) into a file or database table and use this in lookup function.

"101.11.01 Which of the following can be used to write to multiple targets? Select one: a. Mapplets b. Connections c. Mappings"

c. Mappings

"101.18.01 Informatica Cloud users must be assigned which of the following? Select one: a. User Group b. Permission c. Role"

c. Role

"101.05.01 When using the Delete operation in a task with a Salesforce target, you should use which of the following? Select one: a. Foreign Key b. External ID c. Salesforce ID"

c. Salesforce ID

"101.10.02 Name the Informatica Cloud feature used to sequentially run tasks in a specified order. Select one: a. Work Flows b. Templates c. Task Flows"

c. Task Flows

"101.04.01 Which operation would be best to use when synchronizing data between two systems? Select one: a. Update b. Insert c. Upsert"

c. Upsert