Online Access Free DA0-001 Exam Questions

A data analyst has been asked to merge the tables below, first performing an INNER JOIN and then a LEFT JOIN:

Customer Table -
In-store Transactions -

Which of the following describes the number of rows of data that can be expected after performing both joins in the order stated, considering the customer table as the main table?

• A.INNER: 9 rows; LEFT: 15 rows
• B.INNER: 6 rows; LEFT: 9 rows
• C.INNER: 9 rows; LEFT: 6 rows
• D.INNER: 15 rows; LEFT: 9 rows

Given the following tables:

Which of the following will be the dimensions from a FULL JOIN of the tables above?

• A.Four rows and two columns
• B.Four rows and four columns
• C.Three rows and four columns
• D.Two rows and three columns

A gambler thinks that a coin is fair and is equally likely to turn up heads or tails when the coin is flipped.
Which of the following tests should the gambler use to fest this hypothesis?

• A.Ratio test
• B.Chi-squared test
• C.Rank sum test
• D.t-test

Which of the following would be used to store unstructured data from different sources?

• A.A database
• B.A data warehouse
• C.A data lake
• D.A database management system

A data analyst was asked to create a chart that shows the relationship between study hours and exam scores for each student using the data sets in the table below:

Which of the following charts would BEST represent the relationship between the variables?

• A.A histogram
• B.A scatter plot
• C.A heat map
• D.A bar chart