ISYS 284 Quizzes 1-4

Which of the following shows the parts of the website that you are permitted and not permitted to scrape?

robots.txt

Consider the data below that was collected about a few songs. Considering only the given data, which of the attributes meets the requirements for a primary key?

None of the attributes meet the requirements for a primary key

The database follows the below data model that has three related tables: Customer, Order, Product. Which of the following fields should be used in a query in order to show the total number of unique products offered?

product id in Product table

A local store is running different queries based on their transactions in 2020 to answer different business questions. Which of the below queries would return largest number of rows?

Customers who live in Pittsburgh or their first name contains John or purchased iPhone X

The maoyor of Pittsburgh separated the greater Pittsburgh area into 10 regions. He then randomly selected 50 individuals from each region to survey. This is _______________ sample.

stratified

Consider the sample iPhone sales data below. If making a visualization, what type of aggregation would be required to display the total number of phones sold and what field should it be applied to? The total number of iPhones sold could be displayed in card visualization, for example.

sum aggregation on the quantity field

Consider the sample data shown below. How would you determine the total of all transaction amounts?

sum the total_transaction_amount

Which of the following allows respondents to see questions that are appropriate for them based on their answers to prior questions?

survey logic

One of the biggest mistakes made in data sourcing is to:

collect data before setting objectves

You are cleaning a data set. The address column includes street name, city, state and zip code. It follows the format as "StreetName, City; State_Zip". For example, one address is recorded as "600 Forbes Avenue, Pittsburgh; PA_15282". You are trying to extract the street name information(600 Forbes Avenue) using a delimiter. Which delimiter should you use?

comma

Consider the ecommerce dashboard shown below. The choice of white text on the navy background is an example of which professional design principle?

contrast

Using orange and green text together in a design will make it look more professional because it creates:

contrast

A theater manager surveys the last 10 people to leave a movie about their opinions on the movie. What type of sampling strategy did the theater manager use?

convenience

Giant Beagle, a chain of local grocery stores, wants to survey customers to decide what type of new cookies to offer in the stores' bakery departments. A team of survey takers visited each store on Saturday and Wednesday and asked customers browsing the bakery department what type of cookie they would be interested in buying. What type of sampling strategy did Giant Beagle use?

convenience

Consider the data shown below. How would you determine number of unique products sold?

count distinct product_id

Consider the screen shot below of a portion of a dashboard made in Power BI. How could the slicer be adjusted to include the week starting with September 23, 2019?

in the slicer, slide the right white circle to the right

The database model shown below is partially completed. Assuming that the model should reflect that the organization receives many invoices from each supplier, to which table(s) should a foreign key be added when drawing this relationship?

invoice table

A school chooses 4 randomly selected athletes from each of its sports teams to participate in a survey about athletics at the school. What type of sampling strategy was used?

stratified

You are interning at a large e-commerce company as a data analyst. Your manager sends you a large file containing over 500,000 records. Each record represents a transaction, including the revenue (i.e., the dollar amount of the sale) generated from that transaction. If your task is to send back a report showing the monthly revenue for 2017, how many rows of data will be shown in your report?

12

Which of the visualizations is the correct visualization to support the following claim: "Store A made 160K profit from Clothing sales and 208K from Jewelry Sales"?

A

Which of the following statements is correct? - Every parent table must have a foreign key - A zip code attribute is a good selection for primary in a customer table - A child table must have a foreign key - A child table will either have a foreign key or a primary key - A foreign key field cannot be duplicated

A child table must have a foreign key

Consider the diagram below. Which of the following best describes the data model regarding clients making payments on loans?

A client can make payments towards multiple loans.

When creating a column chart that displays the total quantity sold of each cookie type (e.g., chocolate chip, sugar), what type of visualization could be added to the report to allow the user of the column chart to view the total quantity sold of each cookie type for a specific region of the United States?

A slicer configured to slice on the region field

Each of the following are an example of secondary data collection with the exception of _______________.

A university sending a survey to students about dining options.

Jackson would like to create a new attribute in a table that is equal to dividing two other attributes in that table and multiplying the resulting value by 100. Which of the following strategies will allow Jackson to create this new attribute?

Add a custom column

Jerry would like to create a new attribute in a table that is equal to multiplying two other attributes in that table. Which of the following strategies will allow Jerry to create this new attribute?

Add a custom column

If the purpose of this visualization is to compare number of monthly orders in 2017 and 2018, which of the following changes should be made to the visualization in order to improve its effectiveness?

Add axis titles and a graph title

Suppose there exists a 1:M (one-to-many) relationship between the following tables: Each player can play for only one team, and a team can have many players. In order to show this relationship, which action should be taken?

Add teamID field onto the Player table as a foreign key

Which of the following visualizations can be made interactive using a slicer?

All of the other answers are correct

Tom sent his last month's sales report to his supervisor. The report shows sales for each customer, for each product category and for each state. His supervisor returned the report back to Tom and asked for a consistency check. Which of the following needs to be considered while checking for consistency? - Does the sum of each state's sales equal the total amount of sales? - Does the sum of each product category sales equal the overall total amount of sales? - Was each sale conducted using the same currency? - Is all summary information in agreement with detailed information? - All of the other answers should be considered when evaluating consistency

All of the other answers should be considered when evaluating consistency.

Which of the following statements about primary keys is correct? - Values in a primary key column should not be modified or updated - All of the other statements about primary keys is correct - A primary key field cannot contain nulls - Every record must have a primary key value - No two records can have the same primary key value

All of the other statements about primary keys is correct

Each of the following represent sound advise when it comes to determining the appropriate visualization type, except _____.

All of the the other answers represent sound advise when it comes to determining the appropriate visualization type

Which of the following is a common problem with secondary data? - Different unit of measurement - Different objectives - Possible low data quality - All other choices are correct - Outdated information

All other choices are correct.

Members of the University Theater Club plan to sell popcorn as a fundraiser for their Shakespeare production. They conduct an email survey of 75 randomly selected students currently attending the university about their favorite flavors of popcorn. The results show that 33 students like butter, 15 like cheese, and 27 like caramel. What is the population of their survey?

All students

What is the primary difference between an entity and an attribute?

An entity is a table that stores information about objects, whereas an attribute is a column or specific field of the data elements associated with an entity.

Karen downloaded App review data from the Apple App Store. Using her data skills, Karen created a data model that accurately represents the review data. Referring to data model below, which table(s) would be required in a query to answer a question about the average number of installations by App?

App

Consider Table 1 and Table 2 below. What steps would need to be performed in order to combine Table1 and Table 2 to create a query showing average graduation rate of all schools?

Append Table1 and Table2

Which of the following is a "tool" composed of multiple visualizations (usually interactive) that allow the user to draw their own conclusions (and thus support decision making) by examining the data?

Business intelligence dashboard

A variable measuring a person's highest level of education as one of: - High School - 2 Year Associates Degree - 4 year College Degree - Masters Degree - PhD is an example of what type of variable?

Categorical Ordinal

Which of the following is an advantage of closed-ended questions?

Closed ended questions are easier to tabulate and analyze.

Subway offers different bread types (e.g., white, wheat) to its customers. The management team would like to know if certain bread types are more popular during different parts of the day - specifically lunch time, dinner time, and late night. If provided with a data set that shows each sandwich purchased, the type of bread on which it was made, and the part of the day in which it was purchased, which visualization type would be best for presenting the number of sandwiches purchased by each bread type during each part of the day?

Clustered bar chart

Which of the following visualizations should be used to support the following claim: "At Duquesne, males rated Hogan Dining Center more highly than females rated Hogan Dining Center, while females rated the Incline the highest among all dining options"?

Clustered bar chart

Which of the following visualizations should be used to support the following claim: "At Duquesne, morning classes are more popular than afternoon and evening classes among both males and females"?

