Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Improving Databases With Cloud Part 2
Test Description: How cloud computing can improve database management.
Instructions: Answer all questions to get your test result.
1) A collection of data designed to be used by different people is called a/an
A
Database
B
Schema
C
Relationship
D
Organization
2) Which of the following terms does refer to the correctness and completeness of the data in a database?
A
Data integrity.
B
Data constraint
C
Data model
D
Data security
3) Which of the following features usually applies to data in a data warehouse?
A
Relatively few records are processed by applications
B
Most applications consist of transactions
C
Data are often deleted
D
Data are rarely deleted
4) Which of the following statement is true?
A
All of the options given
B
The data warehouse is used as a source for the operational data
C
The data warehouse consists of data marts and operational data
D
The operational data are used as a source for the data warehouse
5) Normalization is the process of efficiently organizing data in a data warehouse (or any other place that stores data). The main goals are to reduce data redundancy, and improve data integrity . Which of these is NOT a benefit of data normalization
A
Faster searching and sorting on each table
B
Since data is not duplicated, table joins are required. This makes queries more complicated, and thus read times are slower.
C
Simpler tables make data modification commands faster to write and execute
D
Less redundant data means you save on disk space, and so you can collect and store more data
6) Denormalization is the process of deliberately adding redundant copies or groups of data to already normalized data. It is not the same as un-normalized data. Which of these is NOT a benefit of Denormalization
A
Improves the read performance and makes it much easier to manipulate tables into forms you want.
B
Fewer tables simplify queries leading to fewer bugs
C
Fewer tables minimize the need for table joins which speeds up data analysts’ workflow and leads them discovering more useful
D
Denormalization usually speeds retrieval but can slow updates.
7) Which is NOT true about Star Schema
A
The emphasis for the star schema is on query speed
B
It takes the information from the fact table and splits it into denormalized dimension tables
C
Is more flexible in terms of analytical needs than a normalized data model
D
Since the tables are denormalized, they often contain repeated and redundant data.
8) ........uses distributed queries on several databases, without integrating the data into one physical data warehouse.
A
Virtual data warehousing
B
Cloud Databases
C
Data Marts
D
Outsourced Data warehouse
9) Which one of these is NOT an example of a cloud data warehouse vendor
A
Amazon Redshift.
B
Google BigQuery.
C
IBM Db2 Warehouse.
D
Intent Based Networking(IBN)
10) Which of these are NOT benefits of using a cloud data warehouse
A
Better disaster recovery.
B
Leveraged cloud and cloud elasticity.
C
High total cost of ownership
D
Increased data storage.
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2022
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?