Big Data Integration and Processing
Quiz 9 Answer
Quiz 9 - Check Your Query Results
Q1) How many tweets have location not null?
- 6937
- 6945
- 5957
- 6973
- No option applicable.
Q2) How many people have more followers than friends? (Hint : use this.user instead of user).
- 6238
- 5809
- 5590
- 6673
- 5206
Q3) Perform a query that returns the text of tweets which have the string "http://". Which of the following substrings do NOT occur in the results? (Choose all that apply)
- @Infosmessi_
- @DundalkFC
- @Ass0Star
- @espn
- @TerraceImages
Q4) Query: Return all the tweets which contain text "England" but not "UEFA". In these results the string “Euro 2016” appears in...
- 2 tweets
- 3 tweets
- 0 tweets
- More than 6 tweets.
- 5 tweets
Q5) Query: Get all the tweets from the location "Ireland" which also contain the string "UEFA". In this result the user with the highest friends count is...
- Pauldonaghue
- ProfitwatchInfo
- irishexaminer
- DerekRantsGames
- Insight4News4
--------------------------------------------------------------------------------------------------------------------------------------------------------
Big Data Integration and Processing
0 Comments