Question 1

Xe "author_ISBN table of books database"In SQL, a foreign key is a column in one table that matches a ________ column in another table.

Accepted Answer

A)  domestic key 
B)  candidate key 
C)  primary key 
D)  None of the above 
A)  domestic key 
B)  candidate key 
C)  primary key 
D)  None of the above C

Question 2

Which of the following statements a), b) or c) is false?

Accepted Answer

A)  Hadoop providers typically also provide Spark support. 
B)  Databricks is a Spark-specific vendor-they provide a "zero-management cloud platform built around Spark." Their website also is an excellent resource for learning Spark. 
C)  The paid Databricks platform runs on Amazon AWS or Microsoft Azure. Databricks also provides a free Databricks Community Edition, which is a great way to get started with both Spark and the Databricks environment. 
D)  All of the above statements are true. 
A)  Hadoop providers typically also provide Spark support. 
B)  Databricks is a Spark-specific vendor-they provide a "zero-management cloud platform built around Spark." Their website also is an excellent resource for learning Spark. 
C)  The paid Databricks platform runs on Amazon AWS or Microsoft Azure. Databricks also provides a free Databricks Community Edition, which is a great way to get started with both Spark and the Databricks environment. 
D)  All of the above statements are true. D

Question 3

Which of the following statements a), b) or c) is false?

Accepted Answer

A)  In the late 1960s, the Internet began as the xe "ARPANET"ARPANET, which initially connected four universities and grew to 10 nodes by the end of 1970. 
B)  In the last 50 years, the Internet has grown to billions of computers, smartphones, tablets and an enormous range of other device types connected to the Internet worldwide. 
C)  Every device is a "thing" in the xe "IoT (Internet of Things)"xe "Internet of Things (IoT)"Internet of Things (IoT). 
D)  All of the above statements are true. 
A)  In the late 1960s, the Internet began as the xe "ARPANET"ARPANET, which initially connected four universities and grew to 10 nodes by the end of 1970. 
B)  In the last 50 years, the Internet has grown to billions of computers, smartphones, tablets and an enormous range of other device types connected to the Internet worldwide. 
C)  Every device is a "thing" in the xe "IoT (Internet of Things)"xe "Internet of Things (IoT)"Internet of Things (IoT). 
D)  All of the above statements are true. C

Question 4

We created and ran a Spark streaming application which receives a stream of tweets on the topic(s) you specify and summarizes the top-20 hashtags in a bar chart that updates every 10 seconds. Which of the following statements a), b) or c) is false?

Accepted Answer

A)  One way for Spark streaming to receive data is via a network socket-a low-level view of xe "client/server networking"client/server networking in which a xe "client/server app:client"xe "client/server app:client¶"client app communicates with a xe "client/server app:server"xe "server in a client/server app"server app over a network. 
B)  Each xe "socket"socket represents one xe "endpoint:of a connection"endpoint of a connection. 
C)  A program can read from a socket or write to a socket similarly to reading from or writing to a SQL database. 
D)  All of the above statements are true. 
A)  One way for Spark streaming to receive data is via a network socket-a low-level view of xe "client/server networking"client/server networking in which a xe "client/server app:client"xe "client/server app:client¶"client app communicates with a xe "client/server app:server"xe "server in a client/server app"server app over a network. 
B)  Each xe "socket"socket represents one xe "endpoint:of a connection"endpoint of a connection. 
C)  A program can read from a socket or write to a socket similarly to reading from or writing to a SQL database. 
D)  All of the above statements are true.

Question 5

Hadoop streaming uses the standard input and standard output streams as follows:

Accepted Answer

A)  Hadoop supplies the input to the mapping script-called the mapper. This script reads its input from the standard input stream. The mapper writes its results to the standard output stream. 
B)  Hadoop supplies the mapper's output as the input to the reduction script-called the reducer-which reads from the standard input stream. 
C)  The reducer writes its results to the standard output stream. Hadoop writes the reducer's output to the Hadoop file system (HDFS). 
D)  All of the above statements are true. 
A)  Hadoop supplies the input to the mapping script-called the mapper. This script reads its input from the standard input stream. The mapper writes its results to the standard output stream. 
B)  Hadoop supplies the mapper's output as the input to the reduction script-called the reducer-which reads from the standard input stream. 
C)  The reducer writes its results to the standard output stream. Hadoop writes the reducer's output to the Hadoop file system (HDFS). 
D)  All of the above statements are true.

Question 6

Xe "author_ISBN table of books database"In a relational database, every foreign-key value must appear as the primary-key value in a row of another table so the DBMS can ensure that the foreign-key value is valid. This is known as the ________.

Accepted Answer

A)  Rule of Entity Integrity 
B)  xe "Rule of Referential Integrity"Rule of Referential Integrity 
C)  Rule of Guaranteed Access 
D)  None of the above 
A)  Rule of Entity Integrity 
B)  xe "Rule of Referential Integrity"Rule of Referential Integrity 
C)  Rule of Guaranteed Access 
D)  None of the above

Question 7

When you subscribe to a PubNub stream, you must add a(n) ________ that receives status notifications and messages from the channel.

Accepted Answer

A)  acceptor 
B)  auditor 
C)  listener 
D)  None of the above 
A)  acceptor 
B)  auditor 
C)  listener 
D)  None of the above

Question 8

Which of the following statements is false?

Accepted Answer

A)  You can use SQL to query data in xe "resilient distributed dataset (RD
D) "resilient distributed datasets (RDDs). 
B)  Spark SQL uses a Spark DataFrame to get a table view of the underlying RDDs. 
C)  A SparkSession (module pyspark.sql) is used to create a xe "DataFrame (Spark)"xe "modules:pyspark.sql"xe "pyspark.sql module"xe "modules:pyspark.sql"xe "DataFrame (Spark):pyspark.sql module"DataFrame from an xe ""RDD. There can be only one SparkSession object per Spark application. 
D)  In Spark streaming, a DStream is a sequence of xe "RDD (resilient distributed dataset)"xe "resilient distributed dataset (RD
D) "RDDs each representing a mini-batch of data to process 
A)  You can use SQL to query data in xe "resilient distributed dataset (RD
D) "resilient distributed datasets (RDDs). 
B)  Spark SQL uses a Spark DataFrame to get a table view of the underlying RDDs. 
C)  A SparkSession (module pyspark.sql) is used to create a xe "DataFrame (Spark)"xe "modules:pyspark.sql"xe "pyspark.sql module"xe "modules:pyspark.sql"xe "DataFrame (Spark):pyspark.sql module"DataFrame from an xe ""RDD. There can be only one SparkSession object per Spark application. 
D)  In Spark streaming, a DStream is a sequence of xe "RDD (resilient distributed dataset)"xe "resilient distributed dataset (RD
D) "RDDs each representing a mini-batch of data to process

Question 9

Which of the following statements is false?

Accepted Answer

A)  You'll often select only a subset of the rows in a database that satisfy certain xe "selection criteria"selection criteria. 
B)  Only xe "row in a database table"rows that satisfy the selection criteria mentioned in Part (a)-formally called xe "predicate"predicates-are selected. 
C)  SQL's Wxe "WHERE SQL clause"HERE clause specifies a query's selection criteria. 
D)  The following code selects from a titles table the title, edition and copyright for all books with the copyright year 2016:
Pd)read_sql("""SELECT title, edition, copyright
FROM titles
WHERE copyright > '2016'""", connection) 
A)  You'll often select only a subset of the rows in a database that satisfy certain xe "selection criteria"selection criteria. 
B)  Only xe "row in a database table"rows that satisfy the selection criteria mentioned in Part (a)-formally called xe "predicate"predicates-are selected. 
C)  SQL's Wxe "WHERE SQL clause"HERE clause specifies a query's selection criteria. 
D)  The following code selects from a titles table the title, edition and copyright for all books with the copyright year 2016:
Pd)read_sql("""SELECT title, edition, copyright
FROM titles
WHERE copyright > '2016'""", connection)

Question 10

Which of the following statements a), b) or c) is false?

Accepted Answer

A)  Every time you start a container with docker run, Docker gives you a new instance that contains any libraries you installed previously. 
B)  The command docker stop container_name
Will shut down the specified container. The command
Docker restart container_name
Will restart the specified container. 
C)  Docker also provides a GUI app called xe "Kitematic (Docker GUI app)"Kitematic that you can use to manage your containers, including stopping and restarting them. 
D)  All of the above statements are true. 
A)  Every time you start a container with docker run, Docker gives you a new instance that contains any libraries you installed previously. 
B)  The command docker stop container_name
Will shut down the specified container. The command
Docker restart container_name
Will restart the specified container. 
C)  Docker also provides a GUI app called xe "Kitematic (Docker GUI app)"Kitematic that you can use to manage your containers, including stopping and restarting them. 
D)  All of the above statements are true.

