A data analyst needs to create a report that anticipates the number of calls received daily. Which of the following is the best statistical method to use?
A. Diagnostic
B. Inferential
C. Predictive
D. Descriptive
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
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. Group
B. Concatenate
C. Join
D. Filter
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
Which of the following is business intelligence software?
A. Tableau
B. SAS
C. Notepad++
D. Python
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
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. Validate the date format with logical functions and use date functions to analyze.
B. Use date functions to analyze the data with no conversion.
C. Transform data to a numerical value and use mathematical functions.
D. Convert data to date format and use date functions.
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
A data analyst is working on an initial analysis of the dataset in the following table:
DateTime
Count
2024-01-01
12
2024-01-02
245
2024-01-02
13
2024-01-03
13
2024-01-03
12
00:00:00
12
Which of the following issues should the analyst flag in the data report?
A. Duplication
B. Outlier
C. Completeness
D. Mismatch
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 6:
A data analyst receives four files that need to be unified into a single spreadsheet for further analysis. All of the files have the same structure, number of columns, and field names, but each file contains different values.
Which of the following methods will help the analyst convert the files into a single spreadsheet?
A. Parsing
B. Clustering
C. Merging
D. Appending
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 7:
A product goes viral on social media, creating high demand. Distribution channels are facing supply chain issues because the testing and training models that are used for sales forecasting have not encountered similar demand. Which of the following best describes this situation?
A. Skewing
B. Incorrect sizing
C. Data drift
D. Model bias
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 8:
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?
A. SELECT firstName, lastName, SUM(income) FROM companyRoster ORDER BY firstName, income
B. SELECT firstName, lastName, SUM(income) FROM companyRoster HAVING SUM(income) >
10000000
C. SELECT firstName, lastName, SUM(income) FROM companyRoster
D. SELECT firstName, lastName, SUM(income) FROM companyRoster GROUP BY firstName, lastName
正解:D
解説: (Pass4Test メンバーにのみ表示されます)