it.al3

Data redundancy in a database can lead to:

• Enhanced data accuracy

• Duplication of data across multiple tables

• Improved data access speed

• Secure data storage

Which of the following best defines cloud computing?

• A process that stores data on local servers for easy access

• A tool for creating backups on a personal computer

• An approach that uses a network of remote servers to store, manage, and process data

• A storage method used exclusively for multimedia files

Distributed processing is a type of computing where:

• Multiple computers work on different parts of a task simultaneously

• A single server processes all user requests

• Data is only stored in a central location

• Only one task can be completed at a time

Data lakes are often preferred over traditional data warehouses because they:

• Store only high-quality, curated data

• Are limited to storing structured data

• Can store raw data in its native format for future processing

• Require complex data modeling before data storage

A key difference between a data lake and a data warehouse is that:

• Data lakes only store structured data, while data warehouses can store all data types

• Data warehouses use schema-on-read, while data lakes use schema-on-write

• Data lakes store raw data in its native format, while data warehouses store processed data

• Data lakes are more expensive to maintain than data warehouses

What is data infrastructure?

• A set of software applications used exclusively for data visualization

• The framework of physical and virtual components that support data storage, processing, and management

• A cloud-only system for data backup

• A security protocol to prevent data breaches

Which of the following statements about ETL (Extract, Transform, Load) processes is true?

• ETL processes are only used for structured data

• ETL is a method for data integration that involves extracting data from various sources, transforming it, and loading it into a target system

• ETL processes are less efficient than ELT (Extract, Load, Transform) processes

• ETL is primarily used for real-time data processing

What is the primary purpose of a data governance framework?

• To ensure data quality and compliance with regulations

• To increase the speed of data processing

• To reduce the cost of data storage

• To eliminate the need for data backups

In the context of big data, what does the term velocity refer to?

• The speed at which data is generated and processed

• The size of the data being handled

• The variety of data types being collected

• The accuracy of the data collected

What does the term data mining refer to?

• A process of analyzing large datasets to discover patterns and insights

• A method for storing data in a cloud environment

• A technique for backing up data on physical drives

• A way to visualize data using charts and graphs