Managing Big Data with MySQL Quiz Answer. In this post you will get Quiz & Assignment Answer Of Managing Big Data with MySQL Quiz
Managing Big Data with MySQL Quiz
Offered By ”Duke University”
Week 1 Graded Quiz
1.
Question 1
Relational databases are based on which mathematical theory or field?
1 point
- Probability theory
- Matrix algebra
- Information theory
- Set theory
=================================================
2.
Question 2
YearsInBusiness in the ER diagram above is a:
1 point
- Unique attribute
- Candidate key
- Derived attribute
- Composite attribute
=================================================
3.
Question 3
Which of the following is true about cardinality constraints on the relationship between Doctor and Outpatient Location depicted in this ER diagram?
1 point
- A doctor can work at many outpatient locations, but does not have to work at any.
- 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 1 doctor working at it, but can have no more than 1 doctor working at it.
- An outpatient location must have at least 1 doctor working at it, but can have many doctors working at it.
=================================================
4.
Question 4
Which columns would be necessary for identifying unique doctors in the doctor table of the database built from the relational schema excerpt above?
1 point
- LicenseNo
- You could use either LicenseNo or State
- You would have to use both LicenseNo and State
- State
=================================================
5.
Question 5
In the ER diagram above, Doctor_ID and OL_ID are called:
1 point
- Composite attributes or keys
- Unique attributes
- Foreign keys
- Primary keys
=================================================
6.
Question 6
Which type of information is most likely to be stored in a relational database as opposed to another type of database?
1 point
- Metadata (file name, file location, when the file was created, etc.) about pictures
- Tweets
- Pictures
- Texts
=================================================
7.
Question 7
What can you infer about the data being collected based on the relational schema above?
1 point
- 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
- A doctor can only work at one outpatient location, but an outpatient location can have many doctors working at it
- 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 WorksAt table, on its own, is sufficient to determine at which outpatient location(s) each doctor works
=================================================
8.
Question 8
Based on the diagram above, which attribute(s) can be used to identify unique books?
1 point
- BookName
- BookName and WriterID
- BookName and BookPubDate
- BookName and EditorID
=================================================
9.
Question 9
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.)
1 point
- 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
=================================================
10.
Question 10
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?
1 point
- 2
- 1
- 3
- 2 or 3, depending on the strategy you use to combine the information
=================================================
11.
Question 11
Which of the following is true about cardinality constraints on the relationship between Doctor and Outpatient Location depicted in this ER diagram?
1 point
- Each 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.
=================================================
12.
Question 12
Which of the following statements are true about the technical terms (as opposed to the common terms) for the concepts represented by relational schemas?
1 point
- 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 tables in a real database is “entities”
- The technical term for items in a relational schema that become columns in a real database is “fields”
=================================================
13.
Question 13
Based on the diagram above, which of the following is true?
1 point
- ShowType 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
- ShowDate and ShowVenue are needed together to provide a unique identifier for each show
- ShowID and ShowVenue are needed together to provide a unique identifier for each show
=================================================
14.
Question 14
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?
1 point
- “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 “deptID” to connect the skuinfo 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
- “deptname” to connect the transactions table to the deptinfo table
=================================================
15.
Question 15
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.)
1 point
- 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
Week 2 Graded Quiz using Teradata
1.
Question 1
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.
1 point
Yes
No
=================================================
2.
Question 2
Which of the following keywords are required in any query to retrieve data from a relational database?
1 point
FROM
WHERE
ORDER (BY)
HAVING
GROUP (BY)
=================================================
3.
Question 3
Which of the following database systems recognize the keyword “LIMIT” to limit the number of rows displayed from a query output?
1 point
Neither
Both
Teradata
MySQL
=================================================
4.
Question 4
Which keywords could you use to determine the names of the columns contained in a table?
1 point
DESCRIBE in MySQL and HELP in Teradata
COLUMNS in MySQL and SHOW in Teradata
SHOW in MySQL and DESCRIBE in Teradata
HELP in MySQL and COLUMNS in Teradata
=================================================
5.
Question 5
In how many columns of the STRINFO table of the Dillard’s database are NULL values *permitted*?
1 point
1
2
3
0
=================================================
6.
Question 6
In how many columns of the STRINFO table of the Dillard’s database are NULL values *present*?
1 point
3
2
1
0
=================================================
7.
Question 7
What was the highest original price in the Dillard’s database of the item with SKU 3631365?
1 point
$12.00
$20.00
$17.50
$15.50
=================================================
8.
Question 8
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)?
1 point
CLAY
TEAK CBO
HTR GREY
ORANGE
=================================================
9.
Question 9
What aspect of the following query will make the query crash?
SELECT SKU, orgprice, sprice, amt,
FROM TRNSACT
WHERE AMT>50
1 point
There is a comma after “amt” in the first line 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 no semi-colon at the end of the query
=================================================
10.
Question 10
What is the sku number of the item in the Dillard’s database that had the highest original sales price?
1 point
4628597
4420360
7298484
6200173
=================================================
11.
Question 11
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)
1 point
31
33
20
48
=================================================
12.
Question 12
How many Dillard’s departments start with the letter “e”
1 point
3
5
7
1
=================================================
13.
Question 13
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?
1 point
04/10/10, $475.94
04/08/01, $510.00
04/12/24, $458.70
05/01/28, $412.50
=================================================
14.
Question 14
What register number made the sale 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.
1 point
90
390
431
621
=================================================
15.
Question 15
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.
1 point
REVITALIZE
CIVILIZE
BELIZA
LIZ MOOR
=================================================
16.
Question 16
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”?
1 point
204
504
9906
1204
Week 3 Graded Quiz using Teradata
1.
Question 1
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.
1 point
Yes
No
=================================================
2.
Question 2
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?
1 point
Right Join
Inner Join
Full Outer Join
Left Join
=================================================
3.
Question 3
On what day was Dillard’s income based on total sum of purchases the greatest
1 point
04/11/01
05/02/28
04/12/18
05/02/01
=================================================
4.
Question 4
What is the deptdesc of the departments that have the top 3 greatest numbers of skus from the skuinfo table associated with them?
1 point
CLINIQUE, CELEBRT, NOB
INVEST, POLOMEN, BRIOSO
BORA, C KLEIN, BLUE
LACOSTE, LOUISVL, LESLIE
=================================================
5.
Question 5
Which table contains the most distinct sku numbers?
1 point
deptinfo
skuinfo
skstinfo
transact
=================================================
6.
Question 6
How many skus are in the skstinfo table, but NOT in the skuinfo table?
1 point
803,966
2388
90,334
0
=================================================
7.
Question 7
What is the average amount of profit Dillard’s made per day?
1 point
$6,921,454
$1,527,903
$400,893,380
$30,222,191
=================================================
8.
Question 8
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)?
1 point
16 MSAs, lowest population of 439,117, highest income level of $26,879
12 MSAs, lowest population of 5,797, highest income level of $26,879
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
=================================================
9.
Question 9
What department (with department description), brand, style, and color brought in the greatest total amount of sales?
1 point
Department 2200 described as Celebrt, brand Lancome, style 1924, color resol eye
Department 6400 described as Blue, brand Designer, style 6 7002-9, color edp spray
Department 4407 described as Environ, brand Silver C, style TO02SCBELT-S , color silver
Department 800 described as Clinique, brand Clinique, style 6142, color DDML
=================================================
10.
Question 10
How many stores have more than 180,000 distinct skus associated with them in the skstinfo table?
1 point
20
31
4
12
=================================================
11.
Question 11
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.
1 point
style
size
vendor
pack size
=================================================
12.
Question 12
How many skus are in the skuinfo table, but NOT in the skstinfo table?
1 point
2388
90,334
803,966
0
=================================================
13.
Question 13
In what city and state is the store that had the greatest total sum of sales?
1 point
Little Rock, AK
Dallas, TX
Metairie, LA
McAllen, TX
=================================================
14.
Question 14
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?
1 point
Full Outer Join
Right Join
Left Join
Inner Join
=================================================
15.
Question 15
How many states have more than 10 Dillards stores in them?
1 point
24
15
9
5
=================================================
16.
Question 16
What is the suggested retail price of all the skus in the “reebok” department with the “skechers” brand and a “wht/saphire” color?
1 point
$39.00
$19.00
$29.00
$4.00
Week 5 Graded Quiz using Teradata
1.
Question 1
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.
1 point
Yes
No
=================================================
2.
Question 2
How many distinct skus have the brand “Polo fas”, and are either size “XXL” or “black” in color?
1 point
27,271
13,623
5,224
84
=================================================
3.
Question 3
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?
1 point
Atlanta, GA
Little Rock, AR
Richmond, VA
Tulsa, OK
=================================================
4.
Question 4
Which sku number had the greatest increase in total sales revenue from November to December?
1 point
3949538
2637537
6966816
4737469
=================================================
5.
Question 5
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).
1 point
5715232
3313116
5511283
9514659
=================================================
6.
Question 6
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.
1 point
Hart Sch
Vanity F
Clinique
Polo Fas
=================================================
7.
Question 7
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?
1 point
Metairie, LA
Tucson, AZ
Little Rock, AK
McAllen, TX
=================================================
8.
Question 8
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?
1 point
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 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 Cincinnati, OH. It had a lower average daily revenue than the store with the lowest median msa_income, which was in Littleton, CO.
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.
=================================================
9.
Question 9
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?
1 point
high
low
med-low
med-high
=================================================
10.
Question 10
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?
1 point
$24,341
$6,298
$25,452
$16,355
=================================================
11.
Question 11
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.
1 point
Gottex department, Pine Bluff, AR
Louisvl department, Salina, KS
Jacques department, Jackson, MS
Clinique department, Odessa, TX
=================================================
12.
Question 12
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?
1 point
Polomen department, Greenville, SC
Clinique department, Cincinnati, OH
Polomen department, Knoxville, TN
Clinique department, Louisville, KY
=================================================
13.
Question 13
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?
1 point
The R Lauren department in Toledo, OH sold 12,009 fewer items
The Clinique department in Louisville, KY sold 13,491 fewer items
The Clinique department in Greenville, SC sold 18,553 fewer items
The R Lauren department in Charlotte, NC sold 5,856 fewer items
=================================================
14.
Question 14
For 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?
1 point
August and September
August only
January and September
January and August
=================================================
15.
Question 15
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?
1 point
March
December
September
January