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).

• A.Ad hoc
• B.Static
• C.Snapshot
• D.Time series
• E.Real-time
• F.Dynamic

Comment: *

Name: *

Email: *

Verification: *

Which of the following file types separates data using a delimiter?

• A.XML
• B.HTML
• C.JSON
• D.CSV

Comment: *

Name: *

Email: *

Verification: *

Which of the following best describes a characteristic of a Boolean?

• A.Must be a character
• B.Must be system-created
• C.Must be numeric
• D.Must be two values only

Comment: *

Name: *

Email: *

Verification: *

A data analyst needs to derive a new field that flags sales within the month of January from the following sales table:

Which of the following types of functions should the analyst use to achieve the desired results?

• A.Logical
• B.Date
• C.Aggregate
• D.String

Comment: *

Name: *

Email: *

Verification: *

Given the following tables:
Individual table
ID
FirstName
LastName
1
John
Doe
Output
ID
FullName
1
JohnDoe
Which of the following is the best option to display output from FirstName and LastName as FullName?

• A.Concatenate
• B.Filter
• C.Join
• D.Group

Comment: *

Name: *

Email: *

Verification: *