Quiz: Quiz-C

PART A:

The following questions require an implementation with Spark that processes the file CoronaStatsSmall.csv Download CoronaStatsSmall.csv. Thus, to answer the questions, you must first create an RDD with the records included in the file and then process the corresponding rdd.

Each line of the csv file corresponds to a record with the following information: dateRep, day, month, year, cases, deaths, countriesAndTerritories, geoId, countryterritoryCode, popData2020, continentExp

Flag question: Question 1

How many elements does the rdd contain?

Group of answer choices

less than 4000

less than 7000

more than 7001

Flag question: Question 2

How many elements for Italy does the rdd contain?

Flag question: Question 3

What is the maximum number of cases reported for Italy?

(tip: transform the elements for Italy into key-value pairs with the value being the number of cases)

Flag question: Question 4

How many countries does the rdd include?

Flag question: Question 5

Which of these countries has the most elements?

Group of answer choices

Liechtenstein

Latvia

Italy

Lithuania

Netherlands

Flag question: Spacer

PART B:

The remaining questions of this quiz are related to the translation of ER diagrams relational databases.

Flag question: Question 6

Match the terms with the corresponding descriptions.

Group of answer choices

relation

anomaly

composite key

normal form

Flag question: Question 7

Which of the following part of an ER diagram would create more than 2 relations?

Group of answer choices

A regular entity with two composite attributes

Two entities connected with a many-to-many relationship

Two entities connected with an one-to-one relationship that has associative entity (for the relationship)

Two entities connected with an one-to-many relationship

Flag question: Question 8

Select the correct relation for the transformation of the ER diagram.

Group of answer choices

Flight(PrimaryKey FlightNumber, PrimaryKey Date, PassengerNumber, Destination, Departure)

Flight(PrimaryKey FlightID, PrimaryKey FlightNumber, PrimaryKey Date, PassengerNumber, Destination, Departure)

Flight(PrimaryKey FlightNumber, Date, PassengerNumber, PrimaryKey Destination, PrimaryKey Departure)

Flight(PrimaryKey FlightNumber, Date, PassengerNumber, Destination, Departure)

Flight(PrimaryKey FlightID, PassengerNumber, Destination, Departure)

Flag question: Question 9

Select the correct relation for the transformation of the ER diagram.

Group of answer choices

Employee(PrimaryKey EmployeeId, Name, SkillCode) & Skill(PrimaryKey Code, Title, Type)

Employee(PrimaryKey EmployeeId, Name) & Skill(PrimaryKey Code, Title, Type, EmployeeId)

Employee(PrimaryKey EmployeeId, Name) & Skill(PrimaryKey Code, Title, Type) & Possesses(PrimaryKey EmployeeId, PrimaryKey SkillCode)

Employee(PrimaryKey EmployeeId, Name, SkillCode, SkillTitle, SkillType)

Flag question: Question 10

Select the correct relation(s) of the transformation of the ER diagram.

Group of answer choices

Movie(PrimaryKey MovieName, PrimaryKey DVDCopyNumber)

Movie(PrimaryKey Name) & DVD(PrimaryKey CopyNumber) & DvdOfMovie(PrimaryKey MovieName, PrimaryKey DVDCopyNumber)

incorrect answer

Movie(PrimaryKey MovieName) & DVD(PrimaryKey CopyNumber, PrimaryKey MovieName)

Flag question: Question 11

Select the correct relation(s) of the transformation of the ER diagram.

Group of answer choices

Customer(PrimaryKey CustomerId, Name, Address, PostalCode, PrimaryKey OrderId, Date)

Customer(PrimaryKey CustomerId, Name, Address, PostalCode) & Order(PrimaryKey OrderId, Date, CustomerId)

Customer(PrimaryKey CustomerId, Name, Address, PostalCode, OrderId) & Order (PrimaryKey OrderId, Date)

Customer(PrimaryKey CustomerId, Name, Address, PostalCode) & Order (PrimaryKey OrderId, Date) & Made(PrimaryKey CustomerId, PrimaryKey OrderId)

Loading...

Quiz-C

Quiz instructions