Improving Databases With Cloud Part 2 Question Preview (ID: 53513)
How Cloud Computing Can Improve Database Management.
TEACHERS: click here for quick copy question ID numbers.
A collection of data designed to be used by different people is called a/an
a) Database
b) Organization
c) Relationship
d) Schema
Which of the following terms does refer to the correctness and completeness of the data in a database?
a) Data integrity.
b) Data model
c) Data constraint
d) Data security
Which of the following features usually applies to data in a data warehouse?
a) Data are rarely deleted
b) Data are often deleted
c) Most applications consist of transactions
d) Relatively few records are processed by applications
Which of the following statement is true?
a) The operational data are used as a source for the data warehouse
b) The data warehouse consists of data marts and operational data
c) The data warehouse is used as a source for the operational data
d) All of the options given
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) Since data is not duplicated, table joins are required. This makes queries more complicated, and thus read times are slower.
b) Less redundant data means you save on disk space, and so you can collect and store more data
c) Simpler tables make data modification commands faster to write and execute
d) Faster searching and sorting on each table
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) Fewer tables minimize the need for table joins which speeds up data analysts’ workflow and leads them discovering more useful
d) Improves the read performance and makes it much easier to manipulate tables into forms you want.
Which is NOT true about Star Schema
a) Is more flexible in terms of analytical needs than a normalized data model
b) It takes the information from the fact table and splits it into denormalized dimension tables
c) The emphasis for the star schema is on query speed
d) Since the tables are denormalized, they often contain repeated and redundant data.
........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
Which one of these is NOT an example of a cloud data warehouse vendor
a) Intent Based Networking(IBN)
b) Amazon Redshift.
c) Google BigQuery.
d) IBM Db2 Warehouse.
Which of these are NOT benefits of using a cloud data warehouse
a) High total cost of ownership
b) Leveraged cloud and cloud elasticity.
c) Better disaster recovery.
d) Increased data storage.
Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 53513 in the upper right hand corner or click here.
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 53513 in the upper right hand corner or click here.
TEACHERS / EDUCATORS
Log In | Sign Up / Register
Log In | Sign Up / Register