Question 1

Which of the following tables holds relational keys and numeric values?

Options :

A : Fact

B : Graph

C : Dimensional

D : Transactional

Answer: A

Question 2

A data analyst is joining two tables with different content and one common field. Which of the following should the analyst do to most efficiently meet this requirement?

Options :

A : Match the records of the related columns and merge the tables.

B : Create a cluster to facilitate data integration between the tables.

C : Explode both tables to identify unique values and reorder the fields in one table.

D : Append the values of the matching columns and concatenate the other data fields.

Answer: A

Question 3

A company gives users adequate data access permissions to allow them to fulfill their duties but nothing more. Which of the following concepts best describes this practice?

Options :

A : Active Directory

B : Hierarchical access

C : Zero Trust

D : Least privilege

Answer: D

Question 4

A data analyst is designing a report for the business review team. The team lists the following requirements for the report: Specific data points Color branding Labels and terminology Suggested charts and tables Which of the following components is missing from the requirements?

Options :

A : Source validation

B : Design elements

C : Delivery method

D : Report type

Answer: C

Question 5

An analyst needs to create a collection of dashboards for multiple teams within their organization. Which of the following should the analyst do first before starting the project?

Options :

A : Evaluate the user persona type for the dashboards.

B : Determine the number of team members who need to access the dashboards.

C : Determine the delivery method of the dashboards.

D : Evaluate the KPIs for the dashboards.

Answer: A