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