Online Course on Data Analytics Essentials with Certificate

Organizer: Cisco, Networking Academy.

This assessment covers the core concepts and skills presented in the Data Analytics Essentials Course on Data Analytics Essentials Certificate

About the Course

• Free Course
• Duration: 30 Hours
• Level: Beginner
• Lab: 29 Labs
• Delivery Type: Self-paced
• Skills You Will Learn: Tableau, Data Visualization, SQL, Dashboard, Data Storytelling, Excel, Data Analysis
• Course Free
• Achievements: Badges & Certificates you can earn in this course.
• There are 40 questions in total.
• You must achieve 70% to pass this exam. You have unlimited attempts to pass the exam.
• Feedback is provided to direct you to areas that may require additional attention.

Apply Link

100% Correct Answers Course on Data Analytics Essentials Certificate

Question 1. A data analyst uses Excel and Tableau to identify patterns and correlations in a dataset to draw conclusions. Which phase of the analytic process is the analyst currently working on?
preparing the data
analyzing the data*
presenting the results
investigating the data

Question 2. Match the type of data analysis with the question it can answer.
Categories:
Predictive- What might happen in the future?
Prescriptive- What should be done next?
Diagnostic- Why did something happen?
Descriptive- What happened?

Question 3. Which statement is true concerning data analytics?
Descriptive analytics attempts to predict what will happen next.
Predictive analytics uses simulation models and forecasting to suggest what could happen.*
Descriptive analytics uses a feedback system to track the outcome of actions taken.
Prescriptive analytics uses historical data to provide regular reports on events that have already happened.

Question 4. Match the task and purpose to the appropriate Big Data analytics method.
Categories:
analyzing customer subscription cancellations and correlating them with customer comments and ratings to determine the most common reasons why users cancel subscriptions- diagnostic analysis
analyzing customer ordering history to find popular products within last 6 months- descriptive analytics*
analyzing historical data of temperature to prepare latest weather forecast- predictive analytics
reviewing sales data of top 5 competitors to determine the marketing strategy of own product for next quarter- prescriptive analytics

Question 5. Which type of variable is used for qualitative values such as gender or eye color?
discrete
nominal*
ordinal
continuous

Question 6. What are three resources provided by the Kaggle web site? (Choose three.)
community competitions*
publicly available datasets*
code*
data analysis integration with Tableau
API for major social media networks
data analysis integration with Excel

Question 7. The image is a snapshot on a Microsoft Excel spreadsheet that has two rows populated. Row A1 has the headers ITEM, COST,QUANTITY SOLD, SHIPPING COST (per unit), PROFIT MARGIN and NET REVENUE (these are the headers for columns A-F respectively.) Row A2 is populated with the values 805,285,60 and 0.081 (for columns A1-E1 respectively.)
Refer to the exhibit. A data analyst wants to create a formula in Microsoft Excel that will automatically calculate the net revenue from the sales of dining sets. Which formula inserted in cell F2 will accomplish this?
=(B2C2)-(D2C2)E2 =B2-D2+C2E2
=(C2(B2-D2)E2)*
=B2C2-D2E2

Question 8. Which Microsoft Excel formula would correctly multiply a value in cell A1 with a value in cell A19?
=A1A19
=xA1:A19
=A1xA19
=MULTIPLY(A1:A19)

Question 9. An analyst in an online order company is researching products that online customers spend the most time browsing for on the website but do not buy. The result of the analysis will enable the company to release quick discount notices on the website to encourage customers to buy those products. What relevant data is required to do the research?
brands of products
inventory of products
customer order history
streaming customer-viewing data*

Question 10. What are two plain-text file types that are compatible with numerous applications and use a standard method of representing data records? (Choose two.)
XML*
JSON*
XLS
PDF
DOC

Question 11. Match the ETL process with its description.
Categories:
transform- is the process of conditioning data into a usable form, such as removing duplicate data, providing missing data, and correcting any errors in the data.
load- is the process of transferring data to a database
extract– is the process of gathering the data to be analyzed

Question 12. Which statement is true about the ELT and ETL process?
In the ELT process, the transform step occurs on the stored data as it is used.*
In the ETL process, the extract step occurs after the load step.
In the ETL process, the load step occurs before the transform step.
In the ELT process, the load step occurs after the transform step.

Question 13. Match the Microsoft Excel function with its description.
Categories:
LEN- it is used to return the number of characters in a cell
COUNTA- it is used to return the number of blank or non-blank cells in a range
CONCATENATE- it is used to combine the data from one or more columns into a single column
SUMIF- it is used to create a sum of values based on multiple criteria
INDEX- hin a table or rangeit is used to return a value or the reference to a value from wit
UPPER- it is used to convert text to all capital letters (UPPERCASE)

Question 14. Which option in Microsoft Excel represents a formula with an absolute reference?
=($A1-$B1)
=(B$1-B$3)
=(B$=(C$1$-F$1$)
=($A$1-$B$1))*

Question 15. A data analyst needs to organize sales data for analysis. Which Excel function can order the data by date sold, with the most recent sales listed first?
Sort & Filter*
Conditional Formatting
Text to Columns
Find & Select

Question 16. What is a pivot table in Microsoft Excel?
a table containing data that is organized horizontally
a function to investigate formula errors and correct them
a table containing data that is organized vertically
a function to automatically summarize, analyze, explore, and present data*

Question 17. A data analyst wants to compare the average life expectancy and GDP for forty countries. Which type of visual representation would best suit this task?
pie chart
scatter plots*
bar chart
line graph

Question 18. What is a statistical analysis result that a descriptive statistical analysis will not provide?
visualization of particular data trends occurring
predictions made about other data sets that are not in the population*
calculation of the smallest or largest value
calculation of how widely dispersed the data is

Question 19. What is an outlier in data analytics?
it is a pointer to the sample data set
it is a point in inferential data that is numeric
it is a point in descriptive data that is historical
it is a value or data point that varies significantly from others in the data set*

Question 20. Refer to the exhibit. A learner is analyzing a data spreadsheet in Microsoft Excel and notices a formula function “=VLOOKUP(B1,$A$2:$A$10,1,FALSE)”. When clicking on cell C2, the value displayed in the field in cell C2 is “#N/A”. Why is this value displayed?
The cell range is incorrect.
The formula is entered in the wrong cell.
No duplicate value for the value entered in cell B2 is found.*
No value is entered in cell C3.

Question 21. What is referenced by the FROM statement in an SQL query?
the row where the data is located
the column where the data is located
the database to be queried
the table containing the data*

Question 22. Drag the SQL Data Manipulation Language (DML) statements to the correct description.
Categories:
ORDER BY- used to structure the resulting query in ascending (ASC) order by default
WHERE- is a conditional statement used to filter your returned results
FROM- returns the selection from the table name specified
SELECT- returns the fields specified

Question 23. The exhibit displays a table labeled User with the following fields: user_id, content_id, user_name, user_email, and user_dob.
Refer to the exhibit. Which option will correctly display the user names and email addresses of users in this table?
SELECT user_id, user_name, user_email
WHERE User
SELECT User
WHERE user_id, user_name, user_email
SELECT User
FROM user_id, user_name, user_email
SELECT user_id, user_name, user_email
FROM User*

Question 24. Match the type of database to the best description.
Categories:
relational database- it requires a SQL to store, manipulate, and retrieve data
spreadsheet- it stores data in a sheet using a tabular format of columns, rows, and cells
flat file database- it stores records in a single file with no hierarchical structure

Question 25. Refer to the exhibit. A data analyst writes a SQL query to extract information from multiple tables in the Movies database. To complete the ON command, what needs to be entered in place of the question mark in this query?
SELECT m.Title, m.Date, r.AuthorName, r.Score, r.Comment, r.Date
FROM Review AS r
JOIN Movie AS m
ON m.Title = ?;
r.Score;
r.Date;
r.ID;
r.Comment;
r.MovieTitle;*

Question 26. The exhibit displays a Venn diagram consisting of a left circle labelled Table 1 and a right circle labelled Table 2. These two circles are side-by-side but overlapping by 25%.
Refer to the exhibit. Match the JOIN operation with the proper description.
Categories:
LEFT JOIN- Returns all records from Table 1 and only the matched records from Table 2.
FULL JOIN– Returns all records from Table 1 and Table 2.
RIGHT JOIN- Returns all records from Table 2 and the matched records from Table
INNER JOIN- Returns only records where the selected fields have matching values in Table 1 and Table 2.D

Question 27. What is the purpose of the DML language commands in SQL?
to create, modify or delete objects in the database schema
to change rights and permissions to data in the database
to select, update, insert or delete records and values from a table*
to manage updates to the database storage

Question 28. What does a field refer to in database schema terminology?
a collection data in rows and columns
a collection of attributes of an individual item
a specific attribute of an individual record*
a unique record within the database

Question 29. Which two are benefits of organizing information from multiple datasets into a dashboard? (Choose two)
The information is easily tracked.
The information is easily secured.
The information is easily analyzed.*
The information is easily visualized.*

Question 30. You are preparing a presentation that needs a visualization showing the relative levels of coffee production in the coffee regions of the world. Which type of visualization in Tableau is well suited for displaying this type of data?
bubble map*
bar chart
heat map
area graph

Question 31. Match the data analysis tool with the use case.
Categories:
Excel- generating computational solutions using formulas and built-in functions
SQL- managing and querying relational databases
Tableau- creating meaningful data visualizations and interactive dashboards
Kaggle- competing in data science competitions

Question 32. Why would you use Tableau in your data analysis?
To communicate with and query databases.
To create visualizations.*
To display data in a tabular format.
To perform mathematical calculations using formulas and built-in functions.

Question 33. Which statement is true in respect of avoiding bias in data analytics?
use a small sample set that supports your hypothesis
avoid selecting only data and methods that support your assumptions*
focus on the larger patterns and trends and include outliers in the overall analysis
don’t allow the data to confirm your conclusions

Question 34. Which type of bias in data analysis can be caused by the influence of outliers?
interpretation
information*
selection
confirmation

Question 35. A data analyst conducting a study stops collecting more data once the evidence starts to support the hypothesis. What type of bias has the analyst introduced into the findings?
selection
information
interpretation
confirmation*

Question 36. What are two methods that ensure confidentiality? (Choose two.)
availability
authorization
integrity
nonrepudiation
encryption*
authentication*

Question 37. Why is the Jupyter Notebook tool useful when developing and testing data analysis software?
when the Python code is compiled, each step is displayed
markdown text explains the operation of SQL queries and displays the results
program output is displayed in the standalone Jupyter Notebook application
program execution output is displayed dynamically in real-time*

Question 38. Which feature of Python reduces the coding requirements when data tasks such as exploratory data analysis and machine learning are required?
The availability of code libraries such as NumPy and Scikit-learn.*
Python code based on common English words.
It uses dynamic data typing.
It is both an interpreted and object-oriented language.
It is free and open source.

Question 39. What are the three functions of programming languages optimized for data analysis? (Choose three)
statistical analysis*
data visualization*
fast response time to user input
data communications across networks
data cleaning*
virtualization of processing hardware

Question 40. Which data analytic tool can create interactive documents containing executable program code and markdown text?
Jupyter Notebooks*
Kaggle
Tableau
Excel