Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
Which of these are NOT benefits of using a cloud data warehouse
Virtual data warehousing
Is more flexible in terms of analytical needs than a normalized data model
The operational data are used as a source for the data warehouse
High total cost of ownership
Data integrity.
Since data is not duplicated, table joins are required. This makes queries more complicated, and thus read times are slower.
Intent Based Networking(IBN)
Denormalization usually speeds retrieval but can slow updates.
Which of the following terms does refer to the correctness and completeness of the data in a database?
Virtual data warehousing
Is more flexible in terms of analytical needs than a normalized data model
The operational data are used as a source for the data warehouse
High total cost of ownership
Data integrity.
Since data is not duplicated, table joins are required. This makes queries more complicated, and thus read times are slower.
Intent Based Networking(IBN)
Denormalization usually speeds retrieval but can slow updates.
Which of the following statement is true?
Virtual data warehousing
Is more flexible in terms of analytical needs than a normalized data model
The operational data are used as a source for the data warehouse
High total cost of ownership
Data integrity.
Since data is not duplicated, table joins are required. This makes queries more complicated, and thus read times are slower.
Intent Based Networking(IBN)
Denormalization usually speeds retrieval but can slow updates.
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
Virtual data warehousing
Is more flexible in terms of analytical needs than a normalized data model
The operational data are used as a source for the data warehouse
High total cost of ownership
Data integrity.
Since data is not duplicated, table joins are required. This makes queries more complicated, and thus read times are slower.
Intent Based Networking(IBN)
Denormalization usually speeds retrieval but can slow updates.
........uses distributed queries on several databases, without integrating the data into one physical data warehouse.
Virtual data warehousing
Is more flexible in terms of analytical needs than a normalized data model
The operational data are used as a source for the data warehouse
High total cost of ownership
Data integrity.
Since data is not duplicated, table joins are required. This makes queries more complicated, and thus read times are slower.
Intent Based Networking(IBN)
Denormalization usually speeds retrieval but can slow updates.
Which one of these is NOT an example of a cloud data warehouse vendor
Virtual data warehousing
Is more flexible in terms of analytical needs than a normalized data model
The operational data are used as a source for the data warehouse
High total cost of ownership
Data integrity.
Since data is not duplicated, table joins are required. This makes queries more complicated, and thus read times are slower.
Intent Based Networking(IBN)
Denormalization usually speeds retrieval but can slow updates.
Which is NOT true about Star Schema
Virtual data warehousing
Is more flexible in terms of analytical needs than a normalized data model
The operational data are used as a source for the data warehouse
High total cost of ownership
Data integrity.
Since data is not duplicated, table joins are required. This makes queries more complicated, and thus read times are slower.
Intent Based Networking(IBN)
Denormalization usually speeds retrieval but can slow updates.
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
Virtual data warehousing
Is more flexible in terms of analytical needs than a normalized data model
The operational data are used as a source for the data warehouse
High total cost of ownership
Data integrity.
Since data is not duplicated, table joins are required. This makes queries more complicated, and thus read times are slower.
Intent Based Networking(IBN)
Denormalization usually speeds retrieval but can slow updates.
Check it!
Match it!
Match it!