1. A CEO of a company wants to find a new and improved way to manage and extract business insights from large amounts of web- and sensor-generated data. Which of the following could they use to achieve this goal?  Big data
2. A data agent may be associated with multiple tenants.  False
3. A single tenant may have multiple data agents.  True
4. Browsing for the file when running an Integration task grabs the data from which of the following?  Source file
5. 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
6. Defined version or period parameters may be overridden at run time in which of the following? Check all that apply.  Integration Task
   
   Planning Loader
7. During the data agent install which of the following components is optional?  Script Engine
8. Each table in the staging area may have a different Data Import Mode defined.    True
9. 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
10. Fill in the blank: A _______________ column may be used to change data types or add calculations across columns in a staging table.  SQL
11. Fill in the blank: Data mappings are global and applied when multiple loaders use the same  Profile
12. Fill in the blank: Each spreadsheet tab/sheet displays as a _________________ in the staging area.   Table
13. Fill in the blank: Pentaho Kettle is used with the ______________ data source   Scripted.
14. Fill in the blank: The _______________ column performs a calculation over rows in a related table.  Subquery
15. Fill in the blank: The _______________ feature allows you to bulk add columns to a staging area table. (The answer is two words)   Manage Columns
16. Fill in the blank: The ______________________ holds imported data.  staging area
17. Fill in the blank: The _______________________ data source allows you to combine data from multiple tables from different data sources.   Table Group
18. For structural changes which require additional columns in a spreadsheet, add any new columns to the _____________ of existing columns.  Right
19. For structural changes which require additional rows in a spreadsheet, add any new rows ____________ existing rows.  Below
20. For users with Data Designer permission, data may be loaded manually using which of the following? Check the three (3) that apply.   Tasks in Component Library
    
    Loaders in Component Library
    
    Integration > Integration Tasks
21. How many instances of the Adaptive Data Agent Service Manager should be installed on any one machine?  1
22. How many joins may be added to a single table?  Unlimited
23. 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
24. In an entity relational model (ERD), what is each row in a table known as?  An entity occurrence
25. Launch permission for an Integration task may be granted to users with a specific role.  True
26. Multiple loaders may be added to a single integration task.  True
27. Multiple source tables may be defined in a single Planning loader.  False
28. Multiple SQL columns may be added to construct new data.  True
29. Once the data is loaded into Planning, the staging area tables are cleared.  False
30. Only columns bolded and marked with an asterisk are required to be mapped to a Planning element in the target sheet.  True
31. Performing a structure import updates the staging tables with the latest column names and data types from the external source system.  True
32. Publishing agent changes performs version control and therefore does not overwrite the existing script of the same name.    False
33. SQL column transformations are available only for the Spreadsheet and JDBC Database data sources   False
34. SQL filters in the staging area filter data from upload to the Adaptive Insights model.  False
35. Staging table column names must match the column names in the Pentaho transformation. True
36. The Distinct Rows option is used in combination with which of the following Advanced Filter options to hide duplicate rows?    Columns
37. The Preview loader output action can do all EXCEPT which of the following?  Loads data
38. The source spreadsheet may contain multiple date-type columns   True
39. The SQL filter in the staging area is used only to restrict rows from display.  True
40. To verify all accounts/levels/dimensions mapped successfully, change the Display filter to Mapped.  False
41. To which of the following accounts may data be loaded? Check all that apply.   Cube
    
    GL
42. 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
43. 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
44. Which of the following applications manages data agents on the local machine?  Agent service
45. Which of the following are available to specify HOW you import data into the selected table in the staging area.  Data Import Modes
46. Which of the following entity relationship (ER) connectivity statements is invalid?  A CUSTOMER gender is MALE or FEMALE
47. Which of the following features can be used to import a large number of dimension mappings created outside of the Adaptive Insights model?  Upload Dimension Mappings
48. Which of the following features may be used to visualize data in the staging area? Check all that apply.   Ascending sorts
    
    SQL Filters
49. Which of the following is a disadvantage of various database models?  System complexity
50. Which of the following is a fundamental data modeling component, helping ensure data integrity?  Constraint
51. Which of the following is a true statement regarding integration tasks? Check the three (3) that apply.   Other tasks may be included within a task
    
    An email notification may be sent upon the failure of the task
    
    Other users may be granted permission to edit the task
52. Which of the following is NOT a supported join? Full
53. Which of the following is not a valid business rule?  An invoice must be paid in a reasonable amount of time
54. Which of the following is NOT a valid business rule?  Data Import Filter
55. Which of the following is not a valid component of object-oriented data models?  Volume
56. Which of the following is NOT a valid SQL column type?  Expression
57. Which of the following is true of account/level/dimension mapping? Check all that apply.  Mappings may be uploaded
    
    Mappings may be downloaded
    
    Mappings may be deleted
58. Which of the following period parameter options is recommended when loading historical data?  Fixed
59. Which of the following requires manual configuration in the Adaptive Data Agent Service Manager?  None of the above
60. Which of the following role permissions is required to load data to an Actuals version? Check all that apply   Privileged Actuals Access
    
    Import Capabilities
61. Which of the following settings is optional for an on-premise data source connection?  Schema filters
62. 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
63. Which of the following technologies is not used in Big Data?  SQL
64. Which of the following two-dimensional structures is known as a relation?  Table
65. 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.  Eliminations
    
    Transactions
    
    Adjustments
66. Which option instructs the loader to run using staging area data rather than importing the data from the source system?  Bypass Data Import
67. Which table type is used with a scripted data source to hold the imported data   Scripted Table
68. Why is identifying and documenting business rules essential to database design?   It helps to standardize the company’s view of data.
69. You can use the New Account Mapping feature to create an account mapping before the source data is imported.   True

Other Links:

Statistics Quiz

Networking Quiz

See other websites for quiz:

Check on QUIZLET

Check on CHEGG