Question 1

In the context of database management systems, primary keys and foreign keys are important in relational databases because they help

Accepted Answer

A)  database users collate data from different tables. 
B)  manage the volume and speed of incoming data. 
C)  customers search for products online effectively. 
D)  databases consistently maintain the same properties. 
A)  database users collate data from different tables. 
B)  manage the volume and speed of incoming data. 
C)  customers search for products online effectively. 
D)  databases consistently maintain the same properties. A

Question 2

A company combined monthly sales data into a single group to calculate the total sales by a quarter or a year. This is an example of the ________ step of data transformation.

Accepted Answer

A)  feature construction 
B)  aggregation 
C)  dummy coding 
D)  normalization 
A)  feature construction 
B)  aggregation 
C)  dummy coding 
D)  normalization B

Question 3

Describe and explain the four processes of data transformation.

Accepted Answer

The four processes of data transformation are extraction, transformation, loading, and validation.

1. Extraction: This process involves extracting data from various sources such as databases, files, and applications. The data is collected and brought together in a centralized location for further processing.

2. Transformation: Once the data is extracted, it needs to be transformed into a format that is suitable for analysis and reporting. This process involves cleaning the data, removing duplicates, and standardizing formats. It may also involve applying business rules and calculations to the data.

3. Loading: After the data has been transformed, it needs to be loaded into a data warehouse or other storage system. This process involves moving the data from the extraction location to the destination, and ensuring that it is organized and accessible for analysis.

4. Validation: The final step in the data transformation process is validation. This involves checking the accuracy and completeness of the transformed data. It may involve running quality checks, verifying data integrity, and ensuring that the data meets the requirements of the end users.

Overall, the four processes of data transformation are essential for ensuring that data is accurate, consistent, and ready for analysis and reporting. By following these processes, organizations can make better-informed decisions and gain valuable insights from their data.

Question 4

Identify the second step the MapReduce platform performs to solve problems of big data computation.

Accepted Answer

A)  Provide SQL-like query to access data stored in different file systems and databases. 
B)  Map the data by dividing it into manageable subsets. 
C)  Distribute data to a group of networked computers for storing and processing. 
D)  Combine the answers from the computer nodes into a single answer for the original problem handled. 
A)  Provide SQL-like query to access data stored in different file systems and databases. 
B)  Map the data by dividing it into manageable subsets. 
C)  Distribute data to a group of networked computers for storing and processing. 
D)  Combine the answers from the computer nodes into a single answer for the original problem handled.

Question 5

Compare and contrast relational and non-relational databases.

Accepted Answer

Relational and non-relational databases

Question 6

Companies that adopt ________ typically achieve up to 6 percent higher productivity and output than their peer companies.

Accepted Answer

A)  multi-channel interactions 
B)  static information and fixed rules 
C)  social media sales campaigns 
D)  data-driven decision making 
A)  multi-channel interactions 
B)  static information and fixed rules 
C)  social media sales campaigns 
D)  data-driven decision making

Question 7

In a dataset, values that are at a considerable distance from any of the other data clusters are treated as outliers.

Accepted Answer

A) True 
 B)False

Question 8

Most traditional Extract, Transform, and Load (ETL) tools can process only relational datasets for unstructured data, semi-structured, and machinery sensor data, but newer systems are much more flexible.

Accepted Answer

A) True 
 B)False

Question 9

In data transformation, ________ involves creating a dichotomous value from a categorical value.

Accepted Answer

A)  feature construction 
B)  overfitting 
C)  dummy coding 
D)  data compression 
A)  feature construction 
B)  overfitting 
C)  dummy coding 
D)  data compression

Question 10

The veracity characteristic of big data provides businesses a holistic understanding of their customers and market situations.

Accepted Answer

A) True 
 B)False

Question 11

The ________ characteristic of big data enables real-time business responses and strategies.

Accepted Answer

A)  volume 
B)  variety 
C)  velocity 
D)  value 
A)  volume 
B)  variety 
C)  velocity 
D)  value

Question 12

Unlike relational databases, non-relational databases

Accepted Answer

A)  make drilling down to very specific types of data easy. 
B)  distribute all data into structured tables. 
C)  are used by companies dealing with fixed, well-defined data. 
D)  provide greater flexibility for storing ever-changing data. 
A)  make drilling down to very specific types of data easy. 
B)  distribute all data into structured tables. 
C)  are used by companies dealing with fixed, well-defined data. 
D)  provide greater flexibility for storing ever-changing data.

Question 13

Explain how the Extract, Transform, and Load (ETL) integration process uses Hadoop to capture, store, process, secure, and then analyze complex data.

Accepted Answer

The Extract, Transform, and Load (ETL) i

Question 14

A ________ of data can contain as much information as half of the contents of all U.S. academic research libraries.

Accepted Answer

A)  petabyte 
B)  terabyte 
C)  megabyte 
D)  gigabyte 
A)  petabyte 
B)  terabyte 
C)  megabyte 
D)  gigabyte

Question 15

Which of the following characteristics of big data increases complexity and reduces confidence in the data?

Accepted Answer

A)  variety 
B)  volume 
C)  veracity 
D)  velocity 
A)  variety 
B)  volume 
C)  veracity 
D)  velocity

Question 16

In the context of data quality, ________ is the extent to which information is adequately presented or delivered for efficient and effective understanding.

Accepted Answer

A)  accuracy 
B)  timeliness 
C)  consistency 
D)  format 
A)  accuracy 
B)  timeliness 
C)  consistency 
D)  format

Question 17

In data transformation, ________ involves subtracting a variable from the mean and then dividing it by the standard deviation.

Accepted Answer

A)  dummy coding 
B)  normalization 
C)  new column construction 
D)  overfitting 
A)  dummy coding 
B)  normalization 
C)  new column construction 
D)  overfitting

Question 18

Imagine a company wants to send a follow-up email to its best customers immediately after a purchase. However, email addresses were not collected from the customers at the time of purchase. This is an example of missing the data quality of ________.

Accepted Answer

A)  accuracy 
B)  timeliness 
C)  consistency 
D)  variety 
A)  accuracy 
B)  timeliness 
C)  consistency 
D)  variety

Question 19

Asking the question "Is the data correct, reliable, and precisely measured?" will help in determining the data quality of ________.

Accepted Answer

A)  accuracy 
B)  format 
C)  consistency 
D)  timeliness 
A)  accuracy 
B)  format 
C)  consistency 
D)  timeliness

Question 20

A major challenge of today's data management is that

Accepted Answer

A)  the inbound data goes on to increase exponentially. 
B)  data is not held in vaults for viewing by business department heads. 
C)  converting structured data into a usable form is a complex process. 
D)  data tends to trickle in, making simultaneous processing difficult. 
A)  the inbound data goes on to increase exponentially. 
B)  data is not held in vaults for viewing by business department heads. 
C)  converting structured data into a usable form is a complex process. 
D)  data tends to trickle in, making simultaneous processing difficult.

In the context of database management systems, primary keys and foreign keys are important in relational databases because they help

A company combined monthly sales data into a single group to calculate the total sales by a quarter or a year. This is an example of the ________ step of data transformation.

Describe and explain the four processes of data transformation.

Identify the second step the MapReduce platform performs to solve problems of big data computation.

Compare and contrast relational and non-relational databases.

Companies that adopt ________ typically achieve up to 6 percent higher productivity and output than their peer companies.

In a dataset, values that are at a considerable distance from any of the other data clusters are treated as outliers.

Most traditional Extract, Transform, and Load (ETL) tools can process only relational datasets for unstructured data, semi-structured, and machinery sensor data, but newer systems are much more flexible.

In data transformation, ________ involves creating a dichotomous value from a categorical value.

The veracity characteristic of big data provides businesses a holistic understanding of their customers and market situations.

The ________ characteristic of big data enables real-time business responses and strategies.

Unlike relational databases, non-relational databases

Explain how the Extract, Transform, and Load (ETL) integration process uses Hadoop to capture, store, process, secure, and then analyze complex data.

A ________ of data can contain as much information as half of the contents of all U.S. academic research libraries.

Which of the following characteristics of big data increases complexity and reduces confidence in the data?

In the context of data quality, ________ is the extent to which information is adequately presented or delivered for efficient and effective understanding.

In data transformation, ________ involves subtracting a variable from the mean and then dividing it by the standard deviation.

Imagine a company wants to send a follow-up email to its best customers immediately after a purchase. However, email addresses were not collected from the customers at the time of purchase. This is an example of missing the data quality of ________.

Asking the question "Is the data correct, reliable, and precisely measured?" will help in determining the data quality of ________.

A major challenge of today's data management is that

Introduction to Marketing Analytics

Exploratory Data Analysis Using Cognitive Analytics

Data Visualization

Regression Analysis

Neural Networks

Automated Machine Learning

Cluster Analysis

Market Basket Analysis

Natural Language Processing - Text Mining and Sentiment Analysis

Social Network Analysis

Web Analytics

Filters

Exam 2: Data Management

In the context of database management systems, primary keys and foreign keys are important in relational databases because they help

A company combined monthly sales data into a single group to calculate the total sales by a quarter or a year. This is an example of the ________ step of data transformation.

Describe and explain the four processes of data transformation.

Identify the second step the MapReduce platform performs to solve problems of big data computation.

Compare and contrast relational and non-relational databases.

Companies that adopt ________ typically achieve up to 6 percent higher productivity and output than their peer companies.

In a dataset, values that are at a considerable distance from any of the other data clusters are treated as outliers.

Most traditional Extract, Transform, and Load (ETL) tools can process only relational datasets for unstructured data, semi-structured, and machinery sensor data, but newer systems are much more flexible.

In data transformation, ________ involves creating a dichotomous value from a categorical value.

The veracity characteristic of big data provides businesses a holistic understanding of their customers and market situations.

The ________ characteristic of big data enables real-time business responses and strategies.

Unlike relational databases, non-relational databases

Explain how the Extract, Transform, and Load (ETL) integration process uses Hadoop to capture, store, process, secure, and then analyze complex data.

A ________ of data can contain as much information as half of the contents of all U.S. academic research libraries.

Which of the following characteristics of big data increases complexity and reduces confidence in the data?

In the context of data quality, ________ is the extent to which information is adequately presented or delivered for efficient and effective understanding.

In data transformation, ________ involves subtracting a variable from the mean and then dividing it by the standard deviation.

Imagine a company wants to send a follow-up email to its best customers immediately after a purchase. However, email addresses were not collected from the customers at the time of purchase. This is an example of missing the data quality of ________.

Asking the question "Is the data correct, reliable, and precisely measured?" will help in determining the data quality of ________.

A major challenge of today's data management is that

Introduction to Marketing Analytics

Exploratory Data Analysis Using Cognitive Analytics

Data Visualization

Regression Analysis

Neural Networks

Automated Machine Learning

Cluster Analysis

Market Basket Analysis

Natural Language Processing - Text Mining and Sentiment Analysis

Social Network Analysis

Web Analytics

Filters