Q43. What test formatting option indicates that a field is required in an entity relationship diagram?

Q44. Which of the following is most likely to be used as a data-mining ETL tool?

Q45. What term is used to describe an interactive visualization that encourages people to explore data dynamically?

Q46. An analyst reviews the following data:
7
3
5
2
3
7
7
10
Which of the following is the value of the mode?

Q47. Mario works with a group of R programmers tasked with copying data from an accounting system into a data warehouse.
In what phase are the group’s R skills most relevant?

Q48. A publishing group has requested a dashboard to track submissions before publication. A key requirement is that all changes are tracked, as multiple users will be checking out documents and editing them before submissions are considered final. Which of the following is the BEST way to meet this stakeholder requirement?

Q49. Which of the following is a KPI metric for tracking sales performance?

Q50. A customer’s telephone number is in the format 123-456-7890. Which of the following data types is used for the phone number?

Q51. Refer to the exhibit.
A data analyst needs to calculate the mean for Q1 sales using the data set below:

Which of the following is the mean?

Q52. An analyst has written the following code:
SELECT *
FROM Cust_table
WHERE age > 60 AND City = “New York”
Which of the following criteria is the analyst retrieving?

Q53. A junior web developer is developing a new application where users can upload short videos. The first task is to create a homepage that shows the headline “Upload Your Short Videos” and a clickable button that says “upload now”.
Which of the following HTML commands would help the developer to complete the task successfully?

Q54. A data analyst has been asked to create an ad-hoc sales report for the Chief Executive Officer (CEO).
Which of the following should be included in the report?

Q55. An analyst is preparing a report that contains weather data. The temperatures are shown in Fahrenheit. but they must be reported in Celsius. Which of the following should the analyst do to fix this issue?

Q56. A data analyst for a media company needs to determine the most popular movie genre. Given the table below:

Which of the following must be done to the Genre column before this task can be completed?

Q57. You have two databases tables that you would like to join together using a foreign key relationship.
What term best describes this action?

Q58. Which of the following is a characteristic of a relational database?