Acronyms
DB
What is a Database?
•Data availability
•System performance
•Database performance
•Database security
•Maintains database backups
What is DBA Team?
_____ is a programming language for storing and processing information in a relational database.
What is Structured query language (SQL)?
This type of key defines and aligns the business process and data flow relationships.
What are Business keys?
I can get a paycheck without an Informatica integration.
What is false?
OLAP and OLTP
What is Online Analytical Processing and Online Transaction Processing?
•Webservices and API
•WWA loads
•Centralize multiple application integrations
•Manages data warehouses
•commonly performs ETL processing
What is Integrations Team?
_____ is a SQL command that specifies which columns appear in the output.
What is SELECT?
This pair of tables uses keys to identify their unique relationships.
What is a Parent and child Table?
An Integration process most commonly performs ETL processing.
What is True?
IICS
What is Informatica Intelligent Cloud Services?
•SAP Business Objects administration
•Informatica administration
•HRMS administration
•ServiceNow administration
What is Platforms Team?
______ is a database object that contains data in a row-and-column format similar to a spreadsheet.
What is a Table?
Two common data warehouse schemas.
What is star schema and snowflake schema?
There are 9 WWA Universes.
What is False? There are 7 WWA Universes.
ACID
What is Atomicity, Consistency, Isolation, and durability?
•Creates and troubleshoots reports in PowerBI
•Create and troubleshoots reports in Webi
•Create and troubleshoots reports in SSRS
What is Reporting Team?
______ is a field that will uniquely identify each row in a table.
What is a Primary Key?
Ultimate sponsor and approving body for enterprise data architecture.
What is the Data Governance Council?
The bulk of Integration processing occurs between 7 am – 3 pm.
What is False? The correct time is 7 PM - 3 AM.
ODBC
What is Open Database Connectivity?
•Maintains data models
•Designs database solutions
•Defines requirements from business
What is Data Architecture Team?
_____ is the process of preserving the operational state, architecture, and stored data of a database.
What is a Database Backup?
This gives classification to data within a given data set and gives business classification and context to data within a given system store.
What is the Taxonomy?
Data sources for the Integration team include HRMS and AFRS.
What is True? They also use other data sources like Active Directory, B2GNow_Certification_Management, HR Accidents, and OFM Facilities.