Data Analytics Essentials Course Final Exam Answers

1. Match the task and purpose to the appropriate Big Data analytics method.

2. Match the type of data analysis with the question it can answer.

3. Which statement is true concerning data analytics?

• 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.
• Descriptive analytics attempts to predict what will happen next.
• Predictive analytics uses simulation models and forecasting to suggest what could happen.

4. 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?

• presenting the results
• analyzing the data
• investigating the data
• preparing the data

5. 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?

• =(C2*(B2-D2)*E2)
• =B2*C2-D2*E2
• =B2-D2+C2*E2
• =(B2*C2)-(D2*C2)*E2

6. Which type of variable is used for qualitative values such as gender or eye color?

• ordinal
• discrete
• continuous
• nominal

7. What are three resources provided by the Kaggle web site? (Choose three.)

• API for major social media networks
• publicly available datasets
• data analysis integration with Excel
• code
• data analysis integration with Tableau
• community competitions

8. Match the variable with the description.

9. Match the ETL process with its description.

10. 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 ELT process, the load step occurs after the transform step.
• In the ETL process, the extract step occurs after the load step.
• In the ETL process, the load step occurs before the transform step.

11. 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?

• customer order history
• inventory of products
• brands of products
• streaming customer-viewing data

12. Which two tasks are performed as part of the transform step of the ETL data process? (Choose two.)

• removing the blank records
• standardizing formats such as date, time, and location
• communicating results to decision-makers
• collecting and recording the data
• transferring the data into a database

13. Match the Microsoft Excel function with its description.

14. Which option in Microsoft Excel represents a formula with an absolute reference?