Clustered bar chart

Which of the following is NOT a method of collecting data from users of technology?

Collect data from websites with strict privacy rules

Consider the sample data below regarding purchases made via an e-commerce website. Which of the following transformations should be performed to determine the number of unique customers that have placed an order at least one time?

Count distinct values on customerID column

Which of the following attributes would contain discrete numerical data?

Count of the number of persons living in a household

The following is a snapshot of a database that captures the movie tickets sold in 2018. Primary keys are underlined, foreign keys are italicized. The first table is the movie table. The second table is the order table. Each table has more records than shown in the figure. You would like to have a list of English language movies in the Crime genre. The list should also show the highest budget movie in the first row. How would you achieve that?

Create a filter that indicates Genre must equal Crime and Language must equal English, and then sort by Budget descending

Consider the sample data below regarding purchases made via an e-commerce website. Primary keys are underlined, foreign keys are italicized. Which of the following is the transformation that would produce the single value representing the total quantity ordered of all productID 10 and productID 24?

Create a filter that indicates productID should be equal to 10 OR productID should be equal 24 and then sum the qty purchased column

Refer to the product, order, and order_line tables below. Which of the following best describes what is wrong with the row highlighted in yellow?

Creating this row in order_line violates a referential integrity constraint because order 024 does not exist.

Some of the serious business consequences that occur due to using low-quality information to make decisions are all of the following EXCEPT:

Creation of tables and spreading data across them based on what type of entity the information describes

______ involves the visual representation of data, ranging from single charts to comprehensive dashboards.

Data visualization

Which of the following is an example of a closed-ended question?

Do you characterize the library resources as inadequate, adequate, or excellent?

Which of the following survey questions is incorrectly constructed?

Do you enjoy spending time with your friends and family?

Bill's Goatee Grooming Paraphernalia (BGGP) spent Q3 and Q4 of the last calendar year implementing various strategies designed to boost its on-line sales. The figure below reflects BGGP's total sales for last year. Which of the following statements accurately reflects the results of BGGP's efforts to boost on-line sales?

Efforts to boost on-line sales were unsuccessful

Consider the sample data and query below regarding hotel room reservations. Primary keys are underlined, foreign keys are italicized. Which of the following is a claim that could be supported by the QUERY RESULT showing breakfast_id and how many times that breakfast was served?

English breakfast is the most popular breakfast

Consider the sample data shown below. If you want to create a query that shows only the Cookie products, which of the following transformations you would need to do?

Filter products.product_name to include products whose name contain Cookie

Consider the sample data below. How should one transform the data to determine the average procedure fees charged for procedures of Joe Kelly?

Filter the procedure table to only include patientID 2 and then average the procedure fee column

Consider the sample data below. Primary keys are underlined, foreign keys are italicized. How should one transform the data to determine the total of fees charged for procedure type 43192?

Filter the procedure table to only include procedure type 43192 and then sum the procedure fee column

Consider Table 1 below. How should one transform the data to create a query showing the number of customers at each company?

Group by company name and count rows within each group

Consider the sample data shown below. How would you determine the total transaction amount for each payment type used by customers?

Group by payment_type and sum the total_transaction_amount within each group

When importing a commodity, the Shipper is the company who is the supplier of the commodity and Shipment is the cargo of commodities. Given the relationship shown below between Shipment and Shipper, how could you determine the number of shipments carried out by each ShipperID?

Group by the SHIPPER ID in the SHIPMENT table and count rows in the SHIPMENT table

Consider the sample data and query below regarding purchases made via an e-commerce website. What type of transformation was used to produce result in the query produced?

Group by with sum aggregation

The following is a snapshot of a database that captures the movie tickets sold in 2018. Primary keys are underlined, foreign keys are italicized. The first table is the movie table. The second table is the order table. Each table has more records than shown in the figure. You would like to know the average budget for each genre. How would you achieve this?

