AsCEnD Datawarehouse

AsCEnD Dataware house Assessment

Q1. Interactive computer based systems intended to help decision makers utilize data and solve problems to make faster decisions

Answer: Business Intelligence

Q2. A temporary area where data is stored after extraction from the source

Answer: Staging area

Q3. Railway Reservation is an example of which system

Answer: OLTP

Q4. Dimension tables can be connected via foreign key in which of these schemas

Answer: Star

Q5. Database Tables in a star schema are typically denormalized

Answer: TRUE

Q6. Data marts in top down approach are called

Answer: Top down data marts

Q7. The data warehouse approach in which EDW is built first and data marts are derived from it later is called

Answer: Top down approach

Q8. Which of the following is not an ETL tool

Answer: Tableau

Q9. Critical metrics for measuring performance of a business

Answer: Ad Hoc reports

Q10. Data from a single source only can be moved to a data warehouse

Answer: FALSE

Q11. A dimension without any associated attribute is called

Answer: Degenerate dimension

Q12. Datastore used to analyse near real-time data

Answer: ODS

Q13. R in ROLAP stands for __________.

Answer: Relational

Q14. Miniature data warehouse that supports the requirement of a particular department or business process

Answer: DSS

Q15. ________ is a process that transforms raw data into meaningful and useful information for business purpose

Answer: Business Intelligence

Q16. Overall management of the availability, usability integrity and security of the data employed in an enterprise...

Answer: Duta Governance

Q17. The dimensions which contribute to the grain are called

Answer: Primary dimension

Q18.Fact table which has dimension keys but no measures is called

Answer: Factless fact table

Q19. Which of the following are the types of facts

Answer: Additive facts

Q20. Systems used to handle complex queries to discover trends and patterns

Answer: OLAP