Big Data Practitioner Certification B9 – MPRO

Welcome to your Big Data Practitioner Certification B9 - MPRO

Name

Email

DOB

1. What is the comparison operator for ‘less than’?

A. =

B. >

C. <

D. <=

2. The correlation study of two variables simultaneously is referred to as?

A. Cross Data Tabulation

B. Absolute Data

C. Relative Data

D. Bivariate Data

3. What is the comparison operator for ‘less than or equal to’?

A. <

B. >=

C. <=

D. >

4. Which of the following functions returns the total of cells in a range that match some criteria?

A. COUNTIF

B. AVERAGEIF

C. MAXIF

D. SUMIF

5. Which function is best to use to combine strings with delimiters?

A. CONCAT

B. TEXTJOIN

C. CONCATENATE

D. COLJOIN

1 out of 8

6. Which of the following is not a measure of dispersion?

A. Variance

B. Mean

C. Standard deviation

D. Range

7. Which of the following is an example of Uniform Distribution?

A. Continuous Uniform Distribution

B. Range Distribution

C. Classified Distribution

D. Outlier

8. Which of the following is not a measure of central tendency?

A. Variance

B. Mean

C. Mode

D. Median

9. Which term refers to the most common observation in the distribution?

A. Median

B. Mean

C. Mode

D. Variance

10. What function is used to generate random numbers between two values?

A. RANDBETWEEN

B. RAND

C. RANDOM

D. UNIFORM

2 out of 8

11. Which of the following is NOT a pattern of Correlation for Big Data Analytics?

A. Nominal Correlation

B. Positive Correlation

C. Spurious Correlation

D. Zero Correlation

12. Which of the following measures are used to evaluate the strength of a relationship between quantitative variables?

A. Mode

B. Variance

C. Mean

D. Correlation

13. What type of variables do not take on numerical values?

A. STRING

B. CURRENCY

C. DECIMAL

D. LONG

14. Can you calculate a correlation if there is only one sample of data?

A. Yes

B. No

15. Which of these tools are not used to explore relationships between two categorical variables?

A. Cross-tabulation tables

B. Conditional percentage tables

C. Scatterplot

D. Clustered column bars

3 out of 8

16. We want to look up for an exact match of Salesperson based on Customer Name. which of these lookup tables can you use VLOOKUP on?

A

Customer Name	Salesperson
Santa	Prem
Xun	Darren
Wei	Akmal
Claus	Narjes

B

Salesperson	Customer Name
Prem	Santa
Darren	Xun
Akmal	Wei
Narjes	Claus

C

Customer Name	Santa	Xun	Wei	Claus
Salesperson	Prem	Darren	Akmal	Narjes

D

Salesperson	Prem	Darren	Akmal	Narjes
Customer Name	Santa	Xun	Wei	Claus

A. A

B. B

C. C

D. D

E. I don’t know this

17. In the context of Data Storytelling, what is a call-to-action?

A. It is a catchy header that grabs attention and sticks in the mind

B. It is a calculable formula that defines the amount of call to the amount of action in a visual

C. It is a statement that tells the audience what you need them to do or perform having viewed the visual

D. It is a 20 seconds summary of findings from a given piece of analysis

E. I don’t know this

18. Good Data Storytelling is comprised of two main elements. What are the two main elements?

A. Visual & Synopsis

B. Story & Synopsis

C. Voice & Story

D. Visual & Story

E. I don’t know this

19. Which of the following visuals can be used to visualize proportions-to-whole?

Tree Map
Pie Chart
100% Stacked Bar Chart
Donut Chart

A. 1 and 3 only

B. 2 and 3 only

C. 2 only

D. All of the above

E. I don’t know this

20. When designing good visuals, we like to consider the overall visual hierarchy. What does it mean?

A. The visual design of an organizational hierarchy chart

B. The order in which the audience will process the visual as determined by the importance of each bit of information

C. The visual display of hierarchical clustering on a dendrogram

D. The hierarchy of needs with respect to visual design

E. I don’t know this

4 out of 8

21. Scatter plots are used extensively by the scientific community. Why might we use scatter plots?

A. To visualize the relationship between two variables

B. To illustrate the magnitude of one variable over time

C. To show proportion-to-whole of subcomponents

D. To provide easy comparison for a ‘before’ and ‘after’

E. I don’t know this

22. What is a concern when using a line graph to visualize categorical data?

A. A line implies that categorical data is continuous

B. Values at any point in the line are not obvious

