Database Foundations UTD Quiz 2 ACCT 6320 /
BUAN 6320 Questions with Correct Answers
Consider the following SQL statement: SELECT OrderNumber,
ProductName FROM Order O Left Join Product P ON O.ProductId =
P.Id. What command would you use in MongoDB to get a similar
result? Correct Answer-$lookup
Assume that an order consists of one or more products. In MongoDB:
Correct Answer-• Each 'Order' document can contain a reference to the
related 'Product' document within it.
• Orders and Products would be two different collections in one
database.
In MongoDB, a document in a collection is uniquely identified using:
Correct Answer-system-generated objectid
All companies where data is expected to grow by more than 138% in the
next 18 months definitely need a Hadoop infrastructure Correct Answer-
False
Data locality is critical for which of the following Hadoop
characteristics? Correct Answer-Rack Awareness
HDFS advantages include which of the following: Correct Answer-•
Data can be stored reliably
, • Data can be stored in large blocks of 64/128 mb
MapReduce is a data processing technique implemented in Java. This
meant that non-java applications for data processing could not be run in
Hadoop v1. In Hadoop v2, can non-java applications be run for
processing data? Correct Answer-Yes, thanks to YARN
For distributed data processing to be efficient, YARN ensures that
Correct Answer-• processing tasks are scheduled optimally based on
resource requirements
• data is processed as close to its storage location as possible
YARN separates resource management from data processing tasks,
thereby: Correct Answer-All of the above
Journal Nodes keep a log of any changes/edits made to a data node in
the name space. This primarily helps: Correct Answer-High availability
HDFS adopts an append-only policy to accommodate changes to
existing data files. This is acceptable because: Correct Answer-Batch-
mode is usually used for writing and reading of large amounts of data
BUAN 6320 Questions with Correct Answers
Consider the following SQL statement: SELECT OrderNumber,
ProductName FROM Order O Left Join Product P ON O.ProductId =
P.Id. What command would you use in MongoDB to get a similar
result? Correct Answer-$lookup
Assume that an order consists of one or more products. In MongoDB:
Correct Answer-• Each 'Order' document can contain a reference to the
related 'Product' document within it.
• Orders and Products would be two different collections in one
database.
In MongoDB, a document in a collection is uniquely identified using:
Correct Answer-system-generated objectid
All companies where data is expected to grow by more than 138% in the
next 18 months definitely need a Hadoop infrastructure Correct Answer-
False
Data locality is critical for which of the following Hadoop
characteristics? Correct Answer-Rack Awareness
HDFS advantages include which of the following: Correct Answer-•
Data can be stored reliably
, • Data can be stored in large blocks of 64/128 mb
MapReduce is a data processing technique implemented in Java. This
meant that non-java applications for data processing could not be run in
Hadoop v1. In Hadoop v2, can non-java applications be run for
processing data? Correct Answer-Yes, thanks to YARN
For distributed data processing to be efficient, YARN ensures that
Correct Answer-• processing tasks are scheduled optimally based on
resource requirements
• data is processed as close to its storage location as possible
YARN separates resource management from data processing tasks,
thereby: Correct Answer-All of the above
Journal Nodes keep a log of any changes/edits made to a data node in
the name space. This primarily helps: Correct Answer-High availability
HDFS adopts an append-only policy to accommodate changes to
existing data files. This is acceptable because: Correct Answer-Batch-
mode is usually used for writing and reading of large amounts of data
