Ø Which role needs the most technical and working experience?
-> data scientist
(Benar)
Data scientists typically
have lots of real-world working experience. They are fluent in coding, math,
and statistics, as well as all other required data roles, like data
engineering, data cleaning, and reporting outcomes.
-> data engineer
-> data analyst
Ø What is a form of data cleaning and transformation?
-> building VLOOKUP or
XLOOKUP functions to bring in data from other worksheets
-> building pivot
tables, crosstabs, charts, or graphs
-> deleting columns or
adding calculations to an Excel spreadsheet (Benar)
Ø Which choice is not a valid data type?
-> Number
-> Start date (Benar)
Start date is a field name
and is likely a date and time data type.
-> Boolean
-> Text or String
Ø When data analysts consider all the data from any object, this is an
example of them turning on their _____.
-> join lens
-> spreadsheet lens
-> query goggles
-> data lens (Benar)
The data lens is something
that a data analyst will improve over time. The more exposure to data you have,
the more likely you are to think of data points when they are not exactly in
front of you on a table or spreadsheet.
Ø When starting a new data project, what is one of the best sources to
help you begin?
-> existing reports
(Benar)
Learning about what is
currently being reported will help you understand the organization. Using
existing reports, you can often reverse engineer the data to begin your own
projects.
-> the database
-> technical
documentation
-> queries
Ø What does a cross join or no join accomplish?
-> It shows only equal
records or matching records on both tables.
-> It shows no records.
-> It associates every
record to every record in both tables. (Benar)
When multiple tables are
brought into a query, they must have a common field that links them together
through a join. When this join line is missing, it will tie every record from
one table to every record in another table.
-> It shows every
record from the left table.
Ø You want to join records in tables that match with fields in other
tables. To do this, which join will you use?
-> a right outer join
-> an inner join
(Benar)
-> a left outer join
-> a cross join
Ø Which items are examples of data cleaning?
A. removing unnecessary
columns
B. changing the case of
data (upper, lower, etc.)
C. connecting to the data
in a database
D. removing unnecessary
spaces from data
-> B, C, D
-> A, B, C, D
-> A, B, D (Benar)
Removing columns, spaces,
and changing case of data are all examples of data cleaning.
-> A, C, D
Ø Maintaining your original data set provides you with which
option(s)? A. the benefit of not starting entirely back over after a mistake
B. an audit trail
C. a better understanding
of your data
D. none of these answers
-> A, B (Benar)
Keeping a copy of the
original data provides you the ability to just quickly start back over after a
mistake. It will also give you the ability to return to the original data for
auditing the work.
-> D
-> C
Ø When you are learning a new database, when should you look at a
sample of the data?
-> after you look at
the queries
-> after you look at
the table names (Benar)
-> after you look at
the relationships
Ø Reviewing table design is important for a data analyst. What is
something you will discover in the design of tables?
-> workflow
-> data types (Benar)
-> queries
-> record counts
Ø Knowing the statistical significance of any data point or set is an
example of the _____ truth.
-> data
-> stats (Benar)
-> business
Ø Which items are best practices for being effective in a meeting?
A. Dive right into the
data and information when it's your turn.
B. Ask to be on the agenda
and state how much time you need.
C. Provide a list of key
definitions and consider a slide deck.
-> A, B, C
-> B, C (Benar)
As a data analyst, it is
important that you have time to cover the information you need answers for your
questions. Providing a key list of definitions up front is important to reduce
time spent answering questions that you can answer with a simple document.
Including a slide deck will help you stay focused and on point.
-> A
Ø In data, numbers are _____ aligned by default.
-> justified
-> left
-> right (Benar)
Numbers are typically best
read when they are right aligned by their last value. In data, it's also an
indicator that the program sees values as numbers because it will default to
right aligned.
-> center
Ø One of the key ways to validate your queries is by knowing how many
_____ you have in each data set.
-> calculations
-> fields
-> records (Benar)
It is beyond important to
know how many records are in the tables you are working with. This is one of
the simplest ways to validate your joins.
-> data types
Ø Which truth is a measure of an organization's production?
-> the stats truth
-> the data truth
-> the business truth
(Benar)
Ø You should _____ the headers on a new sheet tab to provide valuable
information with your data.
-> cut and paste
-> manually type
-> copy and transpose
(Benar)
Transpose allows you to
flip data from horizontal to vertical, which can be helpful when documenting
information about fields and while providing data sets to others.
Ø A file that is not connected to a live data set, and that you
receive through either email or an export, is an example of a(n) _____.
-> query
-> flat file (Benar)
Flat files are data sets
that are not directly connected to the data source. They are typically are
exports to .csv or Excel files that you run yourself or have been emailed to
you.
-> Excel file
Excel files can sometimes
be connected to data sources with live connections of data.
Ø Data governance involves _____.
-> the IT department
only
-> data regulations
-> people, technology,
and processes (Benar)
The best data governance
will include not only people, but technology and processes to ensure that data
is the highest quality, secured and meeting requirements.
Ø Changes we make to our data in Power Query are recorded in _____.
-> Applied Steps
(Benar)
When making changes to the
data in Power Query, it automatically tracks each step in the Applied steps.
-> VBA
-> Macros
Ø You need a report for every day that occurred in a period of time.
To determine if you had transactions on those days, which join would you use
between your transactions table and date table?
-> outer join (Benar)
In order to pull every
date from a range of dates you will tie your transactions table to a date table
through an outer join.
-> cross join
-> inner join
Ø Which option is not a reusable data set?
-> postal code data
-> date table
-> order transactions
(Benar)
Order transactions will
change and be an overall part of the data we report and visualize. However, it
is not what we consider reusable, like a date table or postal code data.
Ø _____ code is written by recording macros in Microsoft Office.
-> C++
-> VB (Visual Basic)
-> JavaScript
-> VBA (Visual Basic
for Applications) (Benar)
VBA is the code language
that runs Microsoft Office products. When you create a macro, it is coding in
the VBA.
Ø In Power Query, merge queries allow us to _____.
-> clean leading zeros
-> join data together
(Benar)
Merge queries are the
database equivalent to writing a select query.
-> change data types
-> compile equal data
sets
Append queries are used to
compile like data sets.
Ø What command do you use to create aggregated data sets in Power
Query?
-> Reference Data Set
Reference Data Set is the
ability to duplicate a data set and maintain a cleaning reference to the
original data set. It may be used in the process but it is not the function
that creates the aggregated data.
-> Group By (Benar)
Group By will allow you to
group data and add aggregate functions like SUM, COUNT and AVERAGE.
-> Append Queries
-> Merge Queries
Merge Queries are used to
join data. They do not create aggregated data sets.
Ø There are many reasons to change case of any data. Using Proper()
changes case to proper in Excel. What is the equivalent command in Power Query?
-> Transform >
Capitalize each word (Benar)
Transform > Capitalize
each word is the same outcome as using the Proper() function in Excel.
-> Transform >
UPPERCASE
-> Transform >
Change Case > UPPERCASE
There is not a Change Case
step between Transform and any case change command. UPPERCASE capitalizes every
letter, not just the first.
Ø It's not always obvious when looking at large data sets that data is
duplicated. Which command in Excel lets you easily highlight duplicate values?
-> Remove Duplicates
Remove Duplicates will
actually remove the data from the data set. It does not highlight the duplicated
data.
-> Sort
-> Conditional
Formatting (Benar)
Excel Conditional
Formatting has a highlight option that will immediately apply formatting that
shows duplicated data.
Ø What is not an example of a logical function?
-> CountIF
-> Average (Benar)
Average is not considered
a logical function, but an aggregate function.
-> IFS
-> SUMIF
Ø Merge Columns replaces what function in Excel?
-> VLOOKUP
-> Match()
-> Concat() or
Concatenate() (Benar)
Concat() and Concatenate()
both combine values in Excel, and the outcome of Merge Columns is the same as
both of these commands in Excel.
-> SUMIF()
