Home » Managing Big Data in Clusters and Cloud Storage » Managing Big Data in Clusters and Cloud Storage Quiz

Managing Big Data in Clusters and Cloud Storage Quiz

Managing Big Data in Clusters and Cloud Storage Quiz Answer. This course is offered by “Coursera”. In this post you will get Managing Big Data in Clusters and Cloud Storage Coursera Quiz Answer | 100% Correct Answer

Managing Big Data in Clusters and Cloud Storage Quiz Coursera Quiz Answer

Offered By ”Cloudera”

⭐ 4.7 stars (188 ratings)

Use “Ctrl+F” To Find Any Questions Answer. & For Mobile User You Just Need To Click On Three dots In Your Browser & You Will Get A “Find” Option There. Use These Option to Get Any Random Questions Answer.

1.
Question 1
Use the Table Browser in Hue to view the tables in the fun database. (See the environment installation instructions for how to log in.) Which of the following tables are in the fun database? Check all that apply.

1 point

card_rank
card_suit
crayons

customers
games
inventory

makers
orders
toys

===================================================

2.
Question 2
Use the Table Browser in Hue to view the columns in the employees table in the default database. Which of the following columns are in the employees table? Check all that apply.

1 point

city
country

empl_id
first_name
grade

last_name
makers
office_id

salary

===================================================

3.
Question 3
Which of the following is a way to show what tables are available in the fly database using the query editor (center panel of Hue)?

1 point

Select the fly database as the active database and then run the command DESCRIBE DATABASE;

Select the fly database as the active database and then run the command DESCRIBE TABLES;
Select the fly database as the active database and then run the command SHOW DATABASES;
Select the fly database as the active database and then run the command SHOW TABLES;

===================================================

4.
Question 4
By default, what directory in HDFS would store the data for a table named artists in a database named music?

1 point

/user/hive/warehouse/music.db/artists
/user/hive/warehouse/music/artists

/music.db/artists
/user/hive/warehouse/artists
/music/artists

===================================================

5.
Question 5
By default, what directory in HDFS would store the data for a table named facilities in the default database?

1 point

/user/hive/warehouse/facilities
/user/hive/warehouse/default/facilities

/default.db/facilities
/user/hive/warehouse/default.db/facilities
/default/facilities

===================================================

6.
Question 6
What delimiter is used to separate the values in the lines of the text file containing the data in the orders table in the default database?

1 point

tab (\t)
comma (,)

===================================================

7.
Question 7
Which command will list the files in an HDFS directory to the terminal screen?

1 point

hdfs dfs ls /path/to/directory/
hdfs dfs get /path/to/directory/

hdfs dfs -ls /path/to/directory/
hdfs dfs -cat /path/to/directory/
hdfs dfs -get /path/to/directory/

hdfs dfs cat /path/to/directory/

===================================================

8.
Question 8
Which is an advantage of using S3?

1 point

There are many instances of S3, each with its own resources and connections

Hive and Impala only work with S3
Scalability is easier with S3 (or other cloud storage) than on-premises storage
S3 enables data locality

===================================================

9.
Question 9
Which commands can you use to print the contents of a file on S3 to your terminal screen? Check all that apply.

1 point

aws s3 -pr
hdfs dfs cat

aws s3 cat
aws s3 pr
hdfs dfs -cat

aws s3 -cat
hdfs dfs -pr
hdfs dfs pr

Week 2 Graded Quiz

1.
Question 1
Which statement creates a database named mydatabase?

1 point

CREATE DATABASE mydatabase LOCATION ‘/user/mydatabase.db’;
CREATE NEW DATABASE mydatabase;
CREATE NEW DATABASE mydatabase LOCATION ‘/user/mydatabase.db’;

CREATE DATABASE mydatabase;

===================================================

2.
Question 2
A new table is created using the following statement. The database used is in the default storage location in the Hive warehouse. Which statements describe the expected outcomes of this statement? Check all that apply.

CREATE TABLE thisdb.thistable (id TINYINT, name STRING);

1 point

The table is configured to store data in a directory named thistable
The table is configured to store data in /user/hive/warehouse/thistable
The table’s storage directory is a subdirectory of /user/hive/warehouse/thisdb.db

The table’s name is thisdb
The table is in the database thisdb
The table has four columns called id, TINYINT, name, and STRING

===================================================

3.
Question 3
A data file specifies a song (such as “Bohemian Rhapsody”) on an album (in this case A Night At The Opera) by an artist or group (Queen). The file uses the pipe character (|) to separate values, so the example would look like this row:

Bohemian Rhapsody|A Night At The Opera|Queen

Which statement is appropriate to define a table using data in this format?

1 point

CREATE TABLE songs (song STRING, album STRING, artist STRING)

ROW FORMAT DELIMITED

FIELDS TERMINATED BY ‘\|’;

CREATE TABLE songs (song STRING, album STRING, artist STRING)

ROW FORMAT DELIMITED

FIELDS TERMINATED BY |;

CREATE TABLE songs (song STRING, album STRING, artist STRING)

ROW FORMAT DELIMITED BY ‘\|’;

CREATE TABLE songs (song STRING, album STRING, artist STRING)

ROW FORMAT DELIMITED BY |;

CREATE TABLE songs (song STRING, album STRING, artist STRING)

ROW FORMAT DELIMITED

FIELDS TERMINATED BY ‘|’;

CREATE TABLE songs (song STRING, album STRING, artist STRING)

ROW FORMAT DELIMITED BY ‘|’;

===================================================

4.
Question 4
The data for a table to be called weblogs is provided in Parquet files (with format PARQUET) and are placed in S3 in a directory named weblogs in the bucket named training-coursera1. Which statement correctly creates this table? (Assume the column list is correct.)

1 point

CREATE EXTERNAL TABLE weblogs (…)

FILE FORMAT PARQUET

LOCATION ‘s3a://training-coursera1/weblogs/’;

CREATE EXTERNAL TABLE weblogs (…)

STORED AS PARQUET

LOCATION ‘s3a://training-coursera1/weblogs/’;

CREATE EXTERNAL TABLE weblogs (…)

FILE FORMAT PARQUET

STORED AT ‘s3a://training-coursera1/weblogs/’;

CREATE EXTERNAL TABLE weblogs (…)

ROW FORMAT PARQUET

LOCATION ‘s3a://training-coursera1/weblogs/’;

CREATE EXTERNAL TABLE weblogs (…)

ROW FORMAT DELIMITED PARQUET

STORED AT ‘s3a://training-coursera1/weblogs/’;

CREATE EXTERNAL TABLE weblogs (…)

STORED AS PARQUET

AT ‘s3a://training-coursera1/weblogs/’;

===================================================

5.
Question 5
Which statement correctly uses a SerDe for reading and writing newtable’s data?

1 point

CREATE TABLE newtable (col1 STRING, col2 INT)

ROW FORMAT SERDE org.apache.hadoop.hive.serde2.OpenCSVSerde;

CREATE TABLE newtable (col1 STRING, col2 INT)

WITH SERDE org.apache.hadoop.hive.serde2.OpenCSVSerde;

CREATE TABLE newtable (col1 STRING, col2 INT)

STORED AS SERDE org.apache.hadoop.hive.serde2.OpenCSVSerde;

CREATE TABLE newtable (col1 STRING, col2 INT)

ROW FORMAT SERDE ‘org.apache.hadoop.hive.serde2.OpenCSVSerde’;

CREATE TABLE newtable (col1 STRING, col2 INT)

WITH SERDE ‘org.apache.hadoop.hive.serde2.OpenCSVSerde’;

CREATE TABLE newtable (col1 STRING, col2 INT)

STORED AS SERDE ‘org.apache.hadoop.hive.serde2.OpenCSVSerde’;

===================================================

6.
Question 6
An alternative to using CREATE EXTERNAL TABLE when creating an externally managed table is to set the table property EXTERNAL to TRUE. Which of the following would correctly do this?

1 point

CREATE TABLE table_with_header (col1 INT, col2 STRING)

TBLPROPERTIES (‘EXTERNAL’=’TRUE’);