Question 11

Which of the following statements a), b) or c) is false?

Accepted Answer

A)  As data continues growing exponentially, we want to learn from that data and do so at blazing speed. 
B)  Learning from big data requires sophisticated algorithms, hardware, software and networking designs. 
C)  With more data, and especially with big data, machine learning can be even more effective. 
D)  All of the above statements are true. 
A)  As data continues growing exponentially, we want to learn from that data and do so at blazing speed. 
B)  Learning from big data requires sophisticated algorithms, hardware, software and networking designs. 
C)  With more data, and especially with big data, machine learning can be even more effective. 
D)  All of the above statements are true.

Question 12

Which of the following statements is false?

Accepted Answer

A)  SQL can be used only to retrieve data from a relational database. 
B)  The pandas method read_sql uses a Cursor behind the scenes to execute queries and access the rows of the results. 
C)  The INSERT INTO statement inserts a xe "row in a database table"row into a table. 
D)  The SQL keywords INSERT INTO are followed by the table in which to insert the new row and a comma-separated list of column names in parentheses. 
A)  SQL can be used only to retrieve data from a relational database. 
B)  The pandas method read_sql uses a Cursor behind the scenes to execute queries and access the rows of the results. 
C)  The INSERT INTO statement inserts a xe "row in a database table"row into a table. 
D)  The SQL keywords INSERT INTO are followed by the table in which to insert the new row and a comma-separated list of column names in parentheses.

Question 13

Which of the following statements a), b) or c) is false?

Accepted Answer

A)  Docker is a tool for packaging software into containers that bundle everything required to execute that software across platforms. 
B)  Some software packages require complicated setup and configuration. For many of these, there are preexisting Docker containers that you can download for free and execute locally on your desktop or notebook computers. 
C)  You can create custom Docker containers that are configured with the versions of every piece of software and every library you used in your study. This would enable others to recreate the environment you used, then reproduce your work, and will help you reproduce your results at a later time. 
D)  All of the above statements are true. 
A)  Docker is a tool for packaging software into containers that bundle everything required to execute that software across platforms. 
B)  Some software packages require complicated setup and configuration. For many of these, there are preexisting Docker containers that you can download for free and execute locally on your desktop or notebook computers. 
C)  You can create custom Docker containers that are configured with the versions of every piece of software and every library you used in your study. This would enable others to recreate the environment you used, then reproduce your work, and will help you reproduce your results at a later time. 
D)  All of the above statements are true.

Question 14

Which of the following statements is false?

Accepted Answer

A)  For decades, relational database management systems (RDBMs) have been the standard in data processing. 
B)  RDBMs require xe "structured data"unstructured data that fits into neat rectangular tables. 
C)  As the size of the data and the number of tables and relationships increases, relational databases become more difficult to manipulate efficiently. 
D)  xe "NoSQL database"NoSQL and xe "NewSQL database"NewSQL databases have emerged to deal with the kinds of big data storage and processing demands that traditional relational databases cannot meet. 
A)  For decades, relational database management systems (RDBMs) have been the standard in data processing. 
B)  RDBMs require xe "structured data"unstructured data that fits into neat rectangular tables. 
C)  As the size of the data and the number of tables and relationships increases, relational databases become more difficult to manipulate efficiently. 
D)  xe "NoSQL database"NoSQL and xe "NewSQL database"NewSQL databases have emerged to deal with the kinds of big data storage and processing demands that traditional relational databases cannot meet.

Question 15

Which of the following statements about columnar databases a), b) or c) is false?

Accepted Answer

