ExamGecko
Question list
Search
Search

List of questions

Search

Question 143 - DA0-001 discussion

Report
Export

'Which of the following is the BEST reason to use database views instead of tables?

A.
Views reduce the need for repetitive, complex data joins.
Answers
A.
Views reduce the need for repetitive, complex data joins.
B.
Views allow for the storage of temporary data. whereas tables do not.
Answers
B.
Views allow for the storage of temporary data. whereas tables do not.
C.
Views allow for the joining of multiple data sources, whereas tables do not.
Answers
C.
Views allow for the joining of multiple data sources, whereas tables do not.
D.
Views can be used to restrict sensitive information.
Answers
D.
Views can be used to restrict sensitive information.
Suggested answer: A

Explanation:

Views are virtual tables that are created by querying one or more base tables or other views. Views do not store any data, but only show the result of a query. One of the main advantages of using views is that they can reduce the need for repetitive, complex data joins. For example, if a query involves joining multiple tables with many conditions, creating a view can simplify the query and make it easier to reuse. Therefore, the correct answer is A. Reference: [What is a Database View? | Definition & Examples - Vertabelo], [Database Views - GeeksforGeeks]

asked 02/10/2024
Robert Andrade
47 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first