A company has a MySQL database with customer records and wants to export this data to HDFS for archival and analysis. They also want to run SQL-like queries on the exported data. Which two components should they use?

Oozie to export from MySQL to HDFS, then Spark SQL to query the data

Sqoop to export from MySQL to HDFS, then Hive to query the data

Kafka to export from MySQL to HDFS, then HBase to query the data

Flume to export from MySQL to HDFS, then Pig to query the data

Dell Data Science Foundations

Domain 5Objective 3

Describe the Hadoop Ecosystem and Related Product Use Cases DATA-SCIENCE-FOUNDATIONS Practice Questions (Page 2)

Part of the Advanced Analytics for Big Data - Technology and Tools domain, which accounts for 22% of the DATA-SCIENCE-FOUNDATIONS exam.

51questions here

11free pages

16concepts

22%of the exam

Questions 6–10

6application · medium
A telecom company needs to store call detail records (CDRs) and support low-latency lookups by phone number for customer service applications. They also need to run occasional batch analytics on the same data. Which Hadoop ecosystem component should be the primary store for the CDRs?
Select an answer first
7foundation · easy
Which Hadoop ecosystem component is responsible for storing the actual data across the cluster?
Select an answer first
8application · medium
A company has a MySQL database with customer records and wants to export this data to HDFS for archival and analysis. They also want to run SQL-like queries on the exported data. Which two components should they use?
Select an answer first
9application · medium
A company needs to process a massive dataset stored in HDFS using a parallel, fault-tolerant batch processing model. The processing logic is complex and requires custom Java code. Which programming model should they use?
Select an answer first
10foundation · easy
Which YARN component runs on each worker node and manages the resources available on that node?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-SCIENCE-FOUNDATIONS

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Dell Technologies. “DATA-SCIENCE-FOUNDATIONS” is a trademark of its owner, used for identification only.

Describe the Hadoop Ecosystem and Related Product Use Cases DATA-SCIENCE-FOUNDATIONS Practice Questions (Page 2)

Questions 6–10

A telecom company needs to store call detail records (CDRs) and support low-latency lookups by phone number for customer service applications. They also need to run occasional batch analytics on the same data. Which Hadoop ecosystem component should be the primary store for the CDRs?

Which Hadoop ecosystem component is responsible for storing the actual data across the cluster?

A company has a MySQL database with customer records and wants to export this data to HDFS for archival and analysis. They also want to run SQL-like queries on the exported data. Which two components should they use?

A company needs to process a massive dataset stored in HDFS using a parallel, fault-tolerant batch processing model. The processing logic is complex and requires custom Java code. Which programming model should they use?

Which YARN component runs on each worker node and manages the resources available on that node?

Keep studying — Advanced Analytics for Big Data - Technology and Tools