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 table contains several rows of cellular numbers with call timestamps, call durations, called numbers, and carriers of the called number. Which of the following allows a data analyst to sort the cellular numbers based on the carriers of the called numbers and include the total call durations?

Options :

A : SELECT cellular_number, called_number_carrier, SUM(call_duration) FROM calls GROUP BY cellular_number ORDER BY called_number_carrier;

B : SELECT cellular_number, SUM(call duration) FROM calls GROUP BY call_duration ORDERBY called_number_carrier;

C : SELECT cellular_number, called_number_carrier, SUM(call_duration) FROM calls GROUP BY cellular_number, called_number_carrier ORDER BY called_number_carrier;

D : SELECT cellular_number, called_number_carrier, SUM(call_duration) FROM calls GROUP BY call_duration ORDER BY called_number_carrier;

Answer: C

Question 3

An administrator needs to design a table that will include foreign words. Which of the following is the best option for storing non-native language characters?

Options :

A : VARCHAR

B : NVARCHAR

C : CLOB

D : CHAR

Answer: B

Question 4

Which of the following best describes an assessment a data analyst would use to validate that the number of records in a dataset matches the expected results?

Options :

A : Source control

B : Unit test

C : Stress test

D : Health check

Answer: B

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

Confidently Practice Online with Free DA0-002 Exam Cram

Buying Options: