Exam (elaborations)
D467 EXPLORING DATA (Computer Graphics) EXAM QUESTIONS AND ANSWERS WESTERN GOVERNORS’ UNIVERSITY
- Course
- Institution
D467 EXPLORING DATA (Computer Graphics) EXAM QUESTIONS AND ANSWERS WESTERN GOVERNORS’ UNIVERSITY
[Show more]
Content preview
D467 EXPLORING DATA (Computer Graphics)EXAM QUESTIONS AND ANSWERS WESTERN
GOVERNORS’ UNIVERSITY
An analyst wants to present a high-level summarized version of the data at
the end of data cleansing. Which spreadsheet functionality should the
analyst use?
Conditional formatting
Pivot table
Find and replace
Filters
✔✔Pivot table
What is the definition of verification in the data cleaning process?
A process of ensuring the degree to which a set of measures is equivalent
across systems
A process of chronologically listing the modifications made to a set of data
files during the data cleansing process
A process to confirm how accurate and reliable a data set is following data
cleaning
A process to report on the results of data cleansing efforts to help build
trust in the data and cleansing
✔✔A process to confirm how accurate and reliable a data set is following
data cleaning
,What is an outcome of the verification step of data cleansing?
Compares dirty data with clean data
Ensures the data collected and cleansed will address the original purpose
Chronologically documents how the data set evolved during the project
Helps build trust in the cleansing process and data
✔✔Ensures the data collected and cleansed will address the original
purpose
An analyst used a column of a table to uniquely identify each record within
a table. Which tool did they use?
Normalization
Field
Foreign key
Primary key
✔✔Primary key
Which tool is used by data analysts to store and organize data, making it
easier for them to manage and access information?
Primary key
Table
Database
,Foreign key
✔✔Database
Which element of a Notepad file would be considered data as opposed to
underlying metadata?
File contents
File description
FIle date
File size
✔✔File contents
What is an example of administrative metadata for a digital file?
File size
File name
File contents
File permission
✔✔File permission
What is an acceptable syntax for the SELECT keyword in MySQL?
"select"
select
, SELECT_Keyword
'select'
✔✔select
An expert in query languages searched for month_name = DEC using
Vertica. The data set contains variations of the word December, such as
dec, Dec, etc. What will the output of this search query be?
It will return all entries that match DEC only.
It will return all entries that match dec only.
It will return all entries such as dec, Dec, DEC.
It will return all entries that match Dec only.
✔✔It will return all entries that match DEC only.
What is the general rule regarding the suggested length of each line in a
query to maintain indentation best practices?
Less than or equal to 50 characters
Greater than or equal to 100 characters
Less than or equal to 100 characters
Greater than or equal to 50 characters
✔✔Less than or equal to 100 characters
What is a feature of the filtering process when applied to spreadsheets?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller saraciousstuvia. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $17.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now