7.5.6 Practice Questions

4/28/22, 8:09 AM Section Quiz Candidate Passing Score: 80%  Question 1:  Score: 100% Correct Which type of data have elements in common but do not fit into rigid rows and columns in a table? Structured Non-structured Semi-structured Non-relational EXPLANATION Somewhere between structured and non-structured data are semi-structured data. These data don't fit into the rigid rows and columns of a table but have some similarities. Structured data is data that can be divided into discrete categories. Non-structured data is data that doesn't follow a clear pattern. The term non-relational refers to a database that does not follow the relational model that most traditional databases do. REFERENCES  7.5.1 Non-relational Databases  7.5.2 Non-relational Database Facts  7.5.4 Big Data  Question 2:   7.5.5 Big Data Facts Correct What is the technology that aggregates structured data from one or more sources called? Data warehousing Relational Big Data Non-relational EXPLANATION Data warehousing is a technology that aggregates structured data from one or more sources. It allows you to use data from different kinds of databases at the same time. The term relational refers to relationships between items in a database. It is not a technology that aggregates the data from multiple sources. The term non-relational refers to a database that does not follow the relational model that most traditional databases do. Big Data refers to the vast amounts of data collected and stored online based on internet searches, social media posts, customer transactions, military surveillance, medical tests, and weather sensors. 1/4  Question 3:  4/28/22, 8:09 AM Correct Which of the following acronyms describes the traditional way to make sure data stays consistent across the entire database? SQL DBA CRUD ACID EXPLANATION ACID (Atomicity, Consistency, Isolation, and Durability) transactions are the traditional way to make sure that data stays consistent across the whole database when it is moved around. CRUD (Create, Read, Update, and Delete) describes the four main tasks users need to be able to perform for a database to function properly. SQL stands for Structured Query Language. This is the language that most database programs use.  Question 4:  DBA stands for database administrator. Correct Which of the following needs to be done before Big Data can be analyzed and interpreted? Data analytics Securing data Data mining Data extraction EXPLANATION Before analyzing and interpreting Big Data, it needs to be gathered and organized. This process is called data extraction. Data mining is a broad and open-ended analysis of extracted data. Data mining experts use automated tools and algorithms to discover trends or patterns in the data. Big Data analytics is the process of asking specific questions to help interpret data.  Question 5:  Securing data refers to the specific security challenges that come along with non-relational databases. Many of these databases have securities issues. Correct Vast amounts of data are collected and stored online based on internet searches, social media posts, customer transactions, military surveillance, medical tests, and weather sensors. What is this known as? Data mining Data analytics Big Data Data extraction EXPLANATION Big Data refers to the vast amounts of data collected and stored online based on internet searches, social media posts, customer transactions, military surveillance, medical tests, and weather sensors. The term can also refer to the tools and processes used by data engineers and analysts to make sense of this data. Data mining is a broad and open-ended analysis of extracted data. Data mining experts use automated tools and algorithms to discover trends or patterns in the data. Before analyzing and interpreting Big Data, it needs to be gathered and organized. This process is called data extraction. Big Data analytics is the process of asking specific questions to help interpret data. 2/4  Question 6:  4/28/22, 8:09 AM Correct What are non-relational databases that deal with Big Data often referred to as? CRUD RDBMS SQL NoSQL EXPLANATION Non-relational databases that arise from Big Data are often called NoSQL. NoSQL databases are sometimes called Not only SQL since the query languages that support them are often used in conjunction with certain relational database features that do support SQL. SQL, or Structured Query Language, is the computer language that makes relational databases work. RDBMS stands for relational database management system. These are traditional relational database programs.  Question 7:  CRUD (Create, Read, Update, and Delete) describes the four main tasks users need to be able to perform for a database to function properly. Correct The concern that Big Data is often obtained without the knowledge or consent of users falls under which Big Data concept? Data ethics Data extraction Data mining Data analytics EXPLANATION The ethics of Big Data can be a major concern. Since Big Data is often obtained without the knowledge or consent of users, information can be sold to other organizations in a way that violates users' privacy. Another potential problem is that Big Data analytics can uncover misleading or harmful information about innocent people. Big Data analytics is the process of asking specific questions to help interpret data. Data mining is a broad and open-ended analysis of extracted data. Data mining experts use automated tools and algorithms to discover trends or patterns in the data.  Question 8:  Before analyzing and interpreting Big Data, it needs to be gathered and organized. This process is called data extraction. Correct What is asking specific questions to interpret Big Data called? Data extraction Data ethics Data mining Data analytics EXPLANATION Big Data analytics is the process of asking specific questions to help interpret data. Data mining is a broad and open-ended analysis of extracted data. Data mining experts use automated tools and algorithms to discover trends or patterns in the data. The ethics of Big Data can be a major concern. Since Big Data is often obtained without the knowledge or consent of users, information can be sold to other organizations in a way that violates users' privacy. Before analyzing and interpreting Big Data, it needs to be gathered and organized. This process is called data extraction. 3/4  4/28/22, 8:09 AM  Question 9: Correct An application developer needs to store configuration data that can be retrieved each time the application is launched. The data must be in a format that could be easily viewed outside of the application and edited using any editor. Which of the following would be the BEST choice? Binary flat file Relational database Database Management System Text-based flat file EXPLANATION A flat file database is a simple file, such as a text or binary file, that contains records that use a standard format. The flat file doesn't provide indexing or relationships between records. The best choice would be to use a text flat file that could be opened by other applications. A relational database and a database management system would be overly complex for this purpose. A binary flat file cannot be opened by other applications in general, such as a text editor. REFERENCES  7.3.1 Relational Databases  Question 10:   7.3.2 Relational Database Facts Correct The vast amount of data collected from Internet searches, social media posts, customer transactions, military surveillance, medical tests, weather sensors, and other data sources are collectively referred to as ________________. Omni Data Big Data Business Data Metadata EXPLANATION These data are often called "Big Data." REFERENCES  9.2.2 Types of Information Systems  9.2.3 Information System Facts  9.3.1 Data and Information Assets  9.3.2 Data and Information Facts https://labsimapp.testout.com/v6_0_497/index.html/examengine/795dd741-5a71-4e8c-89fd-6f481f1c6091/17513507/dbb42451-625e-4367-8166-30f17… 4/4