ISC 2 M6

Which of the following best describes captured transactional data in an operational data storage (ODS)?

Activities such as customer orders, sales, and vendor payments

Which of the following is a characteristic of a snowflake schema?

The dimension tables are broken down into multiple related tables, rather than a single table.

Each of the following are considered benefits associated with relational databases except for which of the following?

Combining attributes to create unique identifiers

The benefits:

No redundancy

Business rules enforcement

Communication and integration of business processes

Sunriss Cars Inc. is designing a database. The "Car_Inventory" table contains data about cars available for sale. The table has the following attributes: CarID, Make, Model, Year, and SalesPersonID. Each car has a unique CarID, and each salesperson is identified by a unique SalesPersonID. To ensure the Third Normal Form (3NF) in your database design, what should Sunriss consider?

Eliminating any attributes that depend on both SalesPersonID and CarID.

Which of the following schemas is likely to require the most set of foreign keys to link tables together?

Snowflake schema

Jen manages multiple data repositories for Savestone Tax Services. One of the repositories Jen manages does not have a predefined data structure or schema, nor is the stored data indexed or prepped, so users can access the data in its original form. Which type of data storage does Jen's managed data repository best describe?

Data lake

Algexo Corporation is establishing a data dictionary to help its database administrators maintain the database and help ensure that its analysts can identify the data needed. Which of the following best describes a scenario where Algexo Corporation's data dictionary is not functioning appropriately to accomplish the organization's goals?

The "Invoice Date" attribute within the database provides information related to the date that payment was received by the corporation from the customer.

Which database schema, commonly used for dimensional modeling, is best described as one where data is organized into a central fact table with associated dimension tables surrounding it?

Star schema

Gregory is a CPA who is in the process of normalizing data within his tax client's database to reduce redundant data and reasonably assure that data is logically stored. As part of the process of normalization, which of the following should be the first step taken by Gregory to normalize his tax-client data?

Determine whether each field in the table contains only one piece of information and whether each record is uniquely identifiable through the use of a primary key.

Which of the following terms best describes a set of instructions that tell the database engine how to organize data to be in compliance with the data models and specify how the data will be stored and accessed?

Database schema

In a relational database for an e-commerce platform, there are two tables: CustomersTable1 and OrdersTable1. The CustomersTable1 stores data about each customer, including customer names and addresses, while the OrdersTable1 contains data about the orders placed by customers, such as order IDs, products ordered, and order dates. Why is it beneficial to have two separate tables?

Establish relationships between customers and their orders, allowing for efficient data retrieval and analysis.

Which of the following is best described as a very large data repository that is centralized and used for reporting and analysis rather than for transactional purposes?

Data warehouse

Which of the following database schemas is best described as a more complex schema requiring the greatest number of foreign keys to link tables together but allows for added flexibility by allowing for more detailed information to be stored about the dimensions?

Snowflake schema

Which of the following statements about a data warehouse is correct?

It must be continuously updated to remain relevant.

Which of the following best describes a foreign key within a relational database?

Attributes in one table that are also primary keys in another table

You are designing a database for a retail business, and data quality is a top priority. You need to create a system that uniquely identifies each product in your inventory. Which type of attribute should you use for this purpose?

Primary Key -Inventory ID

Kidell Corporation is considering establishing a normalized, relational database to store key data needed for decision making. Kidell Corporation contracted with Peggy to help determine whether a relational database is needed. Which of the following would Peggy most likely identify as a benefit associated with relational databases to assist Kidell Corporation?

Relational databases assist with the goal that all data required for a business process is included within the data set.

How can the use of relational databases improve data management and integration across various departments and processes within an organization?

Facilitating efficient communication and integration across functional areas.