ITE 115 EXAM 3 QUESTIONS AND VERIFIED ANSWERS
veracity - CORRECT ANSWER✅✅✅13. What characteristic of Big Data indicates how closely that
data matches reality?
SQL - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅13. Which of the following is a key aspect of
database security according to the CIA triad security model? Choose two.
Data analyst - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅13. Casey is looking for a free, open-source RDBMS for his
company. Which of the following best meets these requirements?
Spreadsheet - CORRECT ANSWER✅✅✅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 - CORRECT
ANSWER✅✅✅13. Which of the following scenarios would most likely rely on Big Data? Choose two.
Customers, Ingredients - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅13. Which data type would be best suited to a field that lists
customer email addresses?
Filter - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅13. Which of the following fields would be
most important to encrypt in a customer table?
SQL - CORRECT ANSWER✅✅✅13. What programming language supports relational databases?
FROM Students - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅13. Contact information for all the people taking a class at a school
are stored in a ________ called Students.
veracity - CORRECT ANSWER✅✅✅13. What characteristic of Big Data indicates how closely that
data matches reality?
SQL - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅13. Which of the following is a key aspect of
database security according to the CIA triad security model? Choose two.
Data analyst - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅13. Casey is looking for a free, open-source RDBMS for his
company. Which of the following best meets these requirements?
Spreadsheet - CORRECT ANSWER✅✅✅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 - CORRECT
ANSWER✅✅✅13. Which of the following scenarios would most likely rely on Big Data? Choose two.
Customers, Ingredients - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅13. Which data type would be best suited to a field that lists
customer email addresses?
Filter - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅13. Which of the following fields would be
most important to encrypt in a customer table?
SQL - CORRECT ANSWER✅✅✅13. What programming language supports relational databases?
FROM Students - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅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 - CORRECT ANSWER✅✅✅13. Contact information for all the people taking a class at a school
are stored in a ________ called Students.
