WGU D075 IT COMPREHENSIVE QUESTIONS AND
ANSWERS SET A+
✔✔Variety - ✔✔data from structured (accessing somehow) and unstructed areas in
various formats
✔✔Veracity - ✔✔trustworthiness Should rep what you believe they should, any
discrepancies within data that must be taken out and scrubbed to make worth wile and
valuable
✔✔Velocity - ✔✔how many data are presented that need to be stored or processed
over a given time period. EX: Streaming apps such as amazon web services
✔✔Data Mining (Data Discovery) - ✔✔The examination of huge sets of data to find
patterns and connections, hidden relationships and identify outliers.
✔✔Structured data - ✔✔Data that (1) are typically numeric or categorical; (2) can be
organized and formatted in a way that is easy for computers to read, organize, and
understand; and (3) can be inserted into a database in a seamless fashion.
✔✔unstructured data - ✔✔unorganized data that cannot be easily read or processed by
a computer because its not stored in rows or colums like traditional data tables
✔✔semi structured data - ✔✔In-between Structured and Unstructured data and can
possibly be converted into structured data but not without a lot of work
✔✔Data management process - ✔✔acquiring data, making sure the data is valid, then
storing and processing data into usable information
✔✔Extract - ✔✔Determine where the data resides then you can start ________. Data
often comes from CRM or ERP system
✔✔Transform - ✔✔Data is extracted they need to be normalized.
,✔✔Normalized data - ✔✔Organized into the fields and records of a relational database.
Reduces redundancy in storing data which saves space and helps ensure data that's
consistent
✔✔Load - ✔✔Once data is transformed and normalized they are ready to be transferred
into data warehouse or data mart
✔✔SQL (Structured Query Language) - ✔✔Programming language specifically for
querying and manipulating relational database. Few languages that works on almost
every brand of database
✔✔Tableau - ✔✔Tools for data output. Produces interactive data visualization products
focused on business intelligence
✔✔Data output - ✔✔output receipts, picking lists for the warehouse, or other
documents. queried from data tables with tools to assist business knowledge
✔✔Topic analytics - ✔✔Catalogs phrases of an organization's customer feedback into
relevant topics.
✔✔Text Analytics/Text Mining - ✔✔Searches through unstructured text data to look for
useful patterns. EX: FB searches to see if a customer is unsatisfied with
services/products
✔✔Business analytics - ✔✔makes connections between data organizations can try to
predict future trends that may give them a competitive advantage
✔✔Descriptive analytics - ✔✔baselines that other types of analytics are built upon.
Defines past data you already have that can be grouped into a significant piece.
✔✔Predictive Analytics - ✔✔reveal future patterns in a marketplace, especially trying to
predict the future by looking for data correlations. Uses both new and historical data to
forecast activity, behavior, and trends
✔✔Decision analytics - ✔✔builds on predictive analysis to make decisions about future
industries and marketplaces
✔✔Online Analytical Processing (OLAP) - ✔✔basic queries are running against the
database to gain insight into elementary data relations
✔✔validity check - ✔✔Having clean data starts when the database is created by
including database field (column) controls
, ✔✔Data mapping - ✔✔allows for connections between two systems. This connection
allows for data initially captured for one purpose to be translated and used for another
purpose. One system in a map is identified as the source while the other is the target.
EX: student id number
✔✔Primary Key - ✔✔A field (or group of fields) that uniquely identifies a given entity in a
table. EX: student id number
✔✔Foreign Key - ✔✔Field in a database table that provides a link between two tables in
a relational database
✔✔Schema - ✔✔layout of database that defines the tables, fields, and constraints, key
and integrity of the database. It is the reference of blueprint of the database.
✔✔Data level security - ✔✔businesses implement processes to protect the data from
getting stolen or tampered with
✔✔System-Level Security - ✔✔protecting the hardware that the database resides on
✔✔user-level security - ✔✔security starts with logon ids and passwords
✔✔cloud database - ✔✔allow access from anywhere one can connect to the internet
✔✔Generally Accepted Accounting Principles (GAAP) - ✔✔a set of accounting
standards that is used in the preparation, presenting and reporting.
✔✔Products - ✔✔goods and services a business produces and how they relate to
customers needs. Ex: warranties, guarantees and customer support
✔✔Placement - ✔✔how a product or service is delivered to a customer
✔✔search engine marketing (SEM) - ✔✔a type of web advertising whereby companies
pay for keywords that are used to catch consumers' attention while browsing a search
engine
✔✔research and development (R&D) - ✔✔brainstorm comes up with ideas and
directions for the business - enhances products and develop new products and services
that fit the mold of the corporation and will add to the bottom line
✔✔basic research - ✔✔determine weather any of it has a commercial application for the
business
✔✔applied research - ✔✔focused on developing a commercial product or process to
meet customer or industry requirements and needs.
ANSWERS SET A+
✔✔Variety - ✔✔data from structured (accessing somehow) and unstructed areas in
various formats
✔✔Veracity - ✔✔trustworthiness Should rep what you believe they should, any
discrepancies within data that must be taken out and scrubbed to make worth wile and
valuable
✔✔Velocity - ✔✔how many data are presented that need to be stored or processed
over a given time period. EX: Streaming apps such as amazon web services
✔✔Data Mining (Data Discovery) - ✔✔The examination of huge sets of data to find
patterns and connections, hidden relationships and identify outliers.
✔✔Structured data - ✔✔Data that (1) are typically numeric or categorical; (2) can be
organized and formatted in a way that is easy for computers to read, organize, and
understand; and (3) can be inserted into a database in a seamless fashion.
✔✔unstructured data - ✔✔unorganized data that cannot be easily read or processed by
a computer because its not stored in rows or colums like traditional data tables
✔✔semi structured data - ✔✔In-between Structured and Unstructured data and can
possibly be converted into structured data but not without a lot of work
✔✔Data management process - ✔✔acquiring data, making sure the data is valid, then
storing and processing data into usable information
✔✔Extract - ✔✔Determine where the data resides then you can start ________. Data
often comes from CRM or ERP system
✔✔Transform - ✔✔Data is extracted they need to be normalized.
,✔✔Normalized data - ✔✔Organized into the fields and records of a relational database.
Reduces redundancy in storing data which saves space and helps ensure data that's
consistent
✔✔Load - ✔✔Once data is transformed and normalized they are ready to be transferred
into data warehouse or data mart
✔✔SQL (Structured Query Language) - ✔✔Programming language specifically for
querying and manipulating relational database. Few languages that works on almost
every brand of database
✔✔Tableau - ✔✔Tools for data output. Produces interactive data visualization products
focused on business intelligence
✔✔Data output - ✔✔output receipts, picking lists for the warehouse, or other
documents. queried from data tables with tools to assist business knowledge
✔✔Topic analytics - ✔✔Catalogs phrases of an organization's customer feedback into
relevant topics.
✔✔Text Analytics/Text Mining - ✔✔Searches through unstructured text data to look for
useful patterns. EX: FB searches to see if a customer is unsatisfied with
services/products
✔✔Business analytics - ✔✔makes connections between data organizations can try to
predict future trends that may give them a competitive advantage
✔✔Descriptive analytics - ✔✔baselines that other types of analytics are built upon.
Defines past data you already have that can be grouped into a significant piece.
✔✔Predictive Analytics - ✔✔reveal future patterns in a marketplace, especially trying to
predict the future by looking for data correlations. Uses both new and historical data to
forecast activity, behavior, and trends
✔✔Decision analytics - ✔✔builds on predictive analysis to make decisions about future
industries and marketplaces
✔✔Online Analytical Processing (OLAP) - ✔✔basic queries are running against the
database to gain insight into elementary data relations
✔✔validity check - ✔✔Having clean data starts when the database is created by
including database field (column) controls
, ✔✔Data mapping - ✔✔allows for connections between two systems. This connection
allows for data initially captured for one purpose to be translated and used for another
purpose. One system in a map is identified as the source while the other is the target.
EX: student id number
✔✔Primary Key - ✔✔A field (or group of fields) that uniquely identifies a given entity in a
table. EX: student id number
✔✔Foreign Key - ✔✔Field in a database table that provides a link between two tables in
a relational database
✔✔Schema - ✔✔layout of database that defines the tables, fields, and constraints, key
and integrity of the database. It is the reference of blueprint of the database.
✔✔Data level security - ✔✔businesses implement processes to protect the data from
getting stolen or tampered with
✔✔System-Level Security - ✔✔protecting the hardware that the database resides on
✔✔user-level security - ✔✔security starts with logon ids and passwords
✔✔cloud database - ✔✔allow access from anywhere one can connect to the internet
✔✔Generally Accepted Accounting Principles (GAAP) - ✔✔a set of accounting
standards that is used in the preparation, presenting and reporting.
✔✔Products - ✔✔goods and services a business produces and how they relate to
customers needs. Ex: warranties, guarantees and customer support
✔✔Placement - ✔✔how a product or service is delivered to a customer
✔✔search engine marketing (SEM) - ✔✔a type of web advertising whereby companies
pay for keywords that are used to catch consumers' attention while browsing a search
engine
✔✔research and development (R&D) - ✔✔brainstorm comes up with ideas and
directions for the business - enhances products and develop new products and services
that fit the mold of the corporation and will add to the bottom line
✔✔basic research - ✔✔determine weather any of it has a commercial application for the
business
✔✔applied research - ✔✔focused on developing a commercial product or process to
meet customer or industry requirements and needs.
