19 Questions
Which technology delivers information from various data sources, including big data sources, in real-time and near-real time?
Data virtualization
What is the primary function of data integration tools across solutions such as Amazon EMR, Apache Hive, and Hadoop?
Data orchestration
What does data preparation software aim to do for diverse and messy data sets?
Ease the burden of sourcing, shaping, and cleansing the data
Which products conduct data cleansing and enrichment on large, high-velocity data sets using parallel operations on distributed data stores and databases?
Data quality products
What is the primary purpose of predictive analytics?
To discover, evaluate, optimize, and deploy predictive models by analyzing big data sources to improve business performance or mitigate risk.
Which type of databases include key-value, document, and graph databases?
NoSQL databases
What is the primary function of stream analytics software?
Filter, aggregate, enrich, and analyze a high throughput of data from multiple disparate live data sources.
What is the main function of in-memory data fabric?
Provides low-latency access and processing of large quantities of data by distributing data across the dynamic random access memory (DRAM), Flash, or SSD of a distributed computer system.
What is the purpose of the relational data model and SQL?
To define the structure of data and ensure its integrity using constraints like primary keys, foreign keys, and unique constraints.
What is the primary purpose of a relational database management system (RDBMS)?
Storing data in a tabular format
In the context of relational databases, what is the significance of Codd's 12 rules?
Defining the characteristics of a relational database system
What was the purpose of IBM's System R project initiated in 1974?
Developing a prototype RDBMS
What was the significance of Multics Relational Data Store, introduced in June 1976?
First commercial RDBMS available for purchase
Which language is commonly used for querying and updating relational databases?
SQL (Structured Query Language)
Which of the following is NOT an example of an RDBMS?
MongoDB
What is the unique key identifying each row in a table called?
Primary key
Which organization developed the first RDBMS relatively faithful to the relational model?
IBM UK Scientific Centre at Peterlee
What does a truly-relational database management system (TRDBMS) implement according to strict adherents to Codd's principles?
All of Codd's 12 rules
What concept was demonstrated by Codd to represent data relationships of arbitrary complexity?
Foreign keys
Test your knowledge on database systems and predictive analytics with this multiple choice quiz. Explore topics such as database system architecture, relational data modeling, SQL, ER modeling, normalization, denormalization, and predictive analytics for business performance improvement.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free