Managing Big Data with MySQL Coursera Quiz Answers

Get Managing Big Data with MySQL Coursera Quiz Answers

Managing Big Data with MySQL Week 01 Quiz Answers

Week 1 Graded Quiz

Q1. Relational databases are based on which mathematical theory or field?

• Set theory
• Probability theory
• Matrix algebra
• Information theory

Q2. YearsInBusiness in the ER diagram above is a:

• Candidate key
• Composite attribute
• Derived attribute
• Unique attribute

Q3.Which of the following is true about cardinality constraints on the relationship between Doctor and Outpatient Location depicted in this ER diagram?

• An outpatient location must have 1 doctor working at it, but can have no more than 1 doctor working at it.
• A doctor is required to work at one outpatient location, but can work at no more than 1 outpatient location.
• An outpatient location must have at least 1 doctor working at it, but can have many doctors working at it.
• A doctor can work at many outpatient locations, but does not have to work at any.

Q4. Which columns would be necessary for identifying unique doctors in the doctor table of the database built from the relational schema excerpt above?

• You could use either LicenseNo or State
• LicenseNo
• You would have to use both LicenseNo and State
• State

Q5.In the ER diagram above, Doctor_ID and OL_ID are called:

• Composite attributes or keys
• Primary keys
• Unique attributes
• Foreign keys

Q6. Which type of information is most likely to be stored in a relational database as opposed to another type of database?

• Metadata (file name, file location, when the file was created, etc.) about pictures
• Texts
• Pictures
• Tweets

Q7. What can you infer about the data being collected based on the relational schema above?

• A doctor can only work at one outpatient location, but an outpatient location can have many doctors working at it
• The data collected in OL_ID of the WorksAt table, on its own, is sufficient to determine at which outpatient location(s) each doctor works
• A doctor can work at many outpatient locations, and an outpatient location can have many doctors working at it
• The data collected in OL_ID of the OutpatientLocation table, on its own, is sufficient to determine at which outpatient location(s) each doctor works

Q8. Based on the diagram above, which attribute(s) can be used to identify unique books?

• BookName
• BookName and WriterID
• BookName and EditorID
• BookName and BookPubDate

Q9. Which of the following statements are true about foreign keys? Check all that apply. (Note that you will need to select more than one correct response to answer this question correctly.)

• Foreign keys allow information in different tables to be linked to each other
• Foreign keys are columns with unique values for every row in the relation/table they are in
• Foreign keys refer to columns with unique values for every row in other relations/tables
• Foreign keys always have the same name as at least one primary key in another table

Q10.Given the relational schema presented above, how many tables would you need to use in order to determine the outpatient location(s) a doctor named “Karen Smith” works at?

• 2 or 3, depending on the strategy you use to combine the information
• 2
• 1
• 3

Q11. Which of the following is true about cardinality constraints on the relationship between Doctor and Outpatient Location depicted in this ER diagram?

• A doctor can work at many outpatient locations, but does not have to work at any.
• An outpatient location must have at least 1 doctor working at it, but can have many doctors working at it.
• A doctor is required to work at one outpatient location, but can work at no more than 1 outpatient location.
• Each outpatient location must have 1 doctor working at it, but can have no more than 1 doctor working at it.

Q12. Which of the following statements are true about the technical terms (as opposed to the common terms) for the concepts represented by relational schemas?

• The technical term for items in a relational schema that become rows in a real database is “tuples.”
• The technical term for items in a relational schema that become columns in a real database is “fields”
• The technical term for items in a relational schema that become tables in a real database is “entities”

Q13. Based on the diagram above, which of the following is true?

• ShowID and ShowVenue are needed together to provide a unique identifier for each show
• ShowDate and ShowVenue are needed together to provide a unique identifier for each show
• ShowType and ShowName are needed together to provide a unique identifier for each show
• ShowType and ShowVenue are needed together to provide a unique identifier for each show

Q14. If this relational schema represented a database that was already implemented, what columns would you use to combine the information in the transactions table with the information in the departinfo table?

• “store” to connect the transactions table to the storeinfo table, and then “deptname” to connect the storeinfo table to the deptinfo table
• “sku” to connect the transactions table to the skuinfo table, and then “deptname” to connect the skuinfo table to the deptinfo table
• sku” to connect the transactions table to the skuinfo table, and then “deptID” to connect the skuinfo table to the deptinfo table
• “deptname” to connect the transactions table to the deptinfo table

Q15. For relational databases to work most efficiently, which of the following requirements of set theory should be followed? Check all that apply. (Note that you will need to select more than one correct response to answer this question correctly.)

• Each row in a table should represent a unique instance of the information in that table
• Each column in a table should represent a unique category of information
• Single tables should represent the smallest logical parts of a data set
• There should be no NULL values allowed in the database

Managing Big Data with MySQL Week 02 Quiz Answers

Week 2 Graded Quiz using Teradata

Q1. Have you completed the week 2 Teradata practice exercises guide?

Note: This question is to encourage good study practices and will not be reflected in the answer sheet.

• Yes
• No

Q2. Which of the following keywords are required in any query to retrieve data from a relational database?

• WHERE
• GROUP (BY)
• SELECT
• HAVING
• ORDER (BY)

Q3. Which of the following database systems recognize the keyword “LIMIT” to limit the number of rows displayed from a query output?

• Teradata
• MySQL
• Neither
• Both

Q4. Which keywords could you use to determine the names of the columns contained in a table?

• HELP in MySQL and COLUMNS in Teradata
• DESCRIBE in MySQL and HELP in Teradata
• COLUMNS in MySQL and SHOW in Teradata
• SHOW in MySQL and DESCRIBE in Teradata

Q5. In how many columns of the STRINFO table of the Dillard’s database are NULL values *permitted*?

• 1
• 3
• 0
• 2

Q6. In how many columns of the STRINFO table of the Dillard’s database are NULL values *present*?

• 0
• 1
• 3
• 2

Q7. What was the highest original price in the Dillard’s database of the item with SKU 3631365?

• $20.00
• $15.50
• $12.00
• $17.50

Q8. What is the color of the Liz Claiborne brand item with the highest SKU # in the Dillard’s database (the Liz Claiborne brand is abbreviated “LIZ CLAI” in the Dillard’s database)?

• HTR GREY
• ORANGE
• TEAK CBO
• CLAY

Q9. What aspect of the following query will make the query crash?

SELECT SKU, orgprice, sprice, amt,

FROM TRNSACT

WHERE AMT>50

• There is no semi-colon at the end of the query
• “orgprice”, “sprice”, and “amt” are in lowercase letters in the first line of the query
• There is no TOP statement
• There is a comma after “amt” in the first line of the query

Q10. What is the sku number of the item in the Dillard’s database that had the highest original sales price?

• 4628597
• 6200173
• 7298484
• 4420360

Q11. According to the strinfo table, in how many states within the United States are Dillard’s stores located? (HINT: the bottom of the SQL scratchpad reports the number of rows in your output)

• 31
• 48
• 20
• 33

Q12. How many Dillard’s departments start with the letter “e”

• 5
• 1
• 7
• 3

Q13. What was the date of the earliest sale in the database where the sale price of the item did not equal the original price of the item, and what was the largest margin (original price minus sale price) of an item sold on that earliest date?

• 04/08/01, $510.00
• 05/01/28, $412.50
• 04/10/10, $475.94
• 04/12/24, $458.70

Q14. What register number recorded the transaction with the highest original price and highest sale price between the dates of August 1, 2004 and August 10, 2004? Make sure to sort by original price first and sale price second.

• 390
• 90
• 621
• 431

Q15. Which of the following brand names with the word/letters “liz” in them exist in the Dillard’s database? Select all that apply. Note that you will need more than a single correct selection to answer the question correctly.

• REVITALIZE
• BELIZA
• CIVILIZE
• LIZ MOOR

Q16. What is the lowest store number of all the stores in the STORE_MSA table that are in the city of “little rock”,”memphis”, or “tulsa”?

• 204
• 9906
• 1204
• 504

Managing Big Data with MySQL Week 03 Quiz Answers

Week 3 Graded Quiz using Teradata

Q1. Have you completed the week 3 Teradata practice exercises guide?

Note: This question is to encourage good study practices and will not be reflected in the answer sheet.

• Yes
• No

Q2. It is important that you work through the Teradata exercises for before attempting this quiz!

Given Table A (first table to be entered in the query) and Table B (second table to be entered in the query) the query result shown below is a result of what kind of join?

• Inner Join
• Left Join
• Full Outer Join
• Right Join

Q3. On what day was Dillard’s income based on total sum of purchases the greatest

• 05/02/28
• 05/02/01
• 04/12/18
• 04/11/01

Q4. What is the deptdesc of the departments that have the top 3 greatest numbers of skus from the skuinfo table associated with them?

• INVEST, POLOMEN, BRIOSO
• BORA, C KLEIN, BLUE
• CLINIQUE, CELEBRT, NOB
• LACOSTE, LOUISVL, LESLIE

Q5. Which table contains the most distinct sku numbers?

• skuinfo
• transact
• skstinfo
• deptinfo

Q6. How many skus are in the skstinfo table, but NOT in the skuinfo table?

• 0
• 2388
• 803,966
• 90,334

Q7. What is the average amount of profit Dillard’s made per day?

• $400,893,380
• $6,921,454
• $1,527,903
• $30,222,191

Q. The store_msa table provides population statistics about the geographic location around a store. Using one query to retrieve your answer, how many MSAs are there within the state of North Carolina (abbreviated “NC”), and within these MSAs, what is the lowest population level (msa_pop) and highest income level (msa_income)?

• 16 MSAs, lowest population of 339,511, highest income level of $36,151
• 12 MSAs, lowest population of 339,511, highest income level of $56,099
• 12 MSAs, lowest population of 5,797, highest income level of $26,879
• 16 MSAs, lowest population of 439,117, highest income level of $26,879

Q9. What department (with department description), brand, style, and color brought in the greatest total amount of sales?

• Department 6400 described as Blue, brand Designer, style 6 7002-9, color edp spray
• Department 800 described as Clinique, brand Clinique, style 6142, color DDML
• Department 4407 described as Environ, brand Silver C, style TO02SCBELT-S , color silver
• Department 2200 described as Celebrt, brand Lancome, style 1924, color resol eye

Q10. How many stores have more than 180,000 distinct skus associated with them in the skstinfo table?

• 4
• 20
• 31
• 12

Q11. Look at the data from all the distinct skus in the “cop” department with a “federal” brand and a “rinse wash” color. You’ll see that these skus have the same values in some of the columns, meaning that they have some features in common.

In which columns do these skus have different values from one another, meaning that their features differ in the categories represented by the columns? Choose all that apply. Note that you will need more than a single correct selection to answer the question correctly.

• style
• size
• vendor
• pack size

Q12. How many skus are in the skuinfo table, but NOT in the skstinfo table?

• 0
• 90,334
• 2388
• 803,966

Q13. In what city and state is the store that had the greatest total sum of sales?

• McAllen, TX
• Dallas, TX
• Little Rock, AK
• Metairie, LA

Q14. Given Table A (first table to be entered in the query) and Table B (second table to be entered in the query) the query result shown below is a result of what kind of join?

• Left Join
• Inner Join
• Full Outer Join
• Right Join

Q15. How many states have more than 10 Dillards stores in them?

• 9
• 15
• 24
• 5

Q16. What is the suggested retail price of all the skus in the “reebok” department with the “skechers” brand and a “wht/saphire” color?

• $29.00
• $19.00
• $4.00
• $39.00

Managing Big Data with MySQL Week 04 Quiz Answers

Week 4 Graded Quiz using Teradata

Q1. Have you completed the week 5 Teradata practice exercises guide?

Note: This question is to encourage good study practices and will not be reflected in the answer sheet.

• Yes
• No

Q2. How many distinct skus have the brand “Polo fas”, and are either size “XXL” or “black” in color?

• 13,623
• 84
• 5,224
• 27,271

Q3. There was one store in the database which had only 11 days in one of its months (in other words, that store/month/year combination only contained 11 days of transaction data). In what city and state was this store located?

• Atlanta, GA
• Tulsa, OK
• Little Rock, AR
• Richmond, VA

Q4. Which sku number had the greatest increase in total sales revenue from November to December?

• 6966816
• 2637537
• 4737469
• 3949538

Q5. What vendor has the greatest number of distinct skus in the transaction table that do not exist in the skstinfo table? (Remember that vendors are listed as distinct numbers in our data set).

• 3313116
• 9514659
• 5511283
• 5715232

