Submitted By: Shaurya
Thanks Shaurya for sharing and helping other fellow students.
------------------------------------
1. What is the primary purpose of a data warehouse?
a) Real-time transaction processing
b) Data storage for backups
c) Analyzing large volumes of data
d) Managing relational databases
2. Which of the following best describes data warehousing?
a) Storing data in a centralized repository
b) Performing online transactions
c) Analyzing real-time data streams
d) Creating data visualizations
3. What is the difference between operational data and data warehouse data?
a) Operational data is historical, while data warehouse data is real-time.
b) Operational data is structured, while data warehouse data is unstructured.
c) Operational data is used for daily operations, while data warehouse data is used for analysis.
d) Operational data is stored in cloud servers, while data warehouse data is stored on-premises.
4. Which of the following is NOT a characteristic of a data warehouse?
a) Integrated data
b) Real-time data processing
c) Subject-oriented data
d) Historical data
5. What is the main purpose of an Extract, Transform, Load (ETL) process in a data warehouse?
a) Extracting data from external sources
b) Transforming data into a suitable format
c) Loading data into the data warehouse
d) All of the above
6. Which architectural component of a data warehouse is responsible for storing large volumes of data?
a) Data mart
b) Data cube
c) Data warehouse server
d) Metadata repository
7. What is the role of a data mart in a data warehouse architecture?
a) Storing detailed transactional data
b) Storing aggregated data for specific departments or business units
c) Managing ETL processes
d) Performing data mining operations
8. In dimensional modeling, what is a fact table?
a) A table that stores textual descriptions of data
b) A table that stores primary keys and foreign keys
c) A table that stores numerical measurements or metrics
d) A table that stores metadata information
9. What is a dimension table in dimensional modeling?
a) A table that stores primary keys and foreign keys
b) A table that stores textual descriptions of data
c) A table that stores numerical measurements or metrics
d) A table that stores metadata information
10. What is OLAP short for?
a) Online Analytical Processing
b) Operational Language for Analyzing Patterns
c) On-Demand Localized Analysis Platform
d) Offline Logical Aggregation Procedure
11. Which of the following is NOT a step in the ETL process?
a) Extraction
b) Transaction
c) Transformation
d) Loading
12. What is data mining?
a) Extracting valuable minerals from the earth
b) Analyzing large volumes of data to discover patterns and relationships
c) Managing data in a structured database
d) Storing data in a data warehouse
13. What are the main goals of data mining?
a) Predictive modeling and trend analysis
b) Data cleansing and data integration
c) Data visualization and reporting
d) Database optimization and query performance
14. Which data mining technique is used to classify data into predefined categories or classes?
a) Clustering
b) Association rule mining
c) Classification
d) Regression analysis
15. Which data mining technique is used to discover patterns or associations in data?
a) Clustering
b) Association rule mining
c) Classification
d) Regression analysis
16. Which industry commonly uses data mining for fraud detection?
a) Healthcare
b) Retail
c) Banking
d) Education
17. What is the goal of market basket analysis?
a) Predicting customer churn
b) Identifying associations between products
c) Analyzing social media sentiment
d) Estimating customer lifetime value
18. What is big data?
a) Data that cannot be analyzed
b) Data that exceeds the capacity of traditional database systems
c) Data that is stored in the cloud
d) Data that is generated by artificial intelligence algorithms
19. Which of the following is NOT a characteristic of big data?
a) Volume
b) Velocity
c) Variety
d) Validation
20. What is Hadoop?
a) A programming language for data analysis
b) A distributed file system for storing big data
c) A data integration tool for ETL processes
d) A database management system for data warehousing
No comments:
Post a Comment