C. The forecasts we make with line charts are not great

D. Categorical variables must be processed before they can be used for visualization

E. I don’t know this

23. Which of the following are reasons for the pie chart being an ineffective method of conveying information? Select all that apply.

The human eye cannot perceive 2D-Area and angles very well thus making it difficult to compare the value associated with each slice
Pie Charts are round, and humans prefer rectangular shape
When there are too many slices (categories) the pie chart becomes difficult to read
People are used to using pie charts and are bored of seeing them in presentations

A. 1 and 2

B. 1 and 3

C. 2 and 3

D. All of the above

24. Hybrid titles are multi-functioning titles that play a variety of roles on a visual. Which of the following is included in a Hybrid Title provide?

I. Color Legend for Visual
II. Insightful Information
III. Context of the visual

A. II and III

B. I, II and III

C. I and III

D. III only

E. I don’t know this

25. Which of the following statements are true?

I. Categorical variables should be arranged alphabetically if there is no other logical way of arranging them

II. Categorical variables must be illustrated through the use of a line chart

III. Comparison between different categorical variables can be better displayed through the use of a bar chart as opposed to a pie chart

IV. When attempting to visualize proportion-to-whole of categorical variables, it is generally preferred to use a Tree Map over a Pie Chart

A. I only

B. II and III only

C. I, II and III

D. I, III and IV

E. I don’t know this

5 out of 8

26. When crafting a data story, it is important to think about the sequence in which we will present individual story points to the audience. One such sequence is to ‘Toe to Head’ approach; that is to start the story with the ending or conclusion. What is an advantage to using such an approach?

A. The audience will trust you better and not question your findings

B. The audience knows what to look out for throughout the rest of the presentation

C. The audience naturally thinks from the ending to the beginning - thus helping them understand the story

D. None of the above

27. If the chart in Tableau is displaying a FIELD MAP, which of the following is placed in the ROWS?

A. Latitude

B. Longitude

C. Country

D. Postal Code

28. =CONCATENATE(B1,” “,C1) - What is the purpose of having this quotation symbol in a Concatenate function?

A. To introduce a space bar between two texts

B. To count the number of alphabets between two texts

C. To separate the alphabets individually in each cell

29. What is the use for the function SUMIFS?

A. To calculate the total sum of a cell

B. To calculate the total sum of values with 2 or more ranges

C. To count the total number of values within a cell

D. To show the sum of the ROWS only

30. If you need to align all of the charts/visuals in Microsoft Excel, which of the following option will you use?

A. Regression Analysis

B. Tabulate Data Connection

C. View Data as whole

D. Report Connection

6 out of 8

31. What is a tooltip?

A. An elegant way of providing more contextual information and detail to data points on a visual.

B. To show the options that are available in Power Bi

C. Sort data and information based on some selected criteria

32. What does the FILTERS field in Tableau represent?

A. Factorizes the Measure or Dimension from a data set

B. Allows you to filter Measure or Dimension from a data set

C. Multiplies the Measure or Dimension from a data set

D. Eliminates empty spaces within the data set

33. The image below shows the image of an advanced visualization. What chart is this?

A. Tree Map

B. Bar Graph

C. Bubble Chart

D. Card

34.

What are the required fields for scatter plot?

I. X-axis
II. Y-axis
III. Z-axis

A. I only

B. I and II only

C. I, II and III

D. I, III and IV

35.

The above diagram shows an advanced visualization. What it is called?

A. Scatter Plot

B. Tree Map

C. Bar Chart

D. Box chart

7 out of 8

36. What is the formula used in Microsoft Excel to extract STRINGS from the left of a CELL?

A. =FIND

B. =LEFT

37. What is the formula used to include working days and non-working days per annum?

A. =EDATE

B. =NETWORKDAYS

C. =TEXT(MMMM)

38.

What is this map above called?

A. Map

B. Field Map

39. What is a Tableau report?

A. An application for clean data

B. A canvas

C. Key-influencers

D. Visuals that represent different findings and insights visually from that dataset

40.

Which of this statements are true about Stacked Column Chart?
I. A stacked column chart is to allow part-to-whole comparisons over time, or across categories.
II. In a stacked column chart, data series are stacked one on top of the other in vertical columns.
III. Stacked column charts can show change over time because it's easy to compare total column lengths
IV. Stacked column charts are good for showing one or two measure’s value across an axis which can be a category or time period.

A. I and II

B. I and IV

C. I, II, and III

D. All of the above

8 out of 8