FINAL TEST 2026 QUESTIONS WITH
CORRECT ANSWERS GRADED A+
◍ You can rename sections under the ___ tab of the ribbon..
Answer: Home
◍ naive bayes analysis.
Answer: a supervised machine learning algorithm, which is used for
classification tasks, like text classification.
◍ A hidden slide is hidden from the ___ view but not from the Normal View..
Answer: Slide Show
◍ SPSS Modeler.
Answer: a data mining and text analytics software application from IBM. It
is used to build predictive models and conduct other analytic tasks
◍ You can duplicate slides in a presentation by ___ a desired slide and
clicking duplicate..
Answer: right-clicking
◍ A popular travel booking platform receives a large volume of web traffic,
GPS location data, and user-generated content from various sources. The
data analytics team is preparing this data for analysis to better understand
customer behavior and preferences. Which tool would be most suitable for
preparing this data?- Microsoft Excel- Tableau- Hadoop- Power BI.
Answer: HadoopHadoop is an open-source framework designed for the
distributed processing of large datasets across clusters of computers. It can
handle massive parallel ingestion and custom analysis for web traffic
parsing, GPS location analytics, and combining unstructured data feeds from
multiple sources. This makes it the most suitable choice for this travel
, booking platform's data preparation needs.
◍ Changing a single slide ___ will not affect all of the slides..
Answer: layout
◍ File properties make it easier for other people to ____ a presentation you
created..
Answer: use/find
◍ Most templates give you a few ___ choices to chose from..
Answer: color choices
◍ A team working for a social media company needs to analyze customer
feedback on a newly launched product using sentiment analysis.What is the
most appropriate approach for sentiment analysis in this
scenario?Regression analysisText miningTime series analysisClustering
analysis.
Answer: Text miningText mining is a process of analyzing text data to
extract useful information. It is the most appropriate approach for sentiment
analysis, as it deals with text data and can identify and extract the sentiment
behind the words.
◍ Diagnostic Analytics.
Answer: helps you understand why something happened in the past.
◍ Which type of data is needed to assess whether a new type of web content is
increasing user engagement?Web logDemographicCompetitor
analysisAdvertising cost.
Answer: Web log
◍ What kind of tools would be used in the following phases , and for which
kinds of use scenarios?
A. Phase 2: data preparation (list 4)
B. Phase 4: model building (list 9).
Answer: A. Phase 2 - data preparation, which includes the steps to explore,
preprocess, and condition data prior to modeling and
analysis.HadoopAlpineMinerOpenRefineDataWranglerPhase 4 -tools are
, focused primarily on statistical analysis or data mining softwareSAS
Enterprise MinerSPSS ModelerAlpine MinerSTATISTICAR and
PL/ROctaveWEKAPythonSQL
◍ You can choose ___ slides you wish to print from apresentation..
Answer: specific
◍ A pivot table is created using R programming representing 12 categories of
food or grocery items with the corresponding unit sales and revenue
generated over the last year. The scatterplot between the unit sale and
revenue earned is sum_unit and sum_dollars, respectively.Scatterplot:Which
data analytics techniques will be impactful based on the scatterplot?- Linear
regression model- Nonlinear regression model- Multiple regression model-
Logistic regression model.
Answer: Linear regression model
◍ What is the most appropriate data analytics technique for analyzing website
traffic patterns?ScatterplotRegression analysisLine chartHeat map.
Answer: Heat map
◍ Always check your color ___ before clicking Print..
Answer: settings
◍ A food delivery company would like to study economic conditions' effects
on sales. The analyst in charge of the project is planning on gathering
economic data from a well-known blog.Which question should the analyst
consider in the scenario?- Is the data correct?- Is the data formatted
appropriately?- Is the data accessible from an API?- Is the data exportable?.
Answer: Is the data correct?
◍ 9. Explain the trade-offs for precision and recall..
Answer: occurs because improving one usually comes at the expense of the
other
◍ Sections allow you to put slides into _______.
Answer: groups
, ◍ Which skills are required by data scientists for converting unstructured data
to structured data in data analytics projects?Data visualization skillsData
wrangling skillsText mining skillsMachine learning skills.
Answer: Data Wrangling Skills
◍ Why is formulating an initial hypothesis an integral part of the discovery
phase of the data analytics lifecycle?- It guarantees accurate predictions and
outcomes from the data.- It guides the subsequent data collection,
processing, and analysis activities.- It guarantees that the final results will
support the initial hypothesis.- It allows the team to use specific algorithms
for analysis..
Answer: It guides the subsequent data collection, processing, and analysis
activities
◍ Slide shows can be presented to live audiences, be a video stream on a ___,
or a looping presentation on a kiosk..
Answer: websites
◍ Which tool is used to connect users to relational databases and data
warehouse appliances in the model planning phase?- SAS Enterprise Miner-
SPSS Modeler- Alpine Miner- SAS/ACCESS.
Answer: SAS/ACCESS
◍ ___ need to be applied to your Word Document before it can be used as an
outline for a Powerpoint presentation..
Answer: Heading Styles
◍ In the data analytics process, which phase focuses on identifying candidate
models for clustering, classifying, or finding relationships and ensuring
analytical techniques align with business objectives?Data
transformationDiscoveryModel planningData preparation.
Answer: Model planning
◍ One way to reorder slides in a presentation is to simply ___ and ___ a slide
to a new location..
Answer: click , drag