A data analyst needs to calculate the mean for Q1 sales using the data set below:
Which of the following is the mean?
A.
$2,466.18
B.
$2,667.60
C.
$3,082.72
D.
$12,330.88
Given the diagram below:
Which of the following data schemas shown?
A.
Key-value pairs
B.
Online transactional processing
C.
Data lake
D.
Relational database
Which of the following is the best reason to use database views instead of tables?
A.
Views reduce the need for repetitive, complex data joins.
B.
Views allow for the storage of temporary data, whereas tables do not.
C.
Views allow for the joining of multiple data sources, whereas tables do not.
D.
Views can be used to restrict sensitive information.
Which of the following would a data analyst look for first if 100% participation is needed on survey results?
A.
Missing data
B.
Invalid data
C.
Redundant data
D.
Duplicate data
A sales director has requested a report for individual team members within the division be developed. The director would like the report to be shared with all team members, but individual team members should not be identifiable within the report. Which of the following access requirements would support the director’s needs?
A.
Create an acceptable use policy for the sales data.
B.
Release the report as user-group-based access and include data masking.
C.
Get a data use agreement from the individual team members.
D.
Provide the report based on role and include data encryption.