WorksheetsAEIC 418 - Data Warehousing and Management - Midterm
Total questions: 60
Worksheet time: 52mins
Data Warehouse is a subject-oriented collection of data.
True
False
Database is an application-oriented collection of data.
True
False
Normalization is the technique of dividing the data into multiple tables to reduce data redundancy and inconsistency and to achieve data integrity.
True
False
Denormalization is the technique of combining the data into a single table to make data retrieval faster.
True
False
A data warehouse is designed to record data.
True
False
A database is designed to analyze data.
True
False
Object-Relational data is represented in the form of objects.
True
False
Object-Oriented enables the user to create, update, administer, and interact with a relational database.
True
False
Structured data is quantitative.
True
False
Unstructured data is qualitative.
True
False
Full extraction means that all data are directly extracted from the source and there is no need to track changes to the data source.
True
False
Incremental extraction means that data extracted must record a timestamp and there is a need to keep track of changes to the data source.
True
False
Online extraction means that data is staged explicitly outside the original source rather than being taken straight from it.
True
False
Offline extraction lets users extract data directly from the original source.
True
False
OLTP provides summarized and consolidated data.
True
False
OLAP provides primitive and highly detailed data.
True
False
A table is a collection of related data entries, and it consists of columns and rows.
True
False
A record, also called a row, is each individual entry that exists in a table.
True
False
A query is a request for data or information from a database table or combination of tables.
True
False
A column is a vertical entity in a table that contains all information associated with a specific field in a table.
True
False
Every table is broken up into smaller entities called cells.
True
False
A cell is a column in a table that is designed to maintain specific information about every record in the table.
True
False
A column is a horizontal entity in a table.
True
False
All SQL manipulation syntax is the same for all SQL database programs and extensions.
True
False
A Data Warehouse is considered a single version of truth for the organization for the decision-making and forecasting process. Which of the following is its example?
The company enabled online transactional processing for easy access to recent data.
To ensure that there will be data for future use, all attachments sent by customers through email – like images, videos, pdfs, and email content – are stored in a single repository.
To secure the financial data, data coming from the accounting department are secluded from other departments.
To increase the speed of the software, the management decided to archive all relevant company data for years prior to 2019.
A Database is a storage location of related data used to capture a specific situation. Which of the following is its example?
The company enabled online transactional processing for easy access to recent data.
To ensure that there will be data for future use, all attachments sent by customers through email – like images, videos, pdfs, and email content – are stored in a single repository.
To secure the financial data, data coming from the accounting department are secluded from other departments.
To increase the speed of the software, the management decided to archive all relevant company data for years prior to 2019.
A Data Mart supplies subject-oriented data necessary to support a specific business unit. Which of the following is its example?
The company enabled online transactional processing for easy access to recent data.
To ensure that there will be data for future use, all attachments sent by customers through email – like images, videos, pdfs, and email content – are stored in a single repository.
To secure the financial data, data coming from the accounting department are secluded from other departments.
To increase the speed of the software, the management decided to archive all relevant company data for years prior to 2019.
A Data Lake stores an organization’s raw and processed (unstructured and structured) data at both large and small scales. Which of the following is its example?
The company enabled online transactional processing for easy access to recent data.
To ensure that there will be data for future use, all attachments sent by customers through email – like images, videos, pdfs, and email content – are stored in a single repository.
To secure the financial data, data coming from the accounting department are secluded from other departments.
To increase the speed of the software, the management decided to archive all relevant company data for years prior to 2019.
Which of the following is NOT an end-user discovery on 4GL technology?
Incomplete data may not be very useful.
Data lacking documentation is questionable.
A single version of the same data can be confusing.
Old data is not desirable.
Which of the following is NOT a data-storing mechanism?
Object-oriented
Object-relational
Network
Peer-to-peer
Traditional
Batch Processing Tools can be helpful when moving data within a premise or closed environment and are usually done during off-work hours. Which of the following is its example?
Salesforce used SQL to extract and load data from the database.
Files are saved to the data warehouse every midnight for the scheduled updates through automation.
The manager of a company used Discord for communication and file/attachment storage instead of subscribing to Microsoft teams.
Microsoft Excel is used by a technical consultant to notice patterns and discover discrepancies to aid a database issue.
Open-Source Tools are preferable when companies are working on a budget to extract or replicate data providers. Which of the following is its example?
Salesforce used SQL to extract and load data from the database.
Files are saved to the data warehouse every midnight for the scheduled updates through automation.
The manager of a company used Discord for communication and file/attachment storage instead of subscribing to Microsoft teams.
Microsoft Excel is used by a technical consultant to notice patterns and discover discrepancies to aid a database issue.
Cloud-Based Tools allow users to directly connect data sources and destinations without writing code for quick access and analysis. Which of the following is its example?
Salesforce used SQL to extract and load data from the database.
Files are saved to the data warehouse every midnight for the scheduled updates through automation.
The manager of a company used Discord for communication and file/attachment storage instead of subscribing to Microsoft teams.
Microsoft Excel is used by a technical consultant to notice patterns and discover discrepancies to aid a database issue.
Offline tools can be used to aggregate data into a flat file to analyze data and create charts manually. Which of the following is its example?
Salesforce used SQL to extract and load data from the database.
Files are saved to the data warehouse every midnight for the scheduled updates through automation.
The manager of a company used Discord for communication and file/attachment storage instead of subscribing to Microsoft teams.
Microsoft Excel is used by a technical consultant to notice patterns and discover discrepancies to aid a database issue.
Which does NOT belong to the group?
Save
Extract
Load
Transform
Which is NOT a phase of data extraction?
Specify the data
Analyze changes
Identify changes
Process the data
INNER JOIN returns records that have matching values in both tables. Which of the following figures describes it?
RIGHT JOIN returns all records from the right table and the matched records from the left table. Which of the following figures describes it?
LEFT JOIN returns all records from the left table and the matched records from the right table. Which of the following figures describes it?
FULL JOIN returns all records when there is a match in either the left or right table. Which of the following figures describes it?
Which is NOT a use of SQL in a website?
Server-side scripting
Fetching needed data
Creating a URL
Storing the data
Which CANNOT be done by SQL?
Create new views
Create new data warehouses
Create new databases
Create new records
Arrange the items in chronological order based on the History of Data Warehousing (first created until last):
Personal Computers, Online Applications, Magnetic Storage, Punch Cards
Database Management System, Disk Storage
What order is "PERSONAL COMPUTERS"?
2nd
3rd
4th
5th
6th
Arrange the items in chronological order based on the History of Data Warehousing (first created until last):
Personal Computers, Online Applications, Magnetic Storage, Punch Cards
Database Management System, Disk Storage
What order is "MAGNETIC STORAGE"?
1st
2nd
3rd
4th
5th
Arrange the items in chronological order based on the History of Data Warehousing (first created until last):
Personal Computers, Online Applications, Magnetic Storage, Punch Cards
Database Management System, Disk Storage
What order is "DATABASE MANAGEMENT SYSTEM"?
2nd
3rd
4th
5th
6th
Arrange the items in chronological order based on the History of Data Warehousing (first created until last):
Personal Computers, Online Applications, Magnetic Storage, Punch Cards
Database Management System, Disk Storage
What order is "ONLINE APPLICATIONS"?
2nd
3rd
4th
5th
6th
Arrange the items in chronological order based on the History of Data Warehousing (first created until last):
Personal Computers, Online Applications, Magnetic Storage, Punch Cards
Database Management System, Disk Storage
What order is "PUNCH CARDS"?
1st
2nd
3rd
4th
5th
Arrange the items in chronological order based on the History of Data Warehousing (first created until last):
Personal Computers, Online Applications, Magnetic Storage, Punch Cards
Database Management System, Disk Storage
What order is "DISK STORAGE"?
1st
2nd
3rd
4th
5th
The CEO of a dental company wants to know how many clients are availing of the different promos in all their branches nationwide. Based on the data, he will select the promos he will remove or keep.
OLTP
OLAP
A supervisor wants to know the sales details of each merchandiser to aid her in tracking the key performance indicators (KPIs) of each agent.
OLTP
OLAP
A technical consultant wants to check all the issues, queries, and problems he solved for knowledge document creation.
OLTP
OLAP
A fast-food company manager wants to tally all products purchased at his branch.
OLTP
OLAP
A call-center team leader records every time a transaction is made for an international account.
OLTP
OLAP
A cruise application that checks the dates when the boats are reserved already or free to reserve.
OLTP
OLAP
Select all customers from the "Customers" table, then sort ascending by the "Country" and descending by the "CustomerName" column.
(a)
Select all customers with a ContactName that starts with “J” and ends with “O”.
(a)
Change the ContactName to "Juan" for all records where the country is "Mexico".
(a)
Select the first 30% of the records from the "Customers" table.
(a)
Select all fields from "Customers" table to extract all records with Germany or Spain in their Country fields.
(a)
Set "ClientName" to be the alias of "CustomerName" field from the "Customers" table.
(a)