A)  A columnar database is similar to a relational database, but it stores unstructured data in columns rather than rows. 
B)  Because all of a column's elements are stored together, selecting all the data for a given column is more efficient. 
C)  Consider our authors table in the books database: first last
Id
1 Paul Deitel
2 Harvey Deitel
3 Abbey Deitel
4 Dan Quirk
5 Alexander Wald
If we consider each row as a Python tuple, the rows would be represented as (1, 'Paul', 'Deitel'), (2, 'Harvey', 'Deitel'), etc. In a columnar database, all the values for a given column would be stored together, as in (1, 2, 3, 4, 5), ('Paul', 'Harvey', 'Abbey', 'Dan', 'Alexander') and ('Deitel', 'Deitel', 'Deitel', 'Quirk', 'Wald'). 
D)  All of the above statements are true. 
A)  A columnar database is similar to a relational database, but it stores unstructured data in columns rather than rows. 
B)  Because all of a column's elements are stored together, selecting all the data for a given column is more efficient. 
C)  Consider our authors table in the books database: first last
Id
1 Paul Deitel
2 Harvey Deitel
3 Abbey Deitel
4 Dan Quirk
5 Alexander Wald
If we consider each row as a Python tuple, the rows would be represented as (1, 'Paul', 'Deitel'), (2, 'Harvey', 'Deitel'), etc. In a columnar database, all the values for a given column would be stored together, as in (1, 2, 3, 4, 5), ('Paul', 'Harvey', 'Abbey', 'Dan', 'Alexander') and ('Deitel', 'Deitel', 'Deitel', 'Quirk', 'Wald'). 
D)  All of the above statements are true.

Question 16

YouTube videos including the associated metadata are ________ data.

Accepted Answer

A)  semi-structured 
B)  structured 
C)  unstructured 
D)  None of the above 
A)  semi-structured 
B)  structured 
C)  unstructured 
D)  None of the above

Question 17

Which of the following statements is false?

Accepted Answer

A)  Two key Hadoop components are HDFS (Hadoop Distributed File System) for storing massive amounts of data throughout a cluster, and MapReduce for implementing the tasks that process the data. 
B)  Hadoop MapReduce is similar in concept to the functional-style programming, just on a xe "massively parallel processing"massively parallel scale. 
C)  A MapReduce task performs two steps-mapping and reduction. 
D)  The mapping step processes the original data across the entire cluster and maps it into tuples of key-value pairs. The reduction step, which also may include filtering, then combines those tuples to produce the results of the MapReduce task. 
A)  Two key Hadoop components are HDFS (Hadoop Distributed File System) for storing massive amounts of data throughout a cluster, and MapReduce for implementing the tasks that process the data. 
B)  Hadoop MapReduce is similar in concept to the functional-style programming, just on a xe "massively parallel processing"massively parallel scale. 
C)  A MapReduce task performs two steps-mapping and reduction. 
D)  The mapping step processes the original data across the entire cluster and maps it into tuples of key-value pairs. The reduction step, which also may include filtering, then combines those tuples to produce the results of the MapReduce task.

Question 18

Which of the following statements a), b) or c) is false?

Accepted Answer

A)  Each xe "column:in a database table"column in a relational database table represents a different data attribute. 
B)  Columns are unique (by primary key) within a table, but particular row values may be duplicated between columns. 
C)  Several rows in an Employee table's Department column could contain the same department number. 
D)  All of the above statements are true. 
A)  Each xe "column:in a database table"column in a relational database table represents a different data attribute. 
B)  Columns are unique (by primary key) within a table, but particular row values may be duplicated between columns. 
C)  Several rows in an Employee table's Department column could contain the same department number. 
D)  All of the above statements are true.

Question 19

Which of the following statements a), b) or c) is false?

Accepted Answer

A)  You can merge data from multiple tables, referred to as xe "joining database tables"joining the tables, with Ixe "INNER JOIN SQL clause"NNER JOIN. 
B)  The INNER JOIN's Oxe "ON clause"N clause uses a primary-key column in one table and a foreign-key column in the other table to determine which rows to merge from each table. 
C)  xe "qualified name"Qualified name syntax (tableName.columnName) is required if the columns have the same name in both tables. 
D)  All of the above statements are true. 
A)  You can merge data from multiple tables, referred to as xe "joining database tables"joining the tables, with Ixe "INNER JOIN SQL clause"NNER JOIN. 
B)  The INNER JOIN's Oxe "ON clause"N clause uses a primary-key column in one table and a foreign-key column in the other table to determine which rows to merge from each table. 
C)  xe "qualified name"Qualified name syntax (tableName.columnName) is required if the columns have the same name in both tables. 
D)  All of the above statements are true.

Question 20

Which of the following statements a), b) or c) is false?

Accepted Answer

A)  When Google was launched in 1998, there were approximately 2.4 million websites-truly big data at the time. Today there are now nearly two billion websites (almost a thousandfold increase since 1998). 
B)  When Google was developing their search engine, they knew that they needed to return search results quickly. The only practical way to do this was to store and index the entire Internet using a clever combination of secondary storage and main memory. 
C)  Popular computers of that time couldn't hold that amount of data and could not analyze that amount of data fast enough to guarantee prompt search-query responses. 
D)  All of the above statements are true. 
A)  When Google was launched in 1998, there were approximately 2.4 million websites-truly big data at the time. Today there are now nearly two billion websites (almost a thousandfold increase since 1998). 
B)  When Google was developing their search engine, they knew that they needed to return search results quickly. The only practical way to do this was to store and index the entire Internet using a clever combination of secondary storage and main memory. 
C)  Popular computers of that time couldn't hold that amount of data and could not analyze that amount of data fast enough to guarantee prompt search-query responses. 
D)  All of the above statements are true.

Xe "author_ISBN table of books database"In SQL, a foreign key is a column in one table that matches a ________ column in another table.

Which of the following statements a), b) or c) is false?

Which of the following statements a), b) or c) is false?

We created and ran a Spark streaming application which receives a stream of tweets on the topic(s) you specify and summarizes the top-20 hashtags in a bar chart that updates every 10 seconds. Which of the following statements a), b) or c) is false?

Hadoop streaming uses the standard input and standard output streams as follows:

Xe "author_ISBN table of books database"In a relational database, every foreign-key value must appear as the primary-key value in a row of another table so the DBMS can ensure that the foreign-key value is valid. This is known as the ________.

When you subscribe to a PubNub stream, you must add a(n) ________ that receives status notifications and messages from the channel.

Which of the following statements is false?

Which of the following statements is false?

Which of the following statements a), b) or c) is false?

Which of the following statements a), b) or c) is false?

Which of the following statements is false?

Which of the following statements a), b) or c) is false?

Which of the following statements is false?

Which of the following statements about columnar databases a), b) or c) is false?

YouTube videos including the associated metadata are ________ data.

Which of the following statements is false?

Which of the following statements a), b) or c) is false?

Which of the following statements a), b) or c) is false?

Which of the following statements a), b) or c) is false?

Introduction to Computers and Python

Introduction to Python Programming

Control Statements and Program Development

Functions

Sequences: Lists and Tuples

Dictionaries and Sets

Array-Oriented Programming With Num

Strings: a Deeper Look

Files and Exceptions

Object-Oriented Programming

Computer Science Thinking: Recursion, Searching, Sorting and Big O

Natural Language Processing

Data Mining Twitter

Ibm Watson and Cognitive Computing

Machine Learning: Classification, Regression and Clustering

Deep Learning

Filters

Exam 17: Big Data: Hadoop, Spark, Nosql and Iot

Xe "author_ISBN table of books database"In SQL, a foreign key is a column in one table that matches a ________ column in another table.

Which of the following statements a), b) or c) is false?

Which of the following statements a), b) or c) is false?

We created and ran a Spark streaming application which receives a stream of tweets on the topic(s) you specify and summarizes the top-20 hashtags in a bar chart that updates every 10 seconds. Which of the following statements a), b) or c) is false?

Hadoop streaming uses the standard input and standard output streams as follows:

Xe "author_ISBN table of books database"In a relational database, every foreign-key value must appear as the primary-key value in a row of another table so the DBMS can ensure that the foreign-key value is valid. This is known as the ________.

When you subscribe to a PubNub stream, you must add a(n) ________ that receives status notifications and messages from the channel.

Which of the following statements is false?

Which of the following statements is false?

Which of the following statements a), b) or c) is false?

Which of the following statements a), b) or c) is false?

Which of the following statements is false?

Which of the following statements a), b) or c) is false?

Which of the following statements is false?

Which of the following statements about columnar databases a), b) or c) is false?

YouTube videos including the associated metadata are ________ data.

Which of the following statements is false?

Which of the following statements a), b) or c) is false?

Which of the following statements a), b) or c) is false?

Which of the following statements a), b) or c) is false?

Introduction to Computers and Python

Introduction to Python Programming

Control Statements and Program Development

Functions

Sequences: Lists and Tuples

Dictionaries and Sets

Array-Oriented Programming With Num

Strings: a Deeper Look

Files and Exceptions

Object-Oriented Programming

Computer Science Thinking: Recursion, Searching, Sorting and Big O

Natural Language Processing

Data Mining Twitter

Ibm Watson and Cognitive Computing

Machine Learning: Classification, Regression and Clustering

Deep Learning

Filters