big idea 2 question
Being able to add or remove resource to store large datasets is called a. Scalability b. Filtering c. Efficiency d. Routing
Answer: A
What is information about the author of a document considered to be? a. Metadata b. Content c. Context d. Mididata
Answer: A
An example of metadata about sea turtle nests could be a. Number of eggs in the nest b. Location of the nest c. Number of incubation days d. Tracking number assigned to the nest
Answer: D
Which topic needs the use of programs to analyze the data to identify insights? a. The average number of students who drive to school each day b. The record of wins and losses for all sports teams under their current coaches compared to prior years' win/loss records c. The number of library books in a school district that need of library books in a school d. The standardized test scores for current students compared to test scores across the country for the past decade
Answer: D
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? a. Average ticket price b. Length of the show in minutes c. Start time of the show d. Total dollar amount of food and drinks sold during the show
Answer: A
A large spreadsheet contains the following information about the books at a bookstore. A sample portion of the spreadsheet is shown below. A Book Title B Author C Genre D Number of Copies in Stock E Cost (in dollars) 1 Little Women Louisa May Alcott Fiction 3 13.95 2 The Secret Adversary Agatha Christie Mystery 2 12.95 3 A Study in Scarlet Arthur Conan Doyle Mystery 0 8.99 4 The Hound of the Baskervilles Arthur Conan Doyle Mystery 1 8.95 5 Les Misérables Victor Hugo Fiction 1 12.99 6 Frankenstein Mary Shelley Horror 2 11.95 An employee wants to count the number of books that meet all of the following criteria. Is a mystery book Costs less than $10.00 Has at least one copy in stock 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? a. (genre = "mystery") AND ((1 ≤ num) AND (cost < 10.00)) b. (genre = "mystery") AND ((1 < num) AND (cost < 10.00)) c. (genre = "mystery") OR ((1 ≤ num) OR (cost < 10.00)) d. (genre = "mystery") OR ((1 < num) OR (cost < 10.00))
Answer: A
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? a. Students who have the same name may be confused with each other. b. Students who have the same grade point average may be confused with each other. c. Students who have the same grade level may be confused with each other. d. Students who have the same number of absences may be confused with each other.
Answer: A
A user wants to save a data file on an online storage site. The user wants to reduce the size of the file if possible and wants to be able to completely restore the file to its original version. Which of the following actions best supports the user's needs? a. Compressing the file using a lossless compression algorithm before uploading it b. Compressing the file using a lossy compression algorithm before uploading it c. Compressing the file using both lossy and lossless compression algorithms before uploading it d. Uploading the original file without using any compression algorithm
Answer: A
Consider the following numeric values. Binary 1011 Binary 1101 Decimal 5 Decimal 12 Which of the following lists the values in order from least to greatest? a. Decimal 5 binary 1011 decimal 12 binary 1101 b. Decimal 5 decimal 12 binary 1011 binary 1101 c. Decimal 5 binary 1011 binary 1101 decimal 12 d. Binary 1011 binary 1101 decimal 5 decimal 12
Answer: A
What is one way in which number systems are abstract? a. The same amount can be represented by different number representations b. A number can only be represented by one number system c. Symbols can not be used to add subtract multiply or divide them in their abstract form d. They use constants
Answer: A
A company purchases a large block of data from a social media site. If they want to analyze the data to learn more about potential customers what techniques should they use? a. Simulations to test different hypotheses about what data could be present b. Data analysis to identify patterns and relationships in the data for further analysis c. Maximization to get the highest return on their purchase of the data d. Data processing to use the data with existing company software to see if it will run on their systems or if new ones will need to be developed
Answer: B
A large spreadsheet contains information about the photographs in a museum's collection. A sample portion of the spreadsheet is shown below. A Photographer B Subject C Year D Publicly Available 1 Steven Greene Geyser Eruption 2004 true 2 Linda James Giant Sloth Fossil -1 true 3 Yajaira Lopez Diplodocus Skull 1997 false 4 Masahiro Higashi Sea Turtle 1989 true 5 (unknown) Solar Eclipse 2011 false 6 (unknown) Giant Sequoia -1 true In column A each unknown photographer is set to "(unknown)". In column C each unknown year is set to -1. A student is developing an algorithm to determine the name of the photographer who took the oldest photograph in the collection. Photographs whose photographer or year are unknown are to be ignored. Once the algorithm is complete the desired entry will appear in the first row of the spreadsheet. If there are multiple entries that meet the desired criteria then any of them can appear in the first row. The student has the following actions available. Action Explanation Filter by photographer Removes entries whose photographer is "(unknown)" Filter by year Removes entries whose year is -1 Sort by subject Sorts the rows in the spreadsheet on column B alphabetically from A to Z Sort by year Sorts the rows in the spreadsheet on column C from least to greatest Assume that applying either of the filters will not change the relative order of the rows remaining in the spreadsheet. Which of the following sequences of steps can be used to identify the desired entry? Select two answers. a. Filter by photographer then filter by year then sort by subject b. Filter by photographer then filter by year then sort by year c. Sort by subject then sort by year then filter by photographer d. Sort by year then filter by year then filter by photographer
Answer: B
A large spreadsheet contains information about the schedule for a college radio station. A sample portion of the spreadsheet is shown below. A Show Name B Genre C Day D Start Time E End Time 1 Dot Dot Dash rock Sunday 11:00 A.M. 1:00 P.M. 2 New Afternoon Show talk Sunday 1:00 P.M. 3:00 P.M. 3 Thursday Beats hip-hop Thursday 7:00 P.M. 9:00 P.M. 4 Gossip Time talk Friday 4:00 P.M. 6:00 P.M. 5 Campus Chat talk Saturday 6:00 P.M. 8:00 P.M. 6 Jazz Brunch jazz Saturday 12:00 P.M. 3:00 P.M. A student wants to count the number of shows that meet both of the following criteria. Is a talk show Is on Saturday or Sunday 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? a. (genre = "talk") AND ((day = "Saturday") AND (day = "Sunday")) b. (genre = "talk") AND ((day = "Saturday") OR (day = "Sunday")) c. (genre = "talk") OR ((day = "Saturday") AND (day = "Sunday")) d. (genre = "talk") OR ((day = "Saturday") OR (day = "Sunday"))
Answer: B
A magnet school wants to advertise its students' success taking AP exams to prospective families. What's the best method to share the summarized data? a. Post an image of student results on social media sites b. Create an interactive pie chart that can drill down to topics and overall scores posted on the school's website c. Write a report for a marketing pamphlet d. Send an email to families with middle school age children
Answer: B
A school district wants to analyze the data about their high school graduates who attend local community colleges. What information can the school district obtain from the following data that the school has available? Student name Number of students in the graduating class by high school High school graduation year Student self-reported plans for after high school Total numbers from local community colleges of enrolled students and their high school Total number of local community colleges students enrolled in each degree program a. Average number of in state students who enrolled in a local community college b. If the number of local graduate who enroll in a local community college is increasing decreasing or stable c. Number of local high school students who graduate from a local community college d. Popular degree programs in the community colleges
Answer: B
A team of researchers wants to create a program to analyze the amount of pollution reported in roughly 3000 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. A computer program cannot combine data from different files. b. Different counties may organize data in different ways. c. The number of counties is too large for the program to process. d. The total number of rows of data is too large for the program to process.
Answer: B
Metadata is used to a. Provide updates to the data b. Help find and organize data c. Brand the data d. Sort the data
Answer: B
What is 214 base 10 in binary? a. 11010100 b. 11010110 c. 11010111 d. 01101011
Answer: B
What is the amount of data compression an algorithm can produce reliant upon? a. No repeating parts of the file being compressed b. Several patterns in the data c. A larger file size d. A small file size
Answer: B
What order should these be in to go from smallest to largest? Binary - 01110111 Decimal - 111 Binary - 01111011 a. 1 2 3 b. 2 1 3 c. 3 1 2 d. 3 2 1
Answer: B
Which number type is stored imprecisely in memory? a. Integers b. Numbers with decimals c. Both d. Neither
Answer: B
Which of the following is an advantage of a lossless compression algorithm over a lossy compression algorithm? a. A lossless compression algorithm can guarantee that compressed information is kept secure while a lossy compression algorithm cannot. b. A lossless compression algorithm can guarantee reconstruction of original data while a lossy compression algorithm cannot. c. A lossless compression algorithm typically allows for faster transmission speeds than does a lossy compression algorithm. d. A lossless compression algorithm typically provides a greater reduction in the number of bits stored or transmitted than does a lossy compression algorithm.
Answer: B
Your program is comparing temperatures to determine how many patients have a fever. Your selection statement's condition is not working correctly when the variable patient_tenp is 98.6. What could be one reason why? IF (patient_temp = 98.6) a. The format is incorrect for this test b. A round-off error occurred c. An overflow error occurred d. The test condition is invalid
Answer: B
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. a. Users might attempt to use the Web site to search for multiple cities. b. Users might enter abbreviations for the names of cities. c. Users might misspell the name of the city. d. Users might be slow at typing a city name in the text field.
Answer: B & C
A certain programming language uses 4-bit binary sequences to represent nonnegative integers. For example the binary sequence 0101 represents the corresponding decimal value 5. Using this programming language a programmer attempts to add the decimal values 14 and 15 and assign the sum to the variable total. Which of the following best describes the result of this operation? a. The correct sum of 29 will be assigned to the variable total. b. An overflow error will occur because 4 bits is not large enough to represent either of the values 14 or 15. c. An overflow error will occur because 4 bits is not large enough to represent 29 the sum of 14 and 15. d. A round-off error will occur because the decimal values 14 and 15 are represented as approximations due to the fixed number of bits used to represent numbers.
Answer: C
A programmer is developing software for a social media platform. The programmer is planning to use compression when users send attachments to other users. Which of the following is a true statement about the use of compression? a. Lossless compression of video files will generally save more space than lossy compression of video files. b. Lossless compression of an image file will generally result in a file that is equal in size to the original file. c. Lossy compression of an image file generally provides a greater reduction in transmission time than lossless compression does. d. Sound clips compressed with lossy compression for storage on the platform can be restored to their original quality when they are played.
Answer: C
A teacher sends students an anonymous survey in order to learn more about the students' work habits. The survey contains the following questions. On average how long does homework take you each night (in minutes) ? On average how long do you study for each test (in minutes) ? Do you enjoy the subject material of this class (yes or no) ? Which of the following questions about the students who responded to the survey can the teacher answer by analyzing the survey results? I. Do students who enjoy the subject material tend to spend more time on homework each night than the other students do? II. Do students who spend more time on homework each night tend to spend less time studying for tests than the other students do? III. Do students who spend more time studying for tests tend to earn higher grades in the class than the other students do? a. I only b. III only c. I and II d. I and III
Answer: C
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? a. Only the first database is needed. It can be searched by animal name to find all the information to be displayed. b. Only the second database is needed. It can be searched by animal name to find all the information to be displayed. c. Both databases are needed. Each database can be searched by animal name to find all information to be displayed. d. The two databases are not sufficient to display all the necessary information because the intended display information does not include the animal name.
Answer: C
Consider the 4-bit binary numbers 0011 0110 and 1111. Which of the following decimal values is NOT equal to one of these binary numbers? a. 3 b. 6 c. 9 d. 15
Answer: C
Data compression algorithms are used when the data a. Needs to be shared with a large number of people b. Is used for cryptography to keep data secure c. Is too large to send in a timely manner d. Needs to be sent a large physical distance away
Answer: C
How can an organization begin the process of analyzing data? a. By following an iterative development process b. By establishing measurements the data should show c. By developing hypotheses and questions to test d. By checking to see if the data matches previously collected data
Answer: C
How many more bits are available if you go from a 32-bit computer to a 64-bit machine? a. Twice as many b. 32 more c. 232 more d. 322 more
Answer: C
If analyzing data indicates a company should only hire people with a college degree because they stay at the company longer what is this a potential indication of? a. Good data management practices leading to good hiring practices b. Frequency analysis to identify commonalities in the data c. Bias in collecting the data d. Data assessment and inquiry of hiring practices
Answer: C
The letter "M" is represented by 01001101 in binary. What is this in decimal? a. 414 b. 76 c. 77 d. 1101
Answer: C
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? a. The average number of hours per day that the car is in use b. The car's average speed on a particular day c. The distance the car traveled on a particular day d. The number of bicycles the car passed on a particular day
Answer: D
A company uses the following data files. File Name Description Contents Customers A list of customers Customer ID Customer address Customer e-mail address Customer phone number Products A list of products available for purchase from the company Product ID Product name Type of battery used by the product if any Purchases A list of customer purchases Product ID Product serial number Customer ID 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? a. Use the customer IDs in the purchases file to search the customers file to generate a list of e-mail addresses b. Use the product IDs in the purchases file to search the products file to generate a list of product names that use AA batteries c. Use the customers file to generate a list of customer IDs then use the list of customer IDs to search the products file to generate a list of product names that use AA batteries d. 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
Answer: D
A video game character can face toward one of four directions: north south east and west. Each direction is stored in memory as a sequence of four bits. A new version of the game is created in which the character can face toward one of eight directions adding northwest northeast southwest and southeast to the original four possibilities. Which of the following statements is true about how the eight directions must be stored in memory? a. Four bits are not enough to store the eight directions. Five bits are needed for the new version of the game. b. Four bits are not enough to store the eight directions. Eight bits are needed for the new version of the game. c. Four bits are not enough to store the eight directions. Sixteen bits are needed for the new version of the game. d. Four bits are enough to store the eight directions.
Answer: D
Given a table of lunchroom leftovers what can be determined from the data? Date Total Meals Total Meals Left Over 1/29/18 800 25 1/30/18 750 5 1/31/18 800 42 a. Most popular items b. Days of field trips when classes missed lunch c. Days with high absenteeism d. Amount of wasted budget dollars
Answer: D
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? a. 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. b. 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. c. 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. d. 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.
Answer: D
The position of a runner in a race is a type of analog data. The runner's position is tracked using sensors. Which of the following best describes how the position of the runner is represented digitally? a. The position of the runner is determined by calculating the time difference between the start and the end of the race and making an estimation based on the runner's average speed. b. The position of the runner is measured and rounded to either 0 or 1 depending on whether the runner is closer to the starting line or closer to the finish line. c. The position of the runner is predicted using a model based on performance data captured from previous races. d. The position of the runner is sampled at regular intervals to approximate the real-word position and a sequence of bits is used to represent each sample.
Answer: D
What is a reason to perform additional research on correlation found through data analysis? a. There may not be an actual cause and effect relationship between the correlation variables b. A single source may not provide enough data for a conclusion c. To understand the relationship between the variables d. All of the above
Answer: D
When is sampling needed? a. Sampling is used to store analog data b. Sampling is used to approximate real-world data c .Sampling is used when converting from digital data to analog data d. Sampling is used when converting from analog data to digital data
Answer: D
Which of the following are true statements about the data that can be represented using binary sequences? Binary sequences can be used to represent strings of characters. Binary sequences can be used to represent colors. Binary sequences can be used to represent audio recordings. a. I only b. I and II only c. II and III only d. I II and III
Answer: D
