Databases and Data Analytics-Questions
and Answers
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
and Answers
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
