Question 1

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

Question 2

The following SQL code returns an error in the program console: SELECT firstName, lastName, SUM(income) FROM companyRoster SORT BY lastName, income Which of the following changes allows this SQL code to run?

Options :

A : SELECT firstName, lastName, SUM(income) FROM companyRoster HAVING SUM(income) 10000000

B : SELECT firstName, lastName, SUM(income) FROM companyRoster GROUP BY firstName, lastName

C : SELECT firstName, lastName, SUM(income) FROM companyRoster ORDER BY firstName, income

D : SELECT firstName, lastName, SUM(income) FROM companyRoster

Answer: B

Question 3

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 4

A data analyst needs to create and deliver a dashboard that displays the company's financial transactions as they are updated. Which of the following delivery methods should the analyst consider? (Select two).

Options :

A : Real-time

B : Snapshot

C : Dynamic

D : Static

E : Ad hoc

F : Time series

Answer: A,C

Question 5

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

Higher Test Marks with Free Online DA0-002 Exam Practice

Buying Options: