Coursera | Big Data Specialization | Big Data Modeling and Management Systems | Quiz Week 2

Week 2
(Questions 1-3 pertain to the video lecture “Exploring the
Relational Data Model of CSV”)
Note: Correct answers are in Bold.

1. What is the approximate population of La Paz county in the state of
Arizona for the CENSUS2010POP (column H)? (Choose the best
answer.)
25000
10000
15000
20000


2. What county in the state of Wyoming has the smallest estimated
population?
Sweetwater
Uinta
Platte
Niobrara

3.At 2:45 of the video, the Instructor creates a filter for all of the
counties in California with a population greater than 1000000.
However, included in the results is the entire state of California.
This anomalous value might skew our analysis if, for example, we
wanted to compute the average population of these results. What
additional filter(s) might work to resolve this problem? (Select all
that apply)
a) Add a filter to detect and remove results which do not
include the word “county” in column G.
b) Add a filter which finds all counties with population greater than 1,000,000 AND less than 10,000,000 for
column H (CENSUS2010POP).
c) Add a filter where the value in column E is greater than
1,000,000.
d) Add a filter to detect and remove results which include
the word "California" in column G.

4. (Questions 4 and 5 pertain to the video "Exploring Sensor
Data")
How often (in seconds) do the R5 measurements occur?
50
60
30
40

5。What is the field for rain accumulation?
Dx
Sm
Rc
Dn

6。
(Questions 6 and 7 pertain to the video lecture "Exploring the
Array Data Model of an Image")
What is the (Red, Green, Blue) pixel value for location 500, 2000?

(134, 145, 46)
(163, 118, 79)

(100, 123, 149)
(50, 156, 182)


7。Is this value likely to be land or ocean?

Ocean
Land

8. (Questions 8 and 9 pertain to the video lecture "Exploring the
Semistructured Data Model of JSON")
Given a tweet, what path would you most likely enter to obtain a
count of the number of followers for a user?

user/followers_count 
user/statuses_count
user/listed_count
None of the above

9。
Which of the following fields are nested within the ‘entities’ field
(select all that apply)?


urls

tweets

views

user_mentions

events


symbols

Comments

  1. 360digitmgdelhiMarch 24, 2021 at 5:09 AM

    Thank you for sharing wonderful content
    data analytics course in delhi

    ReplyDelete
  2. sam kirubakarJanuary 27, 2022 at 2:54 AM

    This comment has been removed by the author.

    ReplyDelete
  3. sam kirubakarFebruary 11, 2022 at 1:37 AM

    This comment has been removed by the author.

    ReplyDelete
  4. traininginstituteApril 23, 2022 at 1:34 AM

    I curious more interest in some of them hope you will give more information on this topics in your next articles.
    data science training

    ReplyDelete

Post a Comment

Popular posts from this blog

Coursera | Big Data Specialization | Big Data Modeling and Management Systems | Quiz Week 3 Data Models Quiz

 Data Models Quiz Week 3 Note: Correct answers are in the bold and underlined word. 1。 What is a possible pitfall of utilizing Excel as a way to manipulate small databases? Excel is a user program and thus cannot run on a server. Excel does not allow algorithms for data manipulation. Excel does not enforce many principles of relational data models. 2。 What does the term “atomic” mean in the context of relational databases? A tuple that cannot be reduced. A column or row of data. Depends on the context. One unit of information that cannot be decomposed. For more information about the following concept, please view here. Fixed schema of a particular database. 3。 What is the Pareto-Optimality problem? Find the best possible path given two or more optimization criteria where neither constraint can be fully optimized simultaneously. Find the shortest path from source node to target node. Find the optimal path that requires going through specific nodes gi...
Read more

Coursera | Big Data Specialization | Big Data Modeling and Management Systems | Quiz Week 4

Data Formats and Streaming Data Quiz 1。What is true between data modeling and the formatting of the data? The data does not necessarily need to be formatted in a way that represents the data model. Just so long as it can be extrapolated. For more information related to this concept, please click here. There is always one specific schema for storing model data that is the best and preferred method for the specific data representation. There is a one to one correspondence between formatting data and data modeling. For every model of data, there is only one way to store the data. 2。What is streaming? Calculating results using real time data otherwise known as streaming data. Using static data stored from a real time source in order to process and guide the application. Utilizing real time data to compute and change the state of an application continuously. For more information related to this concept, please click here. Using sensors to manipulate the syst...
Read more