Data Unit Quiz

The owner of a clothing store records the following information for each transaction made at the store during a 7-day period.

- The date of the transaction

- The method of payment used in the transaction

- The number of items purchased in the transaction

The total amount of the transaction, in dollars

Customers can pay for purchases using cash, check, a debit card, or a credit card.

Using only the data collected during the 7-day period, which of the following statements is true?

• The average amount spent per day during the 7-day period can be determined by sorting the data by the total transaction amount, then adding the 7 greatest amounts, and then dividing the sum by 7.

• The method of payment that was used in the greatest number of transactions during the 7-day period can be determined by sorting the data by the method of payment, then adding the number of items purchased for each type of payment method, and then finding the maximum sum.

• The most expensive item purchased on a given date can be determined by searching the data for all items purchased on the given date and then sorting the matching items by item price.

• The total number of items purchased on a given date can be determined by searching the data for all transactions that occurred on the given date and then adding the number of items purchased for each matching transaction.

A wildlife preserve is developing an interactive exhibit for its guests. The exhibit is intended to allow guests to select the name of an animal on a touch screen and display various facts about the selected animal.

For example, if a guest selects the animal name “wolf,” the exhibit is intended to display the following information.

- Classification: mammal

- Skin type: fur

- Thermoregulation: warm-blooded

- Lifestyle: pack

- Average life span: 10–12 years

- Top speed: 75 kilometers/hour

The preserve has two databases of information available to use for the exhibit. The first database contains information for each animal’s name, classification, skin type, and thermoregulation. The second database contains information for each animal’s name, lifestyle, average life span, and top speed.

Which of the following explains how the two databases can be used to develop the interactive exhibit?

• Only the first database is needed. It can be searched by animal name to find all the information to be displayed.

• Only the second database is needed. It can be searched by animal name to find all the information to be displayed.

• Both databases are needed. Each database can be searched by animal name to find all information to be displayed.

• The two databases are not sufficient to display all the necessary information because the intended display information does not include the animal name.

A team of researchers wants to create a program to analyze the amount of pollution reported in roughly 3,000 counties across the United States. The program is intended to combine county data sets and then process the data. Which of the following is most likely to be a challenge in creating the program?

• A computer program cannot combine data from different files.

• Different counties may organize data in different ways.

• The number of counties is too large for the program to process.

• The total number of rows of data is too large for the program to process.

A student is creating a Web site that is intended to display information about a city based on a city name that a user enters in a text field. Which of the following are likely to be challenges associated with processing city names that users might provide as input?

Select two answers.

• Users might attempt to use the Web site to search for multiple cities.

• Users might enter abbreviations for the names of cities.

• Users might misspell the name of the city.

• Users might be slow at typing a city name in the text field.

A database of information about shows at a concert venue contains the following information.

- Name of artist performing at the show

- Date of show

- Total dollar amount of all tickets sold

Which of the following additional pieces of information would be most useful in determining the artist with the greatest attendance during a particular month?

• Average ticket price

• Length of the show in minutes

• Start time of the show

• Total dollar amount of food and drinks sold during the show

A camera mounted on the dashboard of a car captures an image of the view from the driver’s seat every second. Each image is stored as data. Along with each image, the camera also captures and stores the car’s speed, the date and time, and the car’s GPS location as metadata. Which of the following can best be determined using only the data and none of the metadata?

• The average number of hours per day that the car is in use

• The car’s average speed on a particular day

• The distance the car traveled on a particular day

• The number of bicycles the car passed on a particular day

The owner of a hotdog stand collected the following data for each sale during a one-month period.

- The date of the purchase

- The number of hotdogs purchased

- The type of toppings selected

Using only the data collected, which of the following statements are true?
Select two answers.

• The type of topping most popular in the morning can be found by filtering the data by date and sorting by topping.

• The largest order on a given day can be found by filtering the data by date, then sorting by number of hotdogs purchased.

• The average number of hotdogs per sale can be found by summing the number of hotdogs and dividing by the number of sales.

• The most expensive order can be found by filtering the data by toppings and sorting by date.

A company uses the following data tables.

"Employees" containing (employeeID, name, department)

"Projects" containing (employeeID, budget, dueDate)

Which of the following explains how the data files can be used to find the project due dates for the sales department?

• First filter the Employees table to create a list of employees in the sales department, then use these employeeIDs to search the Projects table.

• First sort the Projects table by dueDate, then use these dates to search the Employees table.

• First search the Employees table for the sales department, then use these names to filter the Projects table.

• Filter the Projects table for the sales department.

A data table contains the following information about books.

-Title

-Genre

-Customer Rating

Which of the following can be used to find the Sci Fi book with the highest customer rating?

• Sort the table by genre, then find the sum of the customer ratings.

• Filter the table by genre for "Sci Fi", then sort the table by customer rating.

• Search the Customer Ratings column for "Sci Fi" then sort the results.

• Filter the customer ratings for greater than 3 then sort the results by Title.

An online survey collected the following data from the people who participated.

·         The age of the person

·         The person’s favorite musical artist

·         The city in which the person lives

Which of the following could NOT be determined using only the data collected in the survey?

• The city where a particular musical artist is most popular

• The average age of the people who like a particular musical artist

• The most popular musical artist among people of a certain age-range

• The city in which a particular musical artist sold the most albums