BUAL 5650 exam 1 Auburn Exam Study With Questions And Verified Answers.

True - correct answer Data Management is more focused on the acquisition and preparation of data False - correct answer A core task in the "data analytics" is building databases True - correct answer Data analytics includes the application of statistical modeling tools or other techniques to get information from the data False - correct answer Semi-structure data does not have any organizational property Veracity - correct answer Volume, velocity, and variety are the three Vs of big data. What is the fourth? Thing that users want to store - correct answer An entity in a relational database is a(n): _______ One table must have a primary key and the other must have a foreign key - correct answer Which of the following must be true for two tables to be related? _____ Structured Data: RDBMS is not a good fit Unstructured Data: RDBMS is a good fit - correct answer Which of the following is an incorrect comparisons of big data types? _______ Twitter data - correct answer Which of the following is an example of semi-structured data? _______ Relational Database Management System - correct answer RDBMS stands for: Distributed Computing - correct answer A (__________) refers to a technique that allows computers to be connected and work together False - correct answer A commodity cluster refers to using a larger number of high-performance computers in serial False - correct answer Parallel processing is the act of processing one task at a time Discontinue in operation after a fault has occured - correct answer Which one is NOT TRUE about the distributed computing? Scalability - correct answer (__________) refers to the capability to sustain a certain level of performance under increasing loads At the end of the transaction, all data must be left in a consistent state - correct answer Consistency, in the context of ACID, means that ___________ False - correct answer Online Transaction Processing (OLTP) supports data analysis rather than data processing Relational - correct answer NewSQL databases use which of the following data models? Relational - correct answer Which of the following is not a data model used in NoSQL databases? Improved ability to keep data consistent - correct answer Which of the following is not a reason NoSQL has become a popular solution for organizations? _______ Eventual Consistency - correct answer (____________) is the idea that all of the data will become consistent over time Tasks in a transaction must either be completed, or none of them are performed - correct answer Atomicity refers to the fact that ____________ Avoid the rigid schemas of relational model - correct answer Which of the following is a characteristic of NoSQL databases? B) A NewSQL database does not follow the relational model C) A SQL database is better than a NewSQL database to handle a large volume of data - correct answer Choose all of the incorrect statements regarding SQL and NewSQL databases: Data Warehouse - correct answer A ( ) is a federated repository for the data collected by an enterprise's various operational systems Independent Data Mart - correct answer The high cost of data warehouses limits their use to large companies. As an alternative, many firms use a lower-cost, scaled-down version of a data warehouse referred to as a(n) (_________) A data warehouse stores historical data - correct answer Which of the following is true regarding a data warehouse? _______ A data mart cannot be an alternative to a data warehouse - correct answer Which of the following is not true regarding a data mart? _______ Data Mart - correct answer Limited resource and the need to build a data warehouse solution to satisfy an immediate business pain often lead organizations to select a(n) __________ approach to satisfy their information needs Extract, Transformation, and Load - correct answer Which one refers to the process of gathering data from multiple sources, organizing it, and placing it into a data warehouse? _______ Hub and Spoke - correct answer ( ) architecture comprises a central data warehouse as well as data marts for business units which are connected. Subject-Oriented, Integrated, Time-Variant, and Non-Volatile - correct answer What are the characteristics of a data warehouse? Data Lake - correct answer What is a repository of data containing all enterprise data in its natural or raw format? Hadoop - correct answer - A distributed processing framework that is widely used for most big data technologies (_______) - big data platform for storing store data and run applications on clusters of commodity hardware Hadoop distributed file system - correct answer ( ) is used to store data in Hadoop. ( ) holds very large amount of data and provides easier access. To store such huge data, ( ) breaks the file (entire data) into one or more segments and distributes them to different nodes In-Memory Database - correct answer With (________), the queries and data reside in the server's random access memory (RAM). Because stored data is accessed much more quickly when it is placed in RAM True - correct answer Both data warehouse and data lake are a centralized repository to store data False - correct answer A Hadoop data lake and data warehouses cannot be used to complement each other False - correct answer A data warehouse is a repository for unstructured data True - correct answer Data lakes primarily store raw, unprocessed data, while data warehouse store processed and refined data Schema-on-write - correct answer In ( ), the structure of that data is strictly defined before any data is stored in the database Data Management - correct answer •Acquisition/Preparation of data •Storing data •Building database