• =($A1-$B1)
• =(B$1-B$3)
• =($A$1-$B$1))
• =(B$=(C$1$-F$1$)

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?

• Conditional Formatting
• Sort & Filter
• Text to Columns
• Find & Select

16. How can data analysts use the Conditional Formatting tool in Excel to aid in data analysis of bike sales records?

• to show only sales from the United States
• to highlight values in the revenue column that are above average
• to separate the contents of the product description column into separate columns
• to list sales order numbers from lowest to highest

17. A learner is analyzing a large volume of data in a Microsoft Excel spreadsheet and wishes to find duplicate data values. The data has been organized in a table where each row has different but related forms of data in each column. Which Microsoft Excel function can be used to do this?

• ISNA
• VLOOKUP
• SUM
• IF

18. 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

19. The figure contains a section of an Excel spreadsheet. Cell C2 contains the formula “=VLOOKUP(B1,$A$2:$A$10,1,FALSE)” When cell C2 is clicked “#N/A” is displayed.

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 formula is entered in the wrong cell.
• The cell range is incorrect.
• No value is entered in cell C3.
• No duplicate value for the value entered in cell B2 is found.

20. What is a statistical analysis result that a descriptive statistical analysis will not provide?

• calculation of how widely dispersed the data is
• visualization of particular data trends occurring
• calculation of the smallest or largest value
• predictions made about other data sets that are not in the population

21. Refer to the exhibit. Which option will correctly display the user names and email addresses of users in this table?

• 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
• SELECT user_id, user_name, user_email
  WHERE User

22. Drag the SQL Data Manipulation Language (DML) statements to the correct description.

23. Refer to the exhibit. A portion of the Movie table from the Movies database is shown. A data analyst is writing a query that will return the title and release date of movies released after 2000. The analyst further needs the list ordered by the release date. Which query will return the required results?

• SELECT Movie
  FROM Title, Release_date
  WHERE Release_date > ‘2000-12-31’
  ORDER BY Release-date
• SELECT Title, Release_date
  FROM Release_date > ‘2000-12-31’
  WHERE Movie
  ORDER BY Release-date
• SELECT Title, Release_date
  FROM Movie
  WHERE Release_date > ‘2000-12-31’
  ORDER BY Release-date
• SELECT Release_date > ‘2000-12-31’
  FROM Title, Release_date
  WHERE Movie
  ORDER BY Release-date

24. Match the type of database to the best description.

25. What is the purpose of the DML language commands in SQL?

• to manage updates to the database storage
• to create, modify or delete objects in the database schema
• to select, update, insert or delete records and values from a table
• to change rights and permissions to data in the database

26. What does a field refer to in database schema terminology?

• a specific attribute of an individual record
• a unique record within the database
• a collection of attributes of an individual item
• a collection data in rows and columns

27. 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.Date;
• r.Comment;
• r.Score;
• r.MovieTitle;
• r.ID;

28. Refer to the exhibit. Match the JOIN operation with the proper description.

29. Which two are benefits of organizing information from multiple datasets into a dashboard? (Choose two)

• The information is easily visualized.
• The information is easily secured.
• The information is easily analyzed.
• The information is easily tracked.

30. What Tableau Public feature is used to consolidate multiple views and visualizations?

• worksheets
• objects
• screens
• dashboards

31. Why would you use Tableau in your data analysis?

• To perform mathematical calculations using formulas and built-in functions.
• To display data in a tabular format.
• To create visualizations.
• To communicate with and query databases.

32. Match the data analysis tool with the use case.

33. Which statement is true in respect of avoiding bias in data analytics?

• don’t allow the data to confirm your conclusions
• avoid selecting only data and methods that support your assumptions
• use a small sample set that supports your hypothesis
• focus on the larger patterns and trends and include outliers in the overall analysis

34. What are two methods that ensure confidentiality? (Choose two.)

• authorization
• encryption
• availability
• nonrepudiation
• authentication
• integrity

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?

• confirmation
• selection
• interpretation
• information

36. Which type of bias in data analysis can be caused by the influence of outliers?

• interpretation
• information
• confirmation
• selection

37. Which three features should your data project portfolio contain to ensure that it is considered favorably by employers and recruiters? (Choose three.)

• it contains many multi-colored charts and graphics that show the results of the data analysis
• it uses a layout and presentation that showcases your web design and markup skills
• there are links to all your projects on the homepage
• each project has a clear outcome or conclusion
• it is organized and easy to navigate
• there are links to software, so non-technical reviewers can replicate your analysis

38. Why is the Jupyter Notebook tool useful when developing and testing data analysis software?

• program output is displayed in the standalone Jupyter Notebook application
• markdown text explains the operation of SQL queries and displays the results
• when the Python code is compiled, each step is displayed
• program execution output is displayed dynamically in real-time

39. Which data analytic tool can create interactive documents containing executable program code and markdown text?

• Excel
• Jupyter Notebooks
• Kaggle
• Tableau

40. What are the three functions of programming languages optimized for data analysis? (Choose three)

• virtualization of processing hardware
• data communications across networks
• statistical analysis
• data visualization
• data cleaning
• fast response time to user input

41. Refer to the exhibit. What is the resulting output from the formula in cell D8?

• 46
• 12
• 7.6
• 6

42. Which Microsoft Excel formula would correctly multiply a value in cell A1 with a value in cell A19?

• =A1*A19
• =A1xA19
• =MULTIPLY(A1:A19)
• =xA1:A19

43. What are two plain-text file types that are compatible with numerous applications and use a standard method of representing data records? (Choose two.)

• JSON
• DOC
• PDF
• XLS
• XML

44. 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 value or data point that varies significantly from others in the data set
• it is a point in descriptive data that is historical

45. What is referenced by the FROM statement in an SQL query?

• the table containing the data
• the row where the data is located
• the database to be queried
• the column where the data is located

46. ou 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?

• bar chart
• bubble map
• heat map
• area graph

47. What assurance does data integrity provide?

• Data is recoverable.
• Data is unaltered in transit.
• Data access is restricted.
• Data is available when requested.

48. 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 is both an interpreted and object-oriented language.
• It is free and open source.
• It uses dynamic data typing.

49. What are two types of continuous variables? (Choose two.)

• discrete
• nominal
• ordinal
• ratio
• interval

50. What is a pivot table in Microsoft Excel?

• a table containing data that is organized vertically
• a table containing data that is organized horizontally
• a function to investigate formula errors and correct them
• a function to automatically summarize, analyze, explore, and present data

51. Which action is taken during the data investigation step of the data analysis lifecycle?

• Transform the data into a format appropriate for the analysis methods and tools.
• Determine if there is enough data to complete the analysis.
• Identify patterns, relationships, and correlations in the data.
• Determine if the data is complete and relevant for the analysis.