Latest Exam Prep

Q113. An analyst modified a data set that had a number of issues. Given the original and modified versions:

Which of the following data manipulation techniques did the analyst use?

Q114. Given the following graph:

Which of the following summary statements upholds integrity in data reporting?

Q115. Jenny wants to study the academic performance of undergraduate sophomores and wants to determine the average grade point average at different points during an academic year.
What best describes the data set she needs?

Q116. A cereal manufacturer wants to determine whether the sugar content of its cereal has increased over the years.
Which of the following is the appropriate descriptive statistic to use?

Q117. You are a database administrator and you create a precompiled query that is stored on the database server.
What have you created?

Q118. After completing web scraping, which of the following file formats needs to be parsed?

Q119. Which of the following best describes a business analytics tool with interactive visualization and business capabilities and an interface that is simple enough for end users to create their own reports and dashboards?
Python

Q120. Which of the following describes the method of sampling in which elements of data are selected randomly from each of the small subgroups within a population?

Q121. A data analyst needs to calculate the mean for Q1 sales using the data set below:

Which of the following is the mean?

Q122. Which of the following statements would be used to append two tables that have the same number of columns?

Q123. Data validation should occur only when data is initially brought into a organization.

Q124. You recently downloaded a file containing website visitor logs from your organization’s web server.
What term best describes these logs at this point in the process?

Q125. You are working with a professional statistician to perform an analysis and would like to use a statistics package.
Which one of the following would be the most appropriate?

Q126. Which of the following best describes an exploratory analysis?

Q127. 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:

Q128. Which of the following contains alphanumeric values?

Q129. A junior web developer is developing a new application where users can upload short videos. The first task is to create a homepage that shows the headline “Upload Your Short Videos” and a clickable button that says “upload now”.
Which of the following HTML commands would help the developer to complete the task successfully?

Q130. A web developer wants to ensure that malicious users can’t type SQL statements when they asked for input, like their username/userid.
Which of the following query optimization techniques would effectively prevent SQL Injection attacks?

Q131. What type of regulation is the Payment Card Industry Data Security Standard (PCIDSS)?

Q132. Which of the following data manipulation techniques is an example of a logical function?

Q133.

Which of the following logical statements results in Table B?

Q134. Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general-purpose programming language?

Q135. Andrew conducts a study and wants to capture eye color.
What kind of data is eye color?
Choose the best response.

Q136. Under which of the following circumstances should the null hypothesis be accepted when a = 0.05?