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 manager wants a report that contains the days off for each direct report. The manager needs this report to always be up-to-date with the latest dat a. Which of the following describes the refresh frequency that the manager is requesting?

Options :

A : Real-time

B : Ad hoc

C : Snapshot

D : Dynamic

Answer: A

Question 3

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 4

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 5

Which of the following best describes the semi-structured data that is gathered when web scraping?

Options :

A : JSON

B : CSV

C : CSS

D : HTML

Answer: A