part 2 test

Data centralization means that data is centralized in ________ place(s).

1

Analytical skills necessary for a data analyst include the characteristics and capabilities that allow for the observation, research, and interpretation of a problem or change in a desired state. According to Google, there are five essential aspects of analytical skills including which three of the following?

Curiosity, understanding context, data strategy

The acronym for a database administrator is ________.

DBA

the acronym for Data Governance is _________

DG

Because many business executives desire to create a data-driven decision making culture, which three of the following are competencies organizations invest in to support DDDM?

Data proficiency agility in analytics and data analysis building a data-driven community

Qualitative data that is not categorized is called nominal data. Qualitative data that is categorized (ranked, for example) is considered _____ data.

Ordinal

When data is anonymized, the PII is eliminated or encrypted. PII includes names, Social Security numbers, addresses, and more and stands for ______ identifiable information.

Personally

Which of the following is a popular Microsoft data analytics program that offers business intelligence as well as data visualization?

Power BI

Collections of related fields in a database are referred to as

Records

Questions that data analysts often ask include which three of the following?

What overall outcomes and results that are needed? Who will receive the information and analysis What are the time constraints for the project

There are many RDBMS query tools we can use. Those query tools include crosstab queries, ________ queries, parameter queries, and queries specific to SQL.

action

One of the ________ of data warehouses is their ability to provide access and analysis of information from a variety of subject areas.

advantages

Someone who possesses the knowledge of processing software, business strategy, and analytical skill to deliver data and reports that guide management and executives as they create well-informed decision making is known as a data

analyst

The six-step process analysts use to create data-driven decision making includes which three of the following?

ask analysis prepare

The role of a DBA is to ________ and maintain tables in a relational database.

build

Data analysts must blend facts and data with knowledge about the

business or organization

A cloud database is a type of database developed on a ________ platform and retrieved by a cloud platform.

cloud

The Foreign Key is a ________ field between tables that is not the primary key.

common

What type of field is used in both tables to create a relationship?

common

Which three of the following are examples of data transformation?

copying or replicating data standardizing names and variables across data sets the deletion of database fields or records to ensure data integrity

Most organizations do not develop their own DBMS; instead, they use DBMS created by which three of the following?

oracle micrososft IBM

RAM storage and ________ processing are two main in-memory computing components.

parallel

When working in Microsoft Power BI, which three tiers are available?

power bi pro power bi premium power bi desktop

Entities in Diagrams of Entity Relationship (ERD) are the many business objects that make up the database. Such objects contain:

roles/people tangible business objects intangible business objects

Data-driven decision making (DDDM) can be facilitated through a six-step processes of Ask, Prepare, Process, Analysis, Share, and Act. Which of these steps refers to creating visualizations and presentations for key stakeholders?

share

Database policies should be created and implemented by all organizations, regardless of the ________ of the organization.

size

An independent data mart is a(n) ________ system created separate from a data warehouse and focused on specific organizational functions.

stand-alone

Structured Query Language (SQL)-specific queries use specific SQL ________ to execute the query.

statements

In computer programming, a set of rules and guidelines that define a specific computer language is referred to as the language's

syntax

Relational databases organize data into ________ based on structured data groupings.

tables

In order to make understanding and interpretation of SQL queries easier, users have the ability to add comments. The symbol(s) that will tell SQL that an entry is a comment and should not be used in the query is(are)

two dashes

Usability in web mining refers to how a website ________ and ________ can interact with a website.

users visitors

One of the ways web mining improves web experiences is through site visibility. Site visibility includes how and ________ the website appears when queries are executed in a search engine.

when

Data analysts are likely to have achieved what education level when beginning their career?

Bachelor's degree

Select three critical factors to consider when determining the right data to select?

How will the data be collected? What types of data do you need to solve a specific problem? How much data should be collected?

Data redundancy can lead to which three of the following?

Increased storage fees Inefficient access times Inconsistent data

The major advantages of executing a data quality audit include ________.

Reduced risk of data inconsistency Reduced data storage costs data improvement recommendations

Using the correct syntax allows the user to extract data from multiple fields found in data tables. In order to extract information from multiple tables, the ______ command is used to indicate multiple fields in conjunction with FROM and WHERE to narrow the search and get specific results.

SELECT

What does the abbreviation SQL stand for?

Structured Query Language

Which of the following is a popular data analytics program that offers business intelligence as well as data visualization?

Tableau

Basic DBMS functions allows users to ______, read _____, and ______ data

create, update, delete

The 3-step data visualization process consists of exploring the data sets for pattern, then planning for visuals, and finally

creating your visuals

When working in Tableau, users can assume which three roles?

creators explorers viewers

We use database forms to control how _____ enters a database

data

Knowledge Discovery in Data (KDD) is also known as ________.

data mining

Using a traditional filing system (noncomputer) led to many problems like ________ and ________.

data redundancy inconsistency

________ involves identifying errors in data sets and removing/correcting these errors to ensure the data is accurate.

data scrubbing

Some of the responsibilities of a data analyst include which three of the following?

data visualization data structuring data reporting

Reports offer a way to view, format, and summarize the information in a ________.

database

Which three of the following are major varieties of data formats?

discrete data structured data unstructured data

Search Engine Optimization can be ________ through the information gained by web mining

enhanced

Uses of data analytics include which three of the following?

improved decision making improved patient experiences and internal procedures in health care improved customer service

Database forms structure data input to ensure data ________.

integrity

Data marts are used to track ________, purchase transactions, and the supply chain.

inventories

A database relationship is a(n) ________ between tables that define how the data are related.

link

When discussing personally identifiable information (PII), which three of the following are usually anonymized?

names phone numbers ss numbers

Data administrators are responsible for the ________ and procedures used to handle the information of an organization. Large companies use/implement the data management policies and procedures most often.

policies

A database and a DBMS are different. A database is a collection of metadata, relationships, and ________.

tables

What object is used to store information when creating a database?

tables

For data to be considered open data, it must have what three characteristics?

the public must have access and datasets must be available for use datasets must have access rights that allow them to be reused and redistributed datasets must be universally available so that anyone can use the data

When selecting the right data, it is important to be aware of the source of the data. For example, data that is sold by an entity that didn't actually collect the data is considered ______ data.

third-party