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