Q132. Which of the following is used for calculations and pivot tables?

Q133. Given the following customer and order tables:
Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?

Q134. Which of the following is an example of a discrete variable?

Q135. Given the following:

Which of the following is the most important thing for an analyst to do when transforming the table for a trend analysis?

Q136. An analyst has received the requirements for an internal user dashboard. The analyst confirms the data sources and then creates a wireframe. Which of the following is the NEXT step the analyst should take in the dashboard creation process?

Q137. When analyzing the values of two variables, you decide to convert both variables so they are on a scale of 0 to
1.
What term describes this action?

Q138. Standardized tests are given to students in the middle of each month, and the results are ready by the end of the month. The superintendent needs a quick view of test performance. Which of the following would be the best recommendation to meet the superintendent’s requirements?

Q139. A data analyst was asked to create a chart that shows the relationship between study hours and exam scores for each student using the data sets in the table below:

Which of the following charts would BEST represent the relationship between the variables?

Q140. A military commander would like to see the health scorecards of the troops daily and filter them based on gender and rank. Considering this data is PHI, which of the following would be the best way for the commander to view the information?

Q141. The duration of a phone call in milliseconds is an example of:

Q142. Given the diagram below:

Which of the following types of sampling is depicted in the image?

Q143. A data analyst wants to create “Income Categories” that would be calculated based on the existing variable
“Income”. The “Income Categories” would be as follows:
Income category 1: less than $1.
Income category 2: more than $1 and less than $20,000.
Income category 3: more than $20,001 and less than $40,000.
Income category 4: more than $40,001.
Which of the following data manipulation techniques should the data analyst use to create “Income Categories”?

Q144. Which of the following value is the measure of dispersion “range” between the scores of ten students in a test.
The scores of ten students in a test are 17, 23, 30, 36, 45, 51, 58, 66, 72, 77.

Q145. An analyst needs to provide a chart to identify the composition between the categories of the survey response data set:

Which of the following charts would be BEST to use?

Q146. Analyze the values of X shown below
(2,2,5,6,7)
What is the range of these values?

Q147. An analyst needs to provide a chart to identify the composition between the categories of the survey response data set:

Which of the following charts would be BEST to use?

Q148. A table in a hospital database has a column for patient height in inches and a column for patient height in centimeters. This is an example of: