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
Relationship
C
Schema
D
Organization
2) Which of the following terms does refer to the correctness and completeness of the data in a database?
A
Data constraint
B
Data integrity.
C
Data model
D
Data security
3) Which of the following features usually applies to data in a data warehouse?
A
Most applications consist of transactions
B
Data are rarely deleted
C
Relatively few records are processed by applications
D
Data are often deleted
4) Which of the following statement is true?
A
All of the options given
B
The data warehouse consists of data marts and operational data
C
The operational data are used as a source for the data warehouse
D
The data warehouse is used as a source for the operational data
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
Less redundant data means you save on disk space, and so you can collect and store more data
C
Since data is not duplicated, table joins are required. This makes queries more complicated, and thus read times are slower.
D
Simpler tables make data modification commands faster to write and execute
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
Denormalization usually speeds retrieval but can slow updates.
B
Fewer tables simplify queries leading to fewer bugs
C
Improves the read performance and makes it much easier to manipulate tables into forms you want.
D
Fewer tables minimize the need for table joins which speeds up data analysts’ workflow and leads them discovering more useful
7) Which is NOT true about Star Schema
A
The emphasis for the star schema is on query speed
B
Since the tables are denormalized, they often contain repeated and redundant data.
C
Is more flexible in terms of analytical needs than a normalized data model
D
It takes the information from the fact table and splits it into denormalized dimension tables
8) ........uses distributed queries on several databases, without integrating the data into one physical data warehouse.
A
Outsourced Data warehouse
B
Data Marts
C
Cloud Databases
D
Virtual data warehousing
9) Which one of these is NOT an example of a cloud data warehouse vendor
A
Google BigQuery.
B
Amazon Redshift.
C
IBM Db2 Warehouse.
D
Intent Based Networking(IBN)
10) Which of these are NOT benefits of using a cloud data warehouse
A
High total cost of ownership
B
Better disaster recovery.
C
Increased data storage.
D
Leveraged cloud and cloud elasticity.
*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-2024
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?