Q6. What is the brand of the sku with the greatest standard deviation in sprice? Only examine skus which have been part of over 100 transactions.

• Vanity F
• Clinique
• Polo Fas
• Hart Sch

Q7. What is the city and state of the store which had the greatest increase in average daily revenue (as defined in Teradata Week 5 Exercise Guide) from November to December?

• Metairie, LA
• McAllen, TX
• Little Rock, AK
• Tucson, AZ

Q8. Compare the average daily revenue (as defined in Teradata Week 5 Exercise Guide) of the store with the highest msa_income and the store with the lowest median msa_income (according to the msa_income field). In what city and state were these two stores, and which store had a higher average daily revenue?

• The store with the highest median msa_income was in Spanish Fort, AL. It had a lower average daily revenue than the store with the lowest median msa_income, which was in McAllen, TX.
• The store with the highest median msa_income was in Littleton, CO. It had a higher average daily revenue than the store with the lowest median msa_income, which was in Cincinnati, OH.
• The store with the highest median msa_income was in McAllen, TX. It had a higher average daily revenue than the store with the lowest median msa_income, which was in Spanish Fort, AL.
• The store with the highest median msa_income was in Cincinnati, OH. It had a lower average daily revenue than the store with the lowest median msa_income, which was in Littleton, CO.

Q9. Divide the msa_income groups up so that msa_incomes between 1 and 20,000 are labeled ‘low’, msa_incomes between 20,001 and 30,000 are labeled ‘med-low’, msa_incomes between 30,001 and 40,000 are labeled ‘med-high’, and msa_incomes between 40,001 and 60,000 are labeled ‘high’. Which of these groups has the highest average daily revenue (as defined in Teradata Week 5 Exercise Guide) per store?

• med-low
• med-high
• high
• low

Q10. Divide stores up so that stores with msa populations between 1 and 100,000 are labeled ‘very small’, stores with msa populations between 100,001 and 200,000 are labeled ‘small’, stores with msa populations between 200,001 and 500,000 are labeled ‘med_small’, stores with msa populations between 500,001 and 1,000,000 are labeled ‘med_large’, stores with msa populations between 1,000,001 and 5,000,000 are labeled “large”, and stores with msa_population greater than 5,000,000 are labeled “very large”. What is the average daily revenue (as defined in Teradata Week 5 Exercise Guide) for a store in a “very large” population msa?

• $24,341
• $6,298
• $16,355
• $25,452

Q11. Which department in which store had the greatest percent increase in average daily sales revenue from November to December, and what city and state was that store located in? Only examine departments whose total sales were at least $1,000 in both November and December.

• Gottex department, Pine Bluff, AR
• Louisvl department, Salina, KS
• Clinique department, Odessa, TX
• Jacques department, Jackson, MS

Q12. Which department within a particular store had the greatest decrease in average daily sales revenue from August to September, and in what city and state was that store located?

• Clinique department, Louisville, KY
• Clinique department, Cincinnati, OH
• Polomen department, Greenville, SC
• Polomen department, Knoxville, TN

Q13. Identify which department, in which city and state of what store, had the greatest DECREASE in the number of items sold from August to September. How many fewer items did that department sell in September compared to August?

• The R Lauren department in Toledo, OH sold 12,009 fewer items
• The Clinique department in Greenville, SC sold 18,553 fewer items
• The Clinique department in Louisville, KY sold 13,491 fewer items
• The R Lauren department in Charlotte, NC sold 5,856 fewer items

Q14For each store, determine the month with the minimum average daily revenue (as defined in Teradata Week 5 Exercise Guide) . For each of the twelve months of the year, count how many stores’ minimum average daily revenue was in that month. During which month(s) did over 100 stores have their minimum average daily revenue?

• August and September
• January and August
• January and September
• August only

Q15. Write a query that determines the month in which each store had its maximum number of sku units returned. During which month did the greatest number of stores have their maximum number of sku units returned?

• March
• January
• September
• December

Get All Course Quiz Answers of Excel to MySQL: Analytic Techniques for Business Specialization

Business Metrics for Data-Driven Companies Quiz Answers

Mastering Data Analysis in Excel Coursera Quiz Answers

Data Visualization and Communication with Tableau Quiz Answers

Managing Big Data with MySQL Coursera Quiz Answers