bjc test

For a given row in the spreadsheet, suppose genre contains the genre as a string, num contains the number of copies in stock as a number, and cost contains the cost as a number. Which of the following expressions will evaluate to true if the book should be counted and evaluate to false otherwise?

(genre = "mystery") AND ((1 ≤ num) AND (cost < 10.00))

For a given row in the spreadsheet, suppose genre contains the genre as a string and day contains the day as a string. Which of the following expressions will evaluate to true if the show should be counted and evaluates to false otherwise?

(genre = "talk") AND ((day = "Saturday") OR (day = "Sunday"))

Using computers, researchers often search large data sets to find interesting patterns in the data. Which of the following is not an example where searching for patterns is needed to gather desired information?

A high school analyzing student attendance records to determine which students should receive a disciplinary warning.

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

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

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

Which of the following is not an example of metadata?

Data about a pack of wolves describing their habitat, hunting habits, diet, and sleep cycles.

What is the difference between data and information?

Data provides opportunities for identifying trends, making connections, and addressing problems. Information is the result of analyzing that data.

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?

Different counties may organize data in different ways.

Which of the following sequences of steps can be used to identify the desired entry?

Filter by photographer, then filter by year, then sort by year, Sort by subject, then sort by year, then filter by photographer

a car hailing company uses an app to track the travel trends of its customers. The data collected can be filtered and sorted by geographic location, time and date, miles traveled, and fare charged for the trip. Which of the following is least likely to be answerable using only the trends feature?

How is competition with the local cab companies affecting business in a given district?

Which of the following questions about the students who responded to the survey can the teacher answer by analyzing the survey results?

I and II

Describe two things that someone might do in order to clean data.

Replacing abbreviations, spellings, and capitalizations with the intended word or converting miles to kilometers.

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.

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 number of bicycles the car passed on a particular day

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

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.

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

The total number of songs purchased by a particular customer during the course of a given year.

For which of the following goals would it be more useful to analyze the data instead of the metadata?

To determine the language most commonly used in user conversations.

A new rechargeable battery pack is available for products that use AA batteries. Which of the following best explains how the data files in the table can be used to send a targeted e-mail to only those customers who have purchased products that use AA batteries to let them know about the new accessory?

Use the products file to generate a list of product IDs that use AA batteries, then use the list of product IDs to search the purchases file to generate a list of customer IDs, then use the list of customer IDs to search the customers file to generate a list of e-mail addresses

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?

Users might enter abbreviations for the names of cities, Users might misspell the name of the city.

Which of the following questions about a particular bird could not be answered using only the data gathered from the tracking tags.

What are the effects of industrial pollution on the migration path of the bird?