Comp Sci Unit 3 #1

A programmer is writing a program that is intended to be able to process large amounts of data. Which of the following considerations is LEAST likely to affect the ability of the program to process larger data sets?

• How long the program takes to run

• How many programming statements the program contains

• How much memory the program requires as it runs

• How much storage space the program requires as it runs

Biologists often attach tracking collars to wild animals. For each animal, the following geolocation data is collected at frequent intervals.

• The time

• The date

• The location of the animal

Which of the following questions about a particular animal could NOT be answered using only the data collected from the tracking collars?

• Approximately how many miles did the animal travel in one week?

• Does the animal travel in groups with other tracked animals?

• 
  Do the movement patterns of the animal vary according to the weather?

• In what geographic locations does the animal typically travel?

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 bookstore has a database containing information about each book for sale in the store. A sample portion of the database is shown below.

A store employee wants to calculate the total amount of money the store will receive if they sell all of the available science fiction books. Which columns in the database can be ignored and still allow the employee to perform this calculation?

Select two answers.

• Author

• Title

• 
  Genre

• Quantity Available

A digital photo file contains data representing the level of red, green, and blue for each pixel in the photo. The file also contains metadata that describes the date and geographic location where the photo was taken. For which of the following goals would analyzing the metadata be more appropriate than analyzing the data?

• Determining the likelihood that the photo is a picture of the sky

• Determining the likelihood that the photo was taken at a particular public event

• Determining the number of people that appear in the photo

• Determining the usability of the photo for projection onto a particular color background

A cable television company stores information about movie purchases made by subscribers. Each day, the following information is summarized and stored in a publicly available database.

• The day and date each movie was purchased

• The title of each movie purchased

• The cities where subscribers purchased each movie

• The number of times each movie was purchased by subscribers in a given city

A sample portion of the database is shown below. The database is sorted by date and movie title.

Which of the following CANNOT be determined using only the information in the database?

• The date when a certain movie was purchased the greatest number of times

• The number of movies purchased by an individual subscriber for a particular month

• The total number of cities in which a certain movie was purchased

• 
  The total number of movies purchased in a certain city during a particular month

A researcher is analyzing data about students in a school district to determine whether there is a relationship between grade point average and number of absences. The researcher plans on compiling data from several sources to create a record for each student.

The researcher has access to a database with the following information about each student.

• Last name

• First name

• Grade level (9, 10, 11, or 12)

• Grade point average (on a 0.0 to 4.0 scale)

The researcher also has access to another database with the following information about each student.

• First name

• Last name

• Number of absences from school

• Number of late arrivals to school

Upon compiling the data, the researcher identifies a problem due to the fact that neither data source uses a unique ID number for each student. Which of the following best describes the problem caused by the lack of unique ID numbers?

• Students who have the same name may be confused with each other.

• Students who have the same grade point average may be confused with each other.

• Students who have the same grade level may be confused with each other.

• Students who have the same number of absences may be confused with each other.

A file storage application allows users to save their files on cloud servers. A group of researchers gathered user data for the first eight years of the application’s existence. Some of the data are summarized in the following graphs. The line graph on the left shows the number of registered users each year. The line graph on the right shows the total amount of data stored by all users each year. The circle graph shows the distribution of file sizes currently stored by all users.

 

(note: 1 MB = 1,000 KB)

Which of the following best describes the average amount of data stored per user for the first eight years of the application’s existence?

• Across all eight years, the average amount of data stored per user was about 10 GB.

• Across all eight years, the average amount of data stored per user was about 100 GB.

• The average amount of data stored per user appears to increase by about 10 GB each year.

• The average amount of data stored per user appears to increase by about 100 GB each year.

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 group of students take hundreds of digital photos for a science project about weather patterns. Each photo file contains data representing the level of red, green, and blue for each pixel in the photo. The file also contains metadata that describes the date, time, and geographic location where the photo was taken. For which of the following goals would analyzing the metadata be more appropriate than analyzing the data?

Select two answers.

• Determining the chronological order of the photos

• Determining the number of clouds in a particular photo

• Determining whether a photo is suitable for printing in black-and-white

• Determining whether two photos were taken at the same location on different days