Integration Framework Exam Review

Launch permission for an Integration task may be granted to users with a specific role.

True

Multiple SQL columns may be added to construct new data.

True

Multiple loaders may be added to a single integration task.

True

Only columns bolded and marked with an asterisk are required to be mapped to a Planning element in the target sheet.

True

Performing a structure import updates the staging tables with the latest column names and data types from the external source system.

True

Staging table column names must match the column names in the Pentaho transformation.

True

The SQL filter in the staging area is used only to restrict rows from display.

True

The source spreadsheet may contain multiple date-type columns.

True

You can use the New Account Mapping feature to create an account mapping before the source data is imported.

True

Which of the following is true of account/level/dimension mapping? Check all that apply.

- Mappings may be uploaded - Mappings may be downloaded

Data agents are required for which of the following source systems? Check the three (3) that apply.

- Microsoft Dynamics GP - Excel spreadsheet via a Scripted data source - JDBC Database data source

Which option instructs the loader to run using staging area data rather than importing the data from the source system?

Bypass Data Import

To verify all accounts/levels/dimensions mapped successfully, change the Display filter to Mapped.

False

To which of the following accounts may data be loaded? Check all that apply.

- Cube - GL

When an actuals import into a standard sheet is defined, data in which of the following may be erased before the loader loads the data from the import into Planning? Check the three (3) that apply.

- GL accounts - Custom accounts - Cell notes

For users with Data Designer permission, data may be loaded manually using which of the following? Check the three (3) that apply.

- Integration > Import Data - Tasks in Component Library - Loaders in Component Library

Which of the following actions could you perform if data from multiple tables in a single data source needs to be loaded? Check the two (2) that apply.

- Join the data - Create multiple loaders

Which of the following role permissions is required to load data to an Actuals version? Check all that apply.

- Privileged Actuals Access - Import Capabilities

Which of the following statements is true of business rules? Check the two (2) that apply.

- SQL filters may be applied on any column in the selected staging table - Only alpha-numeric and some special characters are allowed for Skip Accounts

How many instances of the Adaptive Data Agent Service Manager should be installed on any one machine?

1

Which of the following is the default number of rows displayed in the staging area?

100

Which of the following applications manages data agents on the local machine?

Agent service

For structural changes which require additional rows in a spreadsheet, add any new rows ____________ existing rows.

Below

The Distinct Rows option is used in combination with which of the following Advanced Filter options to hide duplicate rows?

Columns

Where is the Pentaho transformation file stored on the Adaptive Integration Framework server?

Data Agent

Which of the following is NOT a valid business rule?

Data Import Filter

Which of the following are available to specify HOW you import data into the selected table in the staging area.

Data Import Modes

Fill in the blank: The _______________ feature allows you to bulk add columns to a staging area table. (The answer is two words)

Data Import? - NOT SURE

A data agent may be associated with multiple tenants.

False

Each time data in the staging area is updated, transformations must be again be defined and applied.

False

Multiple source tables may be defined in a single Planning loader.

False

Once the data is loaded into Planning, the staging area tables are cleared.

False

Only data from the first tab in the source spreadsheet is imported into the staging area.

False

Publishing agent changes performs version control and therefore does not overwrite the existing script of the same name.

False

Which of the following period parameter options is recommended when loading historical data?

Fixed

For users without Data Designer permission, data may be loaded manually using which of the following?

Integration > Integration Tasks

Fill in the blank: _______________ functionality may be used to combine data from multiple tables within a single data source. (The answer is two words)

Join Table

Browsing for the file when running an Integration task grabs the data from which of the following?

Loader

The Preview loader output action can do all EXCEPT which of the following?

Loads data

Which of the following requires manual configuration in the Adaptive Data Agent Service Manager?

None of the above

Fill in the blank: A ___________ in a Planning loader contains account, level and dimension value mappings.

Profile - NOT SURE

For structural changes which require additional columns in a spreadsheet, add any new columns to the _____________ of existing columns.

Right

Fill in the blank: A _______________ column may be used to change data types or add calculations across columns in a staging table.

SQL

Which of the following settings is optional for an on-premise data source connection?

Schema filters - NOT SURE

During the data agent install which of the following components is optional?

Script Engine

Fill in the blank: Pentaho Kettle is used with the ______________ data source.

Scripted

Which table type is used with a scripted data source to hold the imported data?

Scripted Table

For which of the following data sources may the Convert Column type feature be used to convert non-SQL type columns?

Spreadsheet

Fill in the blank: The ______________________ holds imported data.

Staging area

Fill in the blank: Data mappings are global and applied when multiple loaders use the same ______________.

Structure

Fill in the blank: The _______________ column performs a calculation over rows in a related table.

Subquery

Fill in the blank: Each spreadsheet tab/sheet displays as a _________________ in the staging area.

Table

If data in the source table relates to time periods outside of the defined period parameter in the loader, which of the following statements is true?

The data will not load

Which of the following statements is true regarding the format of a spreadsheet?

The supported structure is for time periods to be included in a single column

A single tenant may have multiple data agents.

True

Business rules in the Planning loader are optional.

True

Each table in the staging area may have a different Data Import Mode defined.

True

Which of the following types of data can be loaded to the Adaptive Insights Planning model with a Planning loader? Check the three (3) that apply.

Try this first: - Eliminations - Transactions - Adjustments IF THAT IS INCORRECT, THEN TRY: Transactions, adjustments, & metadata

How many joins may be added to a single table?

Unlimited

Which of the following is NOT a Log level selection?

Warning