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
