Cloudera DS-200 Practice Tests From People Who Created Cloudera DS-200 Exam (1-12)

QUESTION 1
What is the result of the following command (the database username is foo and password is bar)?
$ sqoop list-tables – – connect jdbc : mysql : / / localhost/databasename – – table – – username foo – – password bar

A.    sqoop lists only those tables in the specified MySql database that have not already been imported into FDFS
B.    sqoop returns an error
C.    sqoop lists the available tables from the database
D.    sqoopimports all the tables from SQLHDFS

Answer: C
Explanation:
https://www.inkling.com/read/hadoop-definitive-guide-tom-white-3rd/chapter-15/getting-sqoop

Read More

Cloudera CCA-500 Past Important Questions with Answers and Explanation Shared By Braindump2go (1-11)

QUESTION 1
You need to analyze 60,000,000 images stored in JPEG format, each of which is approximately 25 KB. Because you Hadoop cluster isn’t optimized for storing and processing many small files, you decide to do the following actions:
1. Group the individual images into a set of larger files
2. Use the set of larger files as input for a MapReduce job that processes them directly with python using Hadoop streaming.
Which data serialization system gives the flexibility to do this?

A.    CSV
B.    XML
C.    HTML
D.    Avro
E.    SequenceFiles
F.    JSON

Answer: AB

Read More