ITEC79 (Ma'am Karen)

Question 1

are powerful tools in which you can easily view,
add, or modify data that is stored in the Access database.

Answer 1

Forms

Question 2

can be used as an organizational tool for the form, such
as creating different areas on the form.

Answer 2

Lines

Question 3

focused on generating a business benefit.

the intent is to generate new or additional revenue where it is
relatively easy to calculate the ROI(Return on Investment).

Answer 3

Business-Centric

Question 4

often seek to
improve a process or provide an analytical or data
capability that previously didn’t exist.

These projects provide infrastructure cost savings and an
indirect business benefit and are more difficult to calculate
ROI.

Answer 4

IT-centric

Question 5

Ingest (obtain, import, and process) data from different sources
at various expectancies (for example, including real-time), in an
efficient usable manner leveraging pre-built connectors to
simplify the data ingestion process.

Answer 5

Data Ingestion

Question 6

The end-to-end tools and processes used to integrate, govern,
secure, and administer the transformation of source data into
data that is “fit-for purpose” and in compliance with corporate
and regulatory policies.

Answer 6

Data Management

Question 7

Combine data from different sources using a variety of
transformations such as filtering, joining, sorting, and
aggregating while establishing relationships within the datasets
to provide a unified view.

Answer 7

Data Integration

Question 8

Clean up data to ensure it’s fit for its intended purposes to
appropriately address incomplete or irrelevant entries, eliminate
duplications, standardize and normalize data, and ensure data
exceptions are handled properly, preferably in an automated
and repeatable fashion.

Answer 8

Data Quality:

Question 9

A dedicated repository to collect, manage, and report on data
assets, their relationships, and the processes used to integrate,
govern, and secure those assets.

Answer 9

Metadata Catalog

Question 10

Enforce and ensure the accuracy and accountability of the
critical data in an organization to provide a common point of
reference and truth.

Answer 10

Master Data Management

Question 11

De-identify, obfuscate, or otherwise obscure sensitive data,
such as credit card numbers, so relational integrity is
maintained, yet key sensitive values aren’t accessible.

Answer 11

Data Masking

Question 12

Analyze and assess the risk of a data security breach by
identifying the location and proliferation, and tracking the usage
of sensitive data.

Answer 12

Data Security Analytics

Question 13

Collect, process, and analyze multilatency data (including real-
time) to provide event-based insights and alerts within a time-
interval of maximum business impact (often in real-time or near real-time).

Answer 13

Streaming Analytics

Question 14

Apply analytical formulas and algorithms to datasets to answer
questions based on big data; these algorithms are employed by
data experts to test hypotheses and validate analytic models
used to improve business outcomes.

Answer 14

Big Data Analytics

Question 15

Collect and store all types of data as originally sourced for use
as a live archive, data exploration, and an operational data
store for pre-processing and preparing data for big data
analytics.

Answer 15

Data Lakes

Question 16

Collect and store structured data into a large repository for the
purpose of applying analytics and generating reports.

Answer 16

Data Warehouses

Question 17

A collection of organized data, information and
records.

• Documents are usually organized in chronological
  order for easier access, retrieval and use.

Answer 17

DATABASE

Question 18

defines how data is organized in a
database. Also determine the set of operations that can be
performed on a data.

Answer 18

Structural model

Question 19

commonly used structural database
model.

Answer 19

Relational model

Question 20

Also called structured data in which record of
information arranged in uniform format.
Databases that usually stored information with
similar entities.

Answer 20

Structured Database

Question 21

A loose collection of information.
A collection of documents in the computer from
several programs.

Answer 21

Free-form Database

Question 22

A Dynamic Database that is used by any
organization in its day-to-day operation.
Used to collect, maintain, modify and delete data.

Answer 22

Operational Database:

Question 23

A Static Database where data is rarely modified.
Used to store and track historical data to make long
term projections and analysis.

Answer 23

Analytical Database:

Question 24

is designed to create, maintain, manipulate, modify
and delete information in relational database

Answer 24

Relational Database Management System (RDBMS)

Question 25

a table that establishes a connection between
two or more table

Answer 25

Linking Table

Question 26

• is all about obtaining the artifacts that contain the
  input data from a variety of sources, extracting the
  data from the artifacts, and converting it into
  representations suitable for further processing.

Answer 26

DATA ACQUISITION

Question 27

• The three main sources of data:

Answer 27

Internet (namely, the World Wide Web)
Databases
local files (possibly previously downloaded by hand
or using additional software)

Question 28

• is the process of searching and analyzing a large
  batch of raw data in order to identify patterns and
  extract useful information.

Companies use this software to learn more
about their customers. It can help them to develop
more effective marketing strategies, increase sales,
and decrease costs.

Answer 28

DATA MINING

Question 29

refers to the process of combining data from
multiple sources to provide a unified view. In modern systems, understanding these
concepts is crucial as organizations strive to make the most of their
data resources. This presentation will explore essential aspects of
data integration and interoperability, highlighting their importance in
today’s digital landscape.

Answer 29

Data integration

Question 30

is vital for organizations as it enhances decision-
making, boosts productivity, and fosters collaboration. By integrating

data from various sources, businesses can generate comprehensive
reports, identify trends, and make informed decisions. Additionally,
seamless data workflows prevent siloed information, allowing
organizations to operate more efficiently. Companies investing in
data integration see noticeable improvements in operational agility
and customer satisfaction.

Answer 30

Data integration

Question 31

include databases, APIs, flat files, and cloud
services. Identifying all relevant data sources is crucial for comprehensive
integration that meets organizational needs.

Answer 31

Data Sources

Question 32

is the process of converting
data into a suitable format for analysis. This can involve cleansing,
enriching, and structuring data to ensure consistency and usability.

Answer 32

Data Transformation

Question 33

solutions can include data warehouses or
lakes, where integrated data is consolidated. Such environments must be
scalable and secure, allowing for efficient retrieval and analysis.

Answer 33

Data Storage

Question 34

refers to the ability of different systems, devices,
and applications to work together seamlessly. This compatibility
is essential for efficient data exchange and process
synchronization.

Answer 34

Interoperability

Question 35

is a traditional method that extracts data from various sources,
transforms it into a desired format, and loads it into a target database.
This process is crucial for data warehousing.

Answer 35

ETL (Extract, Transform, Load)

Question 36

allows real-time access to integrated data without
moving it. This technique is beneficial for quick decision-making and
reducing data duplication across systems.

Answer 36

Data virtualization

Question 38

on the
other hand, describes the ability of different systems to work together
and share data effectively.

Answer 38

Interoperability