Which of the following best describes the method used to combine files, software, and libraries for use on various operating systems and environments?

• A.Package manager
• B.Code repository
• C.Virtual machine
• D.Containerization

Comment: *

Name: *

Email: *

Verification: *

A data analyst is evaluating all conditions in a query. Which of the following is the best logical function to accomplish this task?

• A.OR
• B.NOT
• C.AND
• D.IF

Comment: *

Name: *

Email: *

Verification: *

An analyst needs to produce a final dataset using the following tables:
CourseID
SectionNumber
StudentID
MATH1000
1
10009
MATH1000
2
10007
PSYC1500
1
10009
PSYC1500
1
10015
StudentID
FirstName
LastName
10009
Jane
Smith
10007
John
Doe
10015
Robert
Roe
The expected output should be formatted as follows:
| CourseID | SectionNumber | StudentID | FirstName | LastName |
Which of the following actions is the best way to produce the requested output?

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

Comment: *

Name: *

Email: *

Verification: *

A manager wants to use the information in a recurring report on incomplete timesheets for the prior month to guide employee outreach. Which of the following report types is the best for this task?

• A.Ad hoc
• B.Summary
• C.Snapshot
• D.Infographic

Comment: *

Name: *

Email: *

Verification: *

A data analyst must create a report to analyze the flow of services from call receipt to service completion using established time points. Which of the following techniques should the analyst use to create the needed variables?

• A.Binning
• B.Calculating
• C.Scaling
• D.Parsing

Comment: *

Name: *

Email: *

Verification: *