Databases and Data Analytics

Databases maintain data and information about various types of data ______

a. objects

b. security

c. developments

d. information

a. objects

Information in tables is stored in _____ called records and _____ called fields.

a. rows

b. columns

c. tables

d. queries

a. rows

b. columns

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

a. columns

b. common

c. primary

d. foreign

b. common

Which of the following (3) are standard SQL commands?

a. update

b. create

c. drop

d. add

a. update

b. create

c. drop

Using a traditional file system (noncomputer) led to many problems like ____ and ___.

a. data redundancy

b. data inconsistency

c. data integrity

d. foreign key

a. data redundancy

b. data inconsistency

A record is a _____ of related fields in a data file.

a. button

b. characteristic

c. highlighted area

d. collection

d. collection

Popular applications used by todays organizations in web mining include Google Analytics, Data Miner, and _____.

a. tab miner

b. tablet

c. tanalytics

d. tableau

d. tableau

What does the abbreviation SQL stand for?

a. standard query language

b. structured quality language

c. structured query language

d. standard quality language

c. structured query language

Data centralization is necessary for maintaining ______.

a. data filing

b. data queries

c. data integrity

d. data keys

c. data integrity

Search Engine Optimization (SEO) can be ______ through the information gained by web mining.

a. abated

b. diminished

c. enhanced

d. engaged

c. enhanced

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

a. fabricator

b. financer

c. analyst

d. adminstrator

c. analyst

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

a. discrete data

b. structured data

c. unstructured data

d. speculative data

a. discrete data

b. structured data

c. unstructured data

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

a. the data must be primary data

b. the public must have access and datasets must be available for use

c. datasets must have access rights that allow them to be reused and redistributed

d. datasets must be universally available so that anyone can use the data

b.

c.

d.

Data transformation is the process of converting the ____ of data.

a. privacy

b. format

c. source

d. scope

b. format

Analytical skills are 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?

a. sensing

b. curiosity

c. understanding context

d. data strategy

b. curiosity

c. understanding context

d. data strategy

Trends in data analytics include which of the following?

a. scalable AI

b. virtual analytics

c. composable data

d. data analytics as a core business function

a. scalable AI

c. composable data

d. data analytics as a core business function

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

a. what overall outcomes and results that are needed?

b. who will receive the information and analysis?

c. what are the time constraints for the project?

d. how much is the company being paid for my analysis?

a. what overall outcomes and results are needed?

b. who will receive the information and analysis?

c. what are the time constraints for the project?

A major trend in data analytics is the use of artificial intelligence to focus on small data which is more precise, using small datasets that are capable of impacting decisions in the present. This is known as ____ AI.

a. predictive analysis

b. composable

c. scalable

d. data fabric

c. scalable

The main tools used by data analysts include which three of the following?

a. spreadsheets

b. Punnett squares

c. databases and query languages

d. data visualization tools

a. spreadsheets

c. databases and query languages

d. data visualization tools

Data analysts must blend facts and data with knowledge about the

a. political environment

b. national GDP

c. business or organization

d. SWOT analysis

c. business or organization

Areas covered in digital governance include data architecture, data modeling, data warehousing, and data _____

a. administration

b. policies

c. security

d. fields

c. security

A DBMS provides the ability to _____, query, and store information in databases for managers and database administrators.

a. design

b. monitor

c. store

d. provide

b. monitor

_____ is a software with processing capabilities outside of what the operating system of the computer program provides.

a. processing software

b. computer wear

c. eveningwear

d. middlewear

d. middlewear

Accessibility in web mining includes the structure of the _____ and _____ to ensure device/platform access and scalability.

a. websites

b. pages

c. servers

d. screen readers

a. websites

b. pages

Data integrity means the database is reliable, _____, and aligned to the goals of the organization.

a. increasing

b. accurate

c. inconsistent

d. inaccurate

b. accurate

The main objectives of data governance include high-quality and which other goals?

a. risk mitigation

b. data use rules

c. requirement compliance

d. cost saving

All of the above

Data redundancy can lead to which three of the following?

a. increased storage fees

b. inefficient access times

c. inconsistent data

d. data leaks

a. increased storage fees

b. inefficient access times

c. inconsistent data

To set a primary key field in a database table, you must click the _____ key button.

a. secondary

b. foreign

c. database

d. primary

d. primary

Trying to answer questions such as "what happened," or "what is occurring," or "what was the ROI," is the role of

a. prescriptive analytics

b. tracking analytics

c. descriptive analytics

d. predictive analytics

c. descriptive analytics

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

a. act

b. share

c. analysis

d. ask

b. share

SQL allows users to isolate specific information contained in a database, as well as to aid in the selection, creation, addition, and extraction of data from a database. SQL stands for ______ query language.

a; structured

b. simple

c. spreadsheet

d. share

a. structured

Qualitative data that is not categorized is called nominal data. Qualitative data that is categorized is called ____ data.

a. external

b. continuous

c. ordinal

d. second-party

c. ordinal

Common SQL terms include which three of the following?

a. SELECT

b. SPLIT

c. FROM

d. WHERE

a. SELECT

c. FROM

d. WHERE

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.

a. FROM

b. SELECT

c. WHERE

d. FEILD

b. SELECT

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

a. data visualization

b. data creation

c. data structuring

d. data reporting

a. data visualization

c. data structuring

d. data reporting

When multiple lists and data integrity sources are maintained, information can become_____ leading to decreased data.

a. exact

b. lost

c. inconsistent

d. centralized

c. inconsistent

When data is stored in one place it means it is _____.

a. critical

b. increasing

c. locked

d. centralized

d. centralized

Data redundancy is the _____ of data.

a. reduction

b. details

c. duplication

d. storage

c. duplication

Four types of action queries are included in many RDBMS these include ______, _____, _____, and make table.

a. append

b. delete

c. update

d. modeling

a. append

b. delete

c. update

OLAP is used to support businesses in a wide range of areas including ______. (3)

a. performance management

b. financial reporting

c. simulation model

d. software downloads

a. performance management

b. financial reporting

c. simulation model

A hybrid data mart _____ data from a data warehouse as well as other data collection systems. It incorporates a top-down approach, end-user inputs, and enterprise-level integration.

a. integrates

b. isolates

c. detracts

d. extracts

a. integrates

Database reports are useful in many ways: one way a report is used is to provide details about individual records and to create _______.

a. queries

b. tables

c. labels

d. forms

c. labels

Traditional file systems use ______, files, and documents.

a. hard drives

b. floppy disks

c. lead

d. paper

d. paper

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

a. users

b. visitors

c. pages

d. servers

a. users

b. visitors

Which three of the following are examples of data transformation?

a. copying or replicating data

b. converting a comma separated values (CSV) file into a PowerPoint file

c. standardizing names and variable across data sets

d. the deletion of database fields or records to ensure data integrity

a. copying or replicating data

c. standardizing names and variables across data sets

d. the deletion of database fields or records to ensure data integrity.

SQL, usually pronounced "sequel," is quite useful when working with large data sets. The Q in SQL stands for

a. question

b. quantum

c. quotient

d. query

d. query

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

a. personally

b. private

c. publicly

d. power

a. personally

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

a. how will the data be collected?

b. what types of data do you need to solve a specific problem?

c. how much data should be collected?

d has the data been anonymized?

a. how will the data be collected?

b. what types of data do you need to solve a specific problem?

c. how much data should be collected?

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

a. LinkedIn

b. Tableau

c. Power BI

d. PowerPoint

c. Power BI

Doing a data quality audit helps ensure the highest quality of data being used for business intelligence and other applications. The data analysis method involves quality assessment, design, transformation, and _____.

a. intelligence

b. marketing

c. monitoring

d. managing

c. monitoring

Some of the duties a database administrator performs include _____. (3)

a. security

b. tuning

c. backup

d. data mining

a. security

b. tuning

c. backup

Database Management Systems assign different access rules to protect the data and users from ____, data leaks, and the misuse of data.

a. sharing images

b. bad information

c. identity theft

d. inefficient access times

c. identity theft

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

a. queries

b. reports

c. forms

d. tables

d. tables

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

a. reduced risk of data inconsistency

b. reduced data storage costs

c. data improvement recommendations

d. financial benefits for customers

a. reduced risk of data inconsistency

b. reduced data storage costs

c. data improvement recommendations

Data mining is a means of ____ data that can help organizations find patterns and relationships within data sets.

a. inserting

b. analyzing

c. depicting

d. showing

b. analyzing

The steps in the data project life cycle, according to Harvard University's Data Science Ready Project include which three of the following?

a. sensing

b. collection

c. wrangling

d. proposal

a. sensing

b. collection

c. wrangling

One way to visualize a data ecosystem is to apply it to the data project life cycle. The Data Science Ready Project outlines five steps of the data project life cycle The final stage in this life cycle is

a. storage

b. wrangling

c. data fabric

d. analysis

a. storage

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

a. Power BI Pro

b. Power BI Explorer

c. Power BI Premium

d. Power BI Desktop

a. power bi pro

c. power bi premium

d. power bi desktop

Key skills required of data analysts include which three of the following?

a. technical writing skills

b. experience with SQL and computer code

c. in-depth understanding of sociology

d. oral communication skills

a. technical writing skills

b. experience with SQL and computer code

d. oral communication skills

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

a. Associates

b. doctorate

c. bachelors

d. high school diploma

c. bachelors

When working in Tables, users can assume which the three roles?

a. creators

b. explorers

c. builders

d. viewers

a. creators

b. explorers

d. viewers