Group the records in movie table by genre and average budget within each group

The database at a local university includes separate tables that store information about each student's address, courses taken, grades, payments, food points ... etc. The table below is the FitnessCenterEntry table in that database. A new record (i.e. row) is added to this table each time a student enters the fitness center and swipes their Student ID card. Which of the following answers identifies a disadvantage exhibited by the design of the FitnessCenterEntry table?

Information Redudancy

Tom sent his last month's sales report to his supervisor. The report shows sales for each customer, for each product category and for each state. His supervisor returned the report back to Tom and asked for a consistency check. Which of the following does NOT need to be considered while checking for consistency? - Does the sum of each state's sales equal the total amount of sales? - Is all summary information in agreement with detailed information? - Is the area code missing from the customer phone number information? - Does the sum of each product category sales equal the overall total amount of sales? - Was each sale conducted using the same currency?

Is the area code missing from the customer phone number information?

What error was made in constructing the following survey question? Indicate your agreement with the following statement: Pizza and spaghetti are delicious foods. A. Strongly agree B. Somewhat agree C. Neither agree or disagree D. Somewhat disagree E. Strongly disagree

It is a double-barreled question

Consider the visualization below that shows total units sold by month and manufacturer (e.g., Aliqui, Natura). During what month of 2014 did total units sold of Natura products exceed total units sold of VanArsdel products?

June

The following image is a snapshot of two queries (MOVIES and ORDER) that capture 2018 movie ticket sales. In each query, primary keys are underlined and foreign keys are italicized. Each table contains more records than is shown in the image. Which of the following answers describes steps that can be used to determine the total USA tickets sales revenue by movie? The results must, at a minimum, display the total tickets sales revenue for each movie by title. NOTE: (1) the order of the fields in the result is not important. (2) you may assume Movie titles are unique.

Merge the MOVIE query into the ORDER query based on the Movie Id field found in both queries. Expand the merged MOVIE fields and retain the Movie title and Country fields. Filter the query's Country column for USA only. Group the records in the query by Movie title and sum the Revenue.

Consider the visit table and doctor table below. What steps would need to be performed in order to combine the visit table and the doctor table to create a query showing the average visit length for each doctor and display the doctors by name?

Merge the visit table and the doctor table, then group by the doctor id, doctor first name, and doctor last name and average the visit length (minutes).

Consider the screen shot below of a portion of a dashboard made in Power BI. Which of the following can be concluded based on the dashboard?

More cars were sold the week of starting September 2 than the week of September 16.

Which of the following is one of the advantages of using primary data over secondary data?

More control over the specific data to be collected

Shown below is a visualization created by Borizen Wireless using two customer related variables. The techsavy variable (shown on the Y axis) reflects customer use of Borizen's advanced technology features and the income variable (shown on the X axis) reflects customer annual income in dollars. If a "dot" in the figure below represents one customer, which of the following statements is true?

More lower income customers have techsavy scores above 30 than higher income customers

Consider the query result below. This query shows revenue generated by sales of t-shirts by year and color. Which of the following business statements is supported by the query result?

More purple and red t-shirts were sold in 2017 than in 2016

Consider the visualization below. Which of the following claims can be supported by this visualization?

Pennsylvania has the highest number of calls to customer service among households with 1 to 3 individuals.

Consider the visualization below. The X axis represents order amount ($) and Y axis represents shipping cost ($) across several transactions in a warehouse system. Which kind of relationship does the visualization reveal?

Positive; as order amount increases shipping cost increases

To show the relationship between students' class attendance and their academic performance on a scatter plot, which of the following variables would you need to use?

Put the number of attended classes on the X axis and student GPA score on the Y axis.

(Refer to image) The questionnaire on the left was used to collect some basic customer information during an online purchase checkout. The business owner, Michelle, asked an employee to provide information about purchases by gender (Male vs. Female). The query returned the result shown on the right, which is not properly displaying orders by gender as Michelle requested. How could this best be prevented during the questionnaire design?

Restrict the responses in the gender question to set values using a dropdown list where only one option can be selected.

Java-O, a coffee franchise, would like to know what their customers like the most about their coffee offerings (e.g. taste, smell, price, etc.). Which data source should Java-O choose based on their objective?

Send an online survey to existing customers

Jane was scheduled to meet colleagues on Tuesday afternoon to discuss gathering data for a data analytics project. She spent Tuesday morning collecting data for the project using a Qualtrics survey. What mistake did Jane make in regard to sourcing the data?

She bagan collecting the data before the project objectives were determined.

Lance is conducting a survey to learn more about his customers and what the best location would be for opening a new location in his chain of cupcake bakeries. When customers visit one of his locations, he is giving them a free cupcake if they answer his survey using their mobile phone or the in-store iPad. Conducting this survey is an example of:

Sourcing from a primary data source

If a survey asks respondents to indicate their monthly budget for transportation costs and provides the answer options below, which of the following best describes the problem(s) with the current answer options? $0 to 50 $50 to 100 $100 to 150 More than $150

The answer options are not mutually exclusive

Which of the following indicates that the customers table shown below is not well-structured?

The data in the table represents more than one entity.

Consider the database model below. Assuming the model should show that staff members and clients can have many appointments at a salon, and salons can house many appointments, which of the following describes the error in the database model?

The direction of the relationship between Salon and Appointment tables is incorrect.

When creating a web scraper to source data from a website, what should you consider?

The limitations specified in the website's robot.txt file

Why is it important to utilize clean data when performing analyses to answer business questions?

To ensure the integrity of the data

If we store information about the occurrence of a business event, such as receiving an order for item X from customer Y, that information is known as _________.

Transactional information

Jessie works for United Health. Using her data skills, Jessie created a data model that accurately represents the relationships between Patients, Visits, Doctors and doctor Specialty. Referring to data model below, which table(s) would be required in a query whose purpose is to display the count of visits by specialty. The query results must display the specialty name along with the count of visits.

VISIT, DOCTOR, and SPECIALTY

Which of the following statements is correct regarding count vs count distinct? - The result of count distinct is always higher than the result of count values of the same column - When counting values of any column, count and count distinct will always give the same answer - When counting values of the foreign key column, count and count distinct will always give the same answer - The result of count distinct is always higher than the result of count values of the same column if there are duplicates in the column - When counting values of the primary key column, count and count distinct will always give the same answer

When counting values of the primary key column, count and count distinct will always give the same answer

Jan has collected some customer experience data on her company's new product. She is interested in using a visualization to display the relative importance of terms used to describe the new product. Jan should consider using a(n) ______ to achieve her objective.

Word cloud

Which of the following best describes why the cell_phone attribute of a customer table should not be the primary key?

a cell phone number is likely to change

Consider the sample iPhone sales data below. If making a visualization, what type of aggregation would be required to display the total number of states phones shipped to and what field should it be applied to? The total number of states could be displayed in card visualization, for example.

a count aggregation on the state shipped to field

Consider the diagram below. Which of the following statements is correct about the relationships shown in the model?

a customer can rent multiple dvds

Which of the following must be included in the introduction statement for a survey?

a statement that motivates the respondent to participate in the survey

If one creates a relationship and chooses to enforce referential integrity, then ____________ .

a value must exist in the primary key column of the parent table before it can be entered into the foreign key column of the child table.

Many tools make it very easy to quickly build visualizations. The role of an analyst is to ensure that the information presented is _____.

accessible, easy to understand and clear

An andvantage of multiple-choice questions as compared to open-ended questions is that they:

are easier to analyze

Consider the sample data shown below. How would you determine the average transaction amount?

average the total_transaction_amount

Amaprawn is a online retailer that keeps close watch on their customers' browsing behavior. Amaprawn stores customer contact information in the CUSTOMER_CONTACT entity shown below. Customers' browsing history is stored in the BROWSING_HISTORY entity. Customers may browse Amaprawn's site many times. Which field (attribute) serves as the Foreign Key in the BROWSING_HISTORY entity?

customer_id

What is a logical data structure that details the relationship among data fields using graphics or pictures?

data model

In a survey whose primary focus is to determine the best brand of soft drinks to sell at sporting events, what is the best placement for the following demographics-related survey question: "what is your zip code?"

end of survey

It is important to utilize clean data when performing analyses to answer business questions in order to _______________.

ensure the integrity of the analysis results

In the Parent-Child metaphor used to describe database table relationships, the table containing the __________ is the child table.

foreign key

What is a query?

identification and transformation of data to answer a question

Which of the following is not a data cleaning activity?

identifying trends in data

Which of the following is a "tool" composed of a static set of images designed to lead the reader to a conclusion pre-ordained by the author?

infographic

Consider the product data below that was collected for a few of the menu items available in a restaurant. If designing a product table that will contain all of the menu items, which of the following attributes could be used as the primary key?

ingredient

What error was made in constructing the following survey question? Do you agree that campus parking is a problem and that metered parking would be a solution? A. strongly agree B. somewhat agree C. neither agree nor disagree D. somewhat disagree E. strongly disagree

it is a double-barreled question

If trying to support the following claim, what would be the best visualization choice? During November 2017, gas prices peaked on Tuesday of week 3 after which the prices exhibited a slow daily decline.

line chart

A field that uniquely identifies a record in a table is known as a ________.

primary key

In a one to many relationship, the "many" side of the relationship is connected to the table where a value from the ___________ could appear many times in the _____________ .

primary key ; foreign key

If every individual in a population has the same chance of being included in a sample, the sample is a(n) ______________ sample.

random

Consider the product data below that was collected for a few of the products available in an apparel store. If a data set showing 3000 of the store's products was collected in the same fashion, how could one use this data to create a unique list of the colors offered in the store?

remove duplicates in the color column

Consider the product data below that was collected for a few of the products available in an apparel store. If a data set showing 3000 of the store's products was collected in the same fashion, how could one use this data to create a unique list of the sizes offered in the store?

remove duplicates in the size column

To ask whether the respondent has ever lived in the United States of America, what type of question should be used on the survey? Specifically, the question would read: Have you ever lived in the United States of America?

single answer multiple choice

The following is a snapshot of a query that captures products and their prices. You would like to rank the products from highest to lowest price within each category where the categories should be sorted in Z-A (reverse alphabetical) order. How would you achieve that?

sort by product_category in descending order followed by sorting by price in descending order

The image below shows customer names and the dates and times that they placed an order. Which of the answers below can be used to display the customer that placed the most recent order in the last(bottom) row of the result?

sort first by order_date ascending then sort by order_time ascending

Sebastian works for a local hardware store and is seeking information about upcoming weather patterns so that he can decide whether to purchase additional shovels, snow blowers, and salt from his supplier. He is able to obtain weather data from Weather.com for the next 60 days and view it in Power BI. What type of sourcing does this represent?

sourcing via web scraping

Paul is creating a visualization that displays the amount of the meningitis bacteria that can survive as temperature rises. He has set up an experiment that measures the amount of bacteria at each 1 degree rise in temperature from 0 to 200 degrees. Since (a) temperature is a continuous interval variable (like time) and (b) Paul believes that temperature levels influence bacteria levels (and not the other way around), Paul should use a line chart where _____ is on the x-axis and _____ is on the y-axis.

temperature / amount of bacteria

If the football coach surveys the starting lineup (i.e., the players that are on the field at the start of the game) regarding which uniform the football team should wear, what is the population?

the football team

The Royal Coffee Lab & Tasting Room asked their customers which coffee flavor they liked the most. Based on the answers provided, Royal Coffee created the following word cloud infographic. On the list below, which flavor was mentioned most frequently?

vanilla