ITE 115- Exam 3 Questions with Correct Answers Fully Solved

ITE 115- Exam 3 Questions with Correct Answers Fully Solved veracity - Answers 13. What characteristic of Big Data indicates how closely that data matches reality? SQL - Answers 13. Kiera is building a front-end user interface for the database her new website will use. Which of the following languages is NOT used to build a webpage? Open source - Answers 13. Darcie has hired a programmer to make some custom changes to a DBMS she plans to move her business database to. What kind of DBMS is she using? Country - Answers 13. Which of the following would most likely be the key paired with a value of "Canada" in a nonrelational customer database? Availability and Integrity - Answers 13. Which of the following is a key aspect of database security according to the CIA triad security model? Choose two. Data analyst - Answers 13. Morgan needs to hire someone to help implement a business intelligence system for her company. What type of professional would be the best fit for this job? PostgreSQL - Answers 13. Casey is looking for a free, open-source RDBMS for his company. Which of the following best meets these requirements? Spreadsheet - Answers 13. Scarlet needs to create a file to hold a list of expenses for an upcoming project, and she needs to do some basic calculations with the numbers in the budget. Which kind of file is the best fit for this purpose? Evaluating applications for disability benefits and calculating traffic delays during rush hour - Answers 13. Which of the following scenarios would most likely rely on Big Data? Choose two. Customers, Ingredients - Answers 13. Melody is building a database for a restaurant. Which pair of tables is least likely to need a direct relationship with each other? ProductID - Answers 13. Dana is creating a table that will show books for sale on a bookstore's website. Which field in the table would best serve as its primary key? Hyperlink - Answers 13. Which data type would be best suited to a field that lists customer email addresses? Filter - Answers 13. Raphael is working with a table in Access. He needs to see all the records for customers in Chattanooga so he can check the zip codes in that city. Which database tool will show only these records in the table? Data Warehouse - Answers 13. Which data repository type is most likely to include database tables and primary keys in its internal data structure? Customer's credit card number - Answers 13. Which of the following fields would be most important to encrypt in a customer table? SQL - Answers 13. What programming language supports relational databases? FROM Students - Answers 13. Mindy needs to run a SQL query that will pull the names and birthdates of all her students. What should the FROM phrase say in her query? Nonrelational database - Answers 13. What kind of database is needed to hold and organize diverse data types, such as X-ray images and doctors' notes, in a medical database? UPDATE - Answers 13. One of Eden's customers has closed his account and moved to a different state. She needs to change his status to Inactive. What SQL command will accomplish this task? table - Answers 13. Contact information for all the people taking a class at a school are stored in a ________ called Students. digital inclusion - Answers 14. Brad donates his old phone to a nearby charity, which refurbishes phones and offers them at no cost to challenged populations in the area. These people can use the free phones to help them find housing, employment, and other community resources. This program supports ______________. Verify the content with an authoritative source. - Answers 14. Edward shares a blog post on social media that says the Centers for Disease Control (CDC) has changed their recommendation for flu shots. He is quickly bombarded by other people saying his information