CompTIA Data+ (DA0-001)

Type 3

Each time a home and garden company orders more garden hoses to stock its stores, the database creates a new column to store the number of hoses ordered next to the column that holds the number of hoses the company ordered the last time. Which type of slowly changing dimension does this represent?

1

How many records in a relational database table may have the same primary key value?

This method will only show the most current name of the product in reports dated prior to the name change, even if the product name was originally something different.

If the name of a product changes using Type 1 slowly changing dimensions, what impact would this method have on reporting prior to the change?

qualitative data

If you ask people to tell you their favorite tv show, what type of data are you collecting?

record

In a tabular dataset, what term is used to describe the data that appears in a single row?

Source system

In an organization, which technology holds a system of record, or is a software system dedicated to a specific task?

2NF The data is in the Second Normal Form (2NF) where related information that is applicable to multiple tables will have its own table and will be associated through the use of a foreign key.

A customer service representative is looking at customer data on the company's software program, which stores the data in multiple tables. The customer information is in one table and the software interface identifies them by their customer account number. The software also uses codes, pulled from another table, to represent the different types of customer charges. What form is this data in?

The animals represent nominal data. Even though they are all animals, one animal is not less than or greater than another so there is no natural order.

A data analyst is adding a count to a list of animals to include them in a larger set of data for analysis. What kind of data do the animals represent?

It is a common data warehousing schema. Dimension tables join to fact or dimension tables.

A data analyst is querying data that resides in a snowflake schema. Which of the following is true of table structure? (Select all that apply.)

RBMS

A data analyst is using software to manage and manipulate tabular schema. What is this referred to?

The oceans represent nominal data as there is no natural order, and the salt levels represent continuous as it is a measurement.

A data analyst is working with a dataset that includes all the oceans of the world categorized by the level of salt each one contains. What kind of data types do the oceans and salt levels represent respectively?

Quantitative Continuous

A data analyst is working with a recipe database and needs to determine how many of the recipes use oil and the average amount of oil each recipe calls for. What kind of data represents the amount of oil used in each recipe? (Select all that apply.)

Data warehouse

A data analyst needs to analyze data and create reports using only the single source of truth for every data source used by a global online retailer to create accurate sales, profit, inventory, staffing, and salary projections for executive leadership. What data storage technology must the analyst use?

No, because of the field that holds the total amount of the attendee's purchase.

A data analyst needs to calculate the number of swag purchases made at a conference, the number of attendees that made a purchase, and the total amount of the purchases. The database has an Alphanumeric field to hold the attendee's name, a Boolean field to indicate if the attendee made a swag purchase, a Number field to indicate how many items an attendee purchased, and an Alphanumeric field to hold the total amount of the attendee's purchase formatted with a dollar sign. Using those fields, will the analyst be able to make the correct calculations?

Fact data changes more than dimension data. Dimension data is categorical.

A data analyst tracked a single data source over a one-month period to see how it would change. Which of the following statements regarding fact and dimension data are true? (Select all that apply.)

The company uses relational databases.

A data analyst went on a job interview and discovered that SQL is a required skill for the job. Based on this requirement, what does the analyst know about the company?

Boolean

A data analyst works with databases managed by different types of software and each piece of software uses account numbers made up of both letters and numbers. Which of the following would NOT represent a field data type for the account numbers in any of the databases?

Column-oriented

A database administrator is creating a database that will record customer orders. Which of the following non-relational database types will the administrator create to calculate the total number of orders taken in a day?

Number of bathrooms on the property (The smallest data type most likely holds the number of bathrooms on the property and the architect would select that to reduce the amount of storage needed for the database.)

A database architect is designing a database for real estate software and selects the smallest field type for a certain data field. What data does the smallest field type most likely hold?

Currency

A database architect is designing databases to hold data for a global online retailer. Which of the following field data types would the architect be sure to designate in the database schema to indicate total dollar amount values?

It is a referential integrity option. It updates all foreign key records.

A database designer applied the cascade update option to a foreign key. What is true about this option? (Select all that apply.)

Primary key

A database designer created a table to track book information for a school library and used a unique identifier for each book. What is the book identifier called?

Normalize data Create primary keys

A database designer is creating a relational database. What must the designer do before establishing relationships between the data in different tables? (Select all that apply.)

The designer will need to establish relationships between data. The analysts will use the database with an RDBMS.

A database designer is reviewing a list of requirements for a new database and has determined that the new database will be relational. Which of the following requirements did the designer see on the list that helped make this determination? (Select all that apply.)

Boolean Text/Alphanumeric

A database that holds survey data includes fields for each user to enter their name, phone number, and whether or not they liked the new version of a soft drink. Which of the following field data types did the database architect use? (Select all that apply.)

data mart

A global online retailer takes more than 4000 orders per second. The company needs to determine the optimal amounts of different types of inventories to send to warehouses in different parts of the world based on average customer orders. What can the company use to ensure the analysts have access to the data they need to make these determinations without giving them access to each individual source system? A.

Source Systems

A global online retailer takes more than 4000 orders per second. The company uses separate systems to manage the orders, the employees, the customers, inventory, and more. What are these systems referred to as?

OLAP

A global online retailer takes more than 4000 orders per second. What is the retailer using to analyze the orders and update inventory across the platform without slowing down the system for customer ordering?

Type 1

A home and garden company orders supply from a company that recently changed its name due to a merger with another supply company. The home and garden company updated the name in the database by overwriting the name of the original supply company. Which of the following dimensions did the home and garden company employ?

Type 2

A home and garden company upgraded the type of garden hose it sells in its stores. Although the company discontinued the previous type of garden hose, they still honor the warranty on it and need to maintain the product information in the database. Which of the following dimensions should the home and garden company use?

Qualitative data is also known as categorical data because users can arrange it into groups/categories based on the qualities of the data, but these qualities in and of themselves do not have a number value.

A large organization purchased a small company and provided a data analyst with the previous five years' pie charts representing the small company's revenue streams. What will the analyst need to convert that data to before analyzing it?

One-to-many cardinality

A library database uses a book table to store the information for each book in a record. The designer used the primary key in the book table to identify the book in the library loan and the library hold tables. What type of cardinality does this represent?

Query data across multiple sources. Understand how data changes.

A student is training to become a data analyst and is learning the typical responsibilities of a data analyst position. Which of the following statements regarding data analysts are true? (Select all that apply.)

Quantitative and qualitative

A student studying to be a data analyst is learning about types of data. Users measure one of the types in numbers and define the other one by qualities of the data. What are these two major, high-level data types?

This is ordinal data, because it has a natural occurring order.

Suppose a survey asks respondents for their level of education. This would be considered qualitative data with which characteristic?

Field names and data types

What are the two main components of a table design?

Star and Snowflake Schema

What are two common schemas that are used to relate data in a data warehouse?

Datawarehouses, data lakes, and data lakehouses

What choices do organizations have when they want to combine data from different source systems into one unified data management system?

string

What data type is most appropriate for storing postal codes, such as U.S. ZIP codes?

The field data type designed within a system

What feature controls what type of information is stored in a field?

SQL

What is the language used for relational databases?

no maximum

What is the maximum number of values that may be assigned to a single key in a key/value store?

Datalake

What is the most flexible storage system for holding large amounts of both structured and unstructured data?

quantitative and qualitative

What two types of data are at the highest level?

snowflake

What type of analytic data schema allows dimensions to have subcategories?

Document store

What type of database is designed to store data in JSON or XML format?

Dimension table

What type of table stores information that is categorical for the use of reporting?

Continuous

When data can be measured, which characteristic of data is it?

Quantitive data

When determining how much product was ordered over time, the quantity ordered is which high-level type of data?

Alphanumeric, text or string

Which field data type is the most versatile of all?

geolocation

Which of the following data elements would not normally be stored in binary format?

uses primary and foreign keys

Which of the following is NOT a characteristic of NoSQL databases?

temperature of a room

Which one of the following is not a good example of a discrete data type?

1.2

Which one of the following values would not be appropriately stored in an integer data type?

Type 2

Which slowly changing dimension type provides the most complete history of dimension data, and why?

Datamart

Which subset of a data warehouse holds data that is relevant to a specific department?

Relational database

Which type of database do you use when needing a defined structure with relationships between the data?

Non-relational database (NoSQL)

Which type of database provides the most scalable and flexible options for web-based clients?

Non-relational or NoSQL

Which type of database stores data in a document format and uses XML or JSON?

Type 2

Which type of slowly changing dimension is in use when a new record is added to account for a change to dimension data?

data

You recently downloaded a file containing website visitor logs from your organization's web server. What term best describes these logs at this point in the process?

False

Most data that exists in the world is structured data.

False

OLAP databases generally use more tables than OLTP databases.