Which type of analytics would a data scientist apply to determine WHY sales declined sharply in a particular region last quarter?
Descriptive analytics
Diagnostic analytics
Prescriptive analytics
Analytics is often described as a progression of increasingly sophisticated questions. Descriptive analytics reports what happened, for instance that regional sales fell by a certain percentage. Diagnostic analytics asks why it happened and seeks root causes through techniques such as drill-down, data discovery, correlation analysis, segmentation, and comparison against other regions or earlier periods. Investigating the reason for a sharp sales decline is a diagnostic task, so option B is correct. In practice the analyst might discover that a competitor launched a promotion, that a key product was out of stock, or that a pricing change coincided with the drop, then test each explanation against the data. Descriptive analytics, option A, establishes the existence and size of the decline but does not explain it. Prescriptive analytics, option C, recommends what to do next, such as adjusting prices or reallocating inventory, and builds on the understanding produced by diagnostic and predictive work. Predictive analytics, the remaining stage, estimates what is likely to occur. The categories frequently overlap within a single project, yet identifying the question being asked allows teams to choose suitable methods and to present findings in the form stakeholders need. Reference: Data Science Fundamentals Study Guide – Data Science Process: Types of Analytics (Descriptive, Diagnostic, Predictive and Prescriptive).
===============
Which of these communication methods used in stakeholder presentations has the potential to be misunderstood if not applied correctly?
Kinesthetic
Audible
Visual
Presentations of analytical results typically draw on audible, visual, and kinesthetic communication. Visual methods, which include charts, graphs, tables, maps, and diagrams, are the most common and the most powerful, because the eye can absorb patterns quickly. That strength is also the source of risk. A visual encodes data through choices about chart type, axis scale, color, labeling, and scope, and each choice can alter the impression the audience takes away. Truncated axes can exaggerate differences, three-dimensional effects can distort proportions, cluttered or unlabeled elements can obscure the message, and a chart shown without context can invite conclusions the data do not support. Viewers also interpret a static image independently, with no opportunity to ask what it means, which allows several readings to coexist. Option C is therefore correct. Audible communication, option B, takes place in conversation, where the presenter can adjust wording, ask for confirmation, and answer questions immediately. Kinesthetic communication, option A, involves hands-on demonstration or interaction, so participants test their understanding directly. Effective visual reporting follows established principles: select the form that fits the data and the question, label clearly, maintain honest scales, emphasize one message, and supply a brief narrative. Reference: Data Science Fundamentals Study Guide – Data Science Process: Communicating Results to Stakeholders and Data Visualization.
===============
Which measure of central tendency is LEAST affected by extreme outlier values in a data set?
Mean
Median
Range
Measures of central tendency summarize a data set with a single representative value, and they differ in their sensitivity to unusual observations. The mean is calculated from every value, so a single extreme observation can pull it substantially; in an income sample, one very high salary raises the average well above what most individuals earn. The median is the middle value once the data are ordered, and it depends on position rather than magnitude. Replacing the largest observation with an even larger one leaves the median unchanged, which is why it is described as a robust statistic and is the preferred summary for skewed distributions such as incomes, home prices, and response times. Option B is therefore correct. Option C, the range, is not a measure of central tendency at all. It is a measure of dispersion computed as the difference between the maximum and minimum, and it is the statistic most strongly distorted by outliers because it relies entirely on the two extreme values. When the mean and the median diverge noticeably, the gap itself indicates skew or outliers and should prompt further investigation of the data before modeling. Reference: Data Science Fundamentals Study Guide – Data Science Concepts: Descriptive Statistics (Measures of Central Tendency and Dispersion).
===============
Which data quality dimension is MOST directly violated when 15 percent of the records in a customer table have no value in the phone number field?
Accuracy
Completeness
Timeliness
Data quality is assessed against several dimensions, each of which isolates a different way data can fall short of its intended use. Completeness measures whether all required values are present, and it is breached whenever mandatory fields are empty or expected records are absent. A customer table in which a substantial share of rows lacks a phone number is a textbook completeness problem, because the information needed to contact those customers does not exist in the data set. It is typically quantified as the percentage of populated fields against those that should be populated and addressed through mandatory-field rules, validation at entry, or enrichment from other sources. Accuracy, option A, concerns whether recorded values correctly reflect reality; a phone number that is present but belongs to another person would violate accuracy, whereas a missing one does not. Timeliness, option C, concerns whether data are current enough for the purpose, so an outdated number that was once valid is a timeliness issue. Other recognized dimensions include consistency, validity, and uniqueness. Matching the symptom to the correct dimension allows an organization to select the proper remediation and monitoring control. Reference: Data Science Fundamentals Study Guide – Data Management: Data Quality Dimensions and Data Governance.
===============
Which company was responsible for creating the first autonomous database?
Oracle
SAP
IBM
Oracle announced the Oracle Autonomous Database in 2017 and made it generally available in 2018, positioning it as the first self-driving, self-securing, and self-repairing database offered as a cloud service. The product applies machine learning to tasks that traditionally required database administrators, including provisioning, performance tuning, indexing, patching and upgrading, backup and recovery, and threat detection. Because many of these operations occur automatically and online, the design aims to reduce human error, lower operating costs, and minimize planned downtime, allowing technical staff to concentrate on data modeling and application development rather than maintenance. It runs on Oracle's Exadata infrastructure and is offered in workload-specific forms for transaction processing and for data warehousing. Option A is therefore correct. SAP, option B, is best known for enterprise applications and for its in-memory database platform, SAP HANA, and IBM, option C, for Db2 and its broader data and AI portfolio; both vendors have added automation features since, yet neither introduced the first autonomous database. The concept is significant for data professionals because it illustrates the shift toward managed, AI-assisted data platforms in which routine administration is delegated to the system, changing the skills organizations prioritize. Reference: Data Science Fundamentals Study Guide – Data Management: Database Technologies and Emerging Trends (Autonomous Databases).
===============
Where do the data input streams for data warehouses primarily come from?
third-party vendors.
web sites.
operational databases.
A data warehouse exists to integrate information about the business, and the most reliable and comprehensive record of business activity resides in the organization's operational systems. Transactional applications for sales, finance, human resources, supply chain, and customer service write their records to operational databases as events occur. Through scheduled or continuous ETL processes, those records are extracted, cleansed, conformed to common definitions, and loaded into the warehouse, where history is accumulated for analysis. Operational databases are therefore the primary feeder, and option C is correct. Third-party vendors, option A, supply valuable supplementary data such as demographic or market information, and web sites, option B, produce clickstream and campaign data that are often captured through analytics tools; both are legitimate secondary sources that enrich the warehouse, but neither provides the core transactional foundation. Modern architectures also ingest flat files, application programming interfaces, and event streams, which extends the range of inputs without displacing operational systems as the main source. The distinction matters for data quality, because any error in an operational record propagates to the warehouse, and so source system profiling and validation are standard early steps in warehouse design. Understanding the flow from operational systems to analytical systems explains why the two database types are separated. Reference: Data Science Fundamentals Study Guide – Data Management: Data Warehousing Concepts and Data Integration.
===============
Which business analytics technique are business stakeholders using when they try to forecast holiday sales for the month of December?
Prescriptive analytics
Descriptive analytics
Predictive analytics
Business analytics is commonly organized into descriptive, diagnostic, predictive, and prescriptive techniques, and each answers a different question. Forecasting December holiday sales asks what is likely to happen in the future, which is the defining purpose of predictive analytics. The technique applies statistical models, time series methods, or machine learning to historical sales, seasonalit y, promotions, and economic indicators in order to estimate a future value together with its uncertainty. Descriptive analytics, option B, summarizes what has already occurred, such as last December's revenue by region, and produces reports and dashboards rather than projections. Prescriptive analytics, option A, goes a step further by recommending a course of action, for example how much stock to order or what discount to offer, typically using optimization or simulation built on top of a forecast. The scenario stops at estimating the sales figure itself, so no recommendation is involved. Stakeholders frequently move through the three in sequence: they review past results, forecast the coming period, and then decide on actions. Identifying which stage a described activity belongs to is a routine skill expected of data science practitioners working with business teams. Reference: Data Science Fundamentals Study Guide – Data Science Process: Types of Analytics (Descriptive, Predictive, Prescriptive).
===============
Which of the following should be understood as compulsory restrictions that must be followed?
Codes of conduct
Ethics
Policies
Governance frameworks distinguish between instruments that compel behavior and those that guide it. A policy is a formal statement approved by management that establishes what personnel and systems must or must not do. Policies carry the authority of the organization and are accompanied by consequences, including disciplinary action, for noncompliance, and they are supported by standards, procedures, and controls that put them into practice. Data handling policies, for example, specify classification, retention, access, and sharing rules that employees are obligated to follow. For this reason policies are the compulsory restrictions in the question, and option C is correct. Ethics, option B, are principles of right and wrong that shape judgment and are not self-enforcing; they inform decisions in situations that rules do not anticipate and often extend beyond what the law or policy demands. A code of conduct, option A, articulates an organization's values and the standards of behavior it expects, and while it may be tied to employment, it generally communicates expectations and aspirations in broad terms rather than detailed mandatory requirements. Understanding where each instrument sits in the hierarchy helps data professionals determine which obligations are binding and which are advisory when handling sensitive information. Reference: Data Science Fundamentals Study Guide – Data Management: Data Governance, Policies and Ethical Guidelines.
===============
Benchmark measurements are:
balanced scorecard (BSC) indicators.
lead indicators.
lag indicators.
Performance indicators are classified by their relationship to outcomes. Lead indicators are predictive and input-oriented; they measure activities that influence future results and give an opportunity to act in advance, such as the number of sales calls made or training hours completed. Lag indicators are output-oriented and report results after performance has occurred, such as revenue, profit, defect rates, or customer satisfaction scores for the previous quarter. They are easy to measure and confirm whether goals were achieved, but they cannot be changed once recorded. Benchmark measurements compare an organization's achieved results against a standard, whether the performance of peers, an industry average, or its own earlier period. Because the figures being compared are outcomes that have already been observed, benchmarks are characterized as lag indicators, which makes option C correct. Option B is therefore inappropriate, since a benchmark describes where performance stands rather than predicting where it is headed. Option A is too broad. The balanced scorecard is a strategic framework that organizes measures across four perspectives and contains both lead and lag indicators, so labeling benchmarks as BSC indicators does not identify what kind of indicator they are. Effective measurement programs combine both types: lag measures confirm progress against strategic objectives, while lead measures guide daily corrective action. Reference: Data Science Fundamentals Study Guide – Data Science Process: Performance Measurement, Benchmarks and Leading and Lagging Indicators.
===============
What does Bayes' Theorem state?
There are four classes of scales that are unchanging.
Processing power doubles in size every two years.
If something is true, something related to it is potentially true.
Bayes' Theorem is a result in probability theory describing how to revise the probability of a hypothesis once new evidence is observed. Expressed mathematically, the probability of A given B equals the probability of B given A multiplied by the prior probability of A, divided by the probability of B. The theorem formalizes conditional reasoning: knowledge that one event has occurred or is true changes the likelihood of a related event. This is why it appears in spam filtering, medical diagnostic testing, and the naive Bayes classifier, where prior beliefs are combined with observed features to yield a posterior probability. Option C expresses that relationship in general terms, namely that if something is true, a related event becomes potentially true. Option A confuses the theorem with the four scales of measurement (nominal, ordinal, interval, and ratio) associated with S. S. Stevens, which concern how variables are classified rather than how probabilities are updated. Option B restates Moore's law, an observation about transistor density and computing power with no connection to probability. Candidates should be able to distinguish these three named principles, since each belongs to a different strand of the data science foundation. Reference: Data Science Fundamentals Study Guide – Data Science Concepts: Probability and Statistics Fundamentals (Bayes' Theorem).
===============
What is metadata?
Data that describes other data, such as its structure, origin, and format
Data that has been encrypted to prevent unauthorized access
Data that is duplicated and stored in a separate location for recovery
Metadata is commonly defined as data about data. It records the characteristics that make a data set understandable, discoverable, and governable without altering the content itself. Technical metadata covers schemas, table and column names, data types, formats, and storage locations. Business metadata supplies definitions, ownership, and rules in the language of the organization. Operational metadata captures lineage, creation and modification dates, refresh schedules, and access history. A file's author and timestamp, a database's data dictionary, and the column descriptions in a catalog are all familiar examples. Well-maintained metadata allows analysts to find relevant data sets, interpret fields correctly, assess quality, and trace the origin of a figure back to its source, and it is therefore a cornerstone of governance programs and data catalogs. Option B describes encryption, a security control that transforms data into an unreadable form for confidentiality and has no connection to descriptive information. Option C describes backup or replication, which protects availability and supports recovery. Both address how data are protected rather than how they are described. Metadata is also what enables data lakes to remain usable rather than becoming an unsearchable accumulation of raw files. Reference: Data Science Fundamentals Study Guide – Data Management: Metadata, Data Cataloging and Data Lineage.
===============
Which of the following is an example of qualitative data?
Days of the week
Number of children
Gender
Qualitative, or categorical, data records a quality or attribute of an observation rather than a measured amount. Its values are labels that place each record into a group, and arithmetic on those labels carries no meaning. Gender is a clear instance: the values identify membership in a category, there is no natural numeric magnitude, and operations such as summing or averaging are meaningless. It is analyzed through frequencies, proportions, and cross-tabulations rather than means and standard deviations. Number of children, option B, is quantitative because it is a count; it is discrete, supports arithmetic, and permits a meaningful average or total. Days of the week, option A, may look categorical, but it is less definitive as an example. The labels follow a fixed order and a repeating cycle, and in analytical work they are frequently encoded numerically or treated as an ordered feature, which blurs the line that gender draws so cleanly. The question therefore asks for the unambiguous nominal attribute. Distinguishing qualitative from quantitative data, and nominal from ordinal, interval, and ratio scales, determines which summary statistics, visualizations, and models are valid for a given variable. Reference: Data Science Fundamentals Study Guide – Data Science Concepts: Data Types and Levels of Measurement.
===============
Data analysis provides significant value to organizations primarily because of its ability to:
produce targeted marketing campaigns.
ensure cost reductions associated with data management.
predict the behavior of consumer preferences.
The principal value of analysis is that it turns accumulated data into foresight. By examining historical and current records for patterns, trends, and relationships, an organization can estimate how customers are likely to behave and what they are likely to prefer, then plan inventory, pricing, product development, and service levels before demand materializes rather than after. This anticipatory capacity is what distinguishes analytical organizations from those that merely report on the past. Option A describes one downstream application. Targeted campaigns are only possible because analysis first characterizes and anticipates consumer segments, so they are a consequence of the predictive capability rather than the primary reason analysis matters; the same insight supports many other functions. Option B overstates the case. Analysis consumes storage, tooling, and skilled labor, and it can raise data management expenditure; any savings arise indirectly through better decisions, and no analytical method can guarantee them. The study guide frames the benefit in terms of insight and prediction that improve decision quality across the enterprise, which is the reasoning reflected in option C. Candidates should connect this idea to the analytics maturity progression from descriptive to predictive and prescriptive work. Reference: Data Science Fundamentals Study Guide – Data Science Concepts: Value of Data Analysis to the Organization.
===============
Which choice BEST captures the distinction between operational and non-operational databases?
Operational databases update data in real time.
Non-operational databases process in real time.
Non-operational databases use online transaction processing (OLTP).
Operational databases support the daily running of an organization. They record transactions as they occur, such as orders, payments, reservations, and inventory movements, and they are designed for many small, fast reads and writes, with strong consistency guarantees. This workload is called online transaction processing, or OLTP, and it requires that data be updated in real time so that the current state of the business is always reflected. Non-operational databases, which include data warehouses, data marts, and archives, serve analytical and historical purposes. They are populated periodically from operational sources, hold large volumes of integrated historical data, and are tuned for complex queries and aggregation, a pattern known as online analytical processing, or OLAP. They are not updated transaction by transaction. Option A therefore expresses the distinction accurately. Option B reverses the relationship by assigning real-time processing to the non-operational type. Option C is likewise incorrect because OLTP is the defining workload of operational systems, whereas non-operational systems use OLAP. The separation protects performance, since heavy analytical queries run against a warehouse instead of competing with customer-facing transactions on the operational system. Recognizing which type of database fits a given requirement is fundamental to designing a sound data architecture. Reference: Data Science Fundamentals Study Guide – Data Management: Database Types (Operational and Non-Operational Databases, OLTP and OLAP).
===============
When the root node of a tree is greater than or equal to its child nodes, this structure is known as which of the following?
Max heap
Min heap
Heap
A heap is a complete binary tree that satisfies an ordering rule between each parent and its children, and the direction of that rule yields two variants. In a max heap, every parent node holds a value greater than or equal to the values of its children, so the largest element always sits at the root and can be retrieved in constant time. In a min heap the inequality is reversed: each parent is less than or equal to its children and the smallest element occupies the root. The question specifies that the root is greater than or equal to its children, which identifies the max heap. Option B describes the opposite ordering. Option C, simply "heap", names the general structure and does not distinguish between the two orderings, so it is not specific enough to match the stated condition. Heaps are typically stored in arrays, with children located at computed index positions, and they underpin priority queues and the heapsort algorithm. Insertion and removal run in logarithmic time because elements are moved up or down the tree to restore the property. Understanding this structure belongs to the guide's treatment of non-linear data structures. Reference: Data Science Fundamentals Study Guide – Data Science Concepts: Data Structures (Trees and Heaps).
===============
TESTED 22 Nov 2026