Uncategorized

Managing Big Data with MySQL Quiz

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”

Enroll Now

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

 

 

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *