Database Management Quiz 8

lOMoARcPSD|23780900 The volume of Big Data generated over time is typically measured in terms of ____________. terabytes Jenson needs to update his home address in his health insurance company's database. Which of the following applications can he open on his computer so he can make these changes? A browser Hackers pose the only real risk to database security. False What characteristic of Big Data indicates how closely that data matches reality? veracity Which field could serve as the primary key for a list of students in your school? Student ID number Which of the following tables in a database would NOT need to be encrypted? Store_Locations 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? UPDATE Kian needs to sort a list of patients by birthdate to show the oldest patients first. What sort order on the birthdate field will give him this result? lOMoARcPSD|23780900 Smallest to largest Which of the following is a key aspect of database security according to the CIA triad security model? Choose two. Availability & Integrity Which of the following would most likely be the key paired with a value of "Canada" in a nonrelational customer database? Country Which of the following is NOT an RDBMS? Oracle NoSQL Database Which of these file types is optimized for processing calculations of numbers in a budget? Spreadsheet Which of the following scenarios would most likely rely on Big Data? Choose two Calculating traffic delays during rush hour & Evaluating applications for disability benefits Which of the following would most likely be a key in a key-value database of investment properties owned by a company? ZoneType A national bank processes approximately 1,500 transactions per second. The fact that the bank's database must add this many Big Data records every second refers to its high _________. Velocity lOMoARcPSD|23780900 Which of the following job roles would most likely need permission to delete records in a Customers table? Accountant Database administrator Students who complete an online test are not allowed to change their test grades. What aspect of the CIA triad is at work here? Integrity Which of the following is NOT a risk to a company or its employees as a result of a data breach? Increased database efficiency 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? Open source 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? Nonrelational databaseFre Some nonrelational databases support SQL-based languages. True Sawyer is looking at a table of students in his class, but it seems like the list is way too short. What is the most likely problem? The table is filtered. 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? ProductID lOMoARcPSD|23780900 Which type of data storage allows for the most variety of data types? data lake During a thunderstorm, the database server for Jason's store loses power. This is an example of failed _________. availability Casey is looking for a free, open-source RDBMS for his company. Which of the following best meets these requirements? Oracle Database PostgreSQL Malisa is designing a database for a doctor's office where receptionists, office managers, and other office staff will need to manage patient data. Which database object should Malisa create to make it easy for these non-technical users to add patient records? Forms A database backup can include information on who made what changes and when since the previous database backup. True Xavier is designing a Students table that will continue to track students even after they have completed their programs. Which of the following fields would work best with the Yes/No data type? Graduated Melody is building a database for a restaurant. Which pair of tables is least likely to need a direct relationship with each other? Customers, Ingredients All the pet names in a veterinarian's database are stored in a _______ called PetName. lOMoARcPSD|23780900 Field 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? Filter 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? Spreadsheet Which data type would be best suited to a field that lists customer email addresses? Hyperlink Ibraheem works for a music store. Which of the following tables will give him the company contact information he needs to place a custom order for a guitar? Vendors 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? Data analyst Randall needs to monitor rapidly changing statistics for a social media campaign for his company. Which of the following should he use to access this information? Dashboard Aron is building a website that will require a back-end database. He plans to connect the web server on his network in a way that it will be easily accessible from the Internet. He should connect his database lOMoARcPSD|23780900 server the same way so data in the database is readily accessible to the web server. False Which of the following fields would be most important to encrypt in a customer table? Customers Credit Card Number