Posts

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...
6 comments
Read more

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...
2 comments
Read more

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...
4 comments
Read more