Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

n Status: QUESTION 17 The best place to improve data entry across all applicatio

ID: 3738031 • Letter: N

Question

n Status: QUESTION 17 The best place to improve data entry across all applications is e in the users. O in the level of organizational commitment. in the data entry operators. O in the database definitions. QUESTION 18 Which of the following is true? O none of these is correct query result finer operation is to make the granularity of the data in the query result coarper, while the purpose of the dieit up operation is to make the ganularity of the duts in t O The purpose of the drill up operation is to make the granularity of the data in the query resut hner, wil the purpose of the dril down operaton is to muke the granularty of the duta in he query resuit coarser the g of the drill down s to query result coarser. QUESTION 19 OLAP ETL Micro batches OLTP

Explanation / Answer

Question 17:

Answer: Option d): in the database definition.

Explanation: While defining the database schema one can improve quality of data by applying choosing appropriate data type and applying proper constraint.

Question 18:

Answer: Option d): The purpose of the drill down operations is to make granularity of data in the query result finer, while the purpose of drill up operation is to make the granularity of the data in the query result coarser.

Question 19:

Answer: Option a): OLAP

Explanation: OLAP is the broader category of business intelligence. In this data is queried and presented from datawarehouse or data mart for analytical purpose.