A data analyst receives a flat file that includes dates. The analyst needs to calculate the number of days from the dates on the file to the current date. Which of the following is the best way to complete this task?

• A.Convert data to date format and use date functions.
• B.Validate the date format with logical functions and use date functions to analyze.
• C.Use date functions to analyze the data with no conversion.
• D.Transform data to a numerical value and use mathematical functions.

Comment: *

Name: *

Email: *

Verification: *

A report triggers an error that prevents information from being displayed. However, the report was functional before a database upgrade. Which of the following should a data analyst do first to troubleshoot the problem?

• A.Ensure the system has permissions for the report service.
• B.Verify the connection to the database.
• C.Check whether the data structures were modified.
• D.Change the report's refresh rate.

Comment: *

Name: *

Email: *

Verification: *

Which of the following is business intelligence software?

• A.Tableau
• B.SAS
• C.Notepad++
• D.Python

Comment: *

Name: *

Email: *

Verification: *

Which of the following supports capabilities such as automatic versioning, corruption checks, KPIs, and user authentication?

• A.Pipeline
• B.REST API
• C.Source control
• D.Notebook

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Source control
• B.Unit test
• C.Stress test
• D.Health check

Comment: *

Name: *

Email: *

Verification: *