Wednesday , November 18 2026
Breaking News

Data Analyst Professional Certification Exam Answers 2026 (All 100 Questions)

Data Analyst Professional Certification exam answers 2026: This page lists all 100 questions of the official Data Analyst Professional Certification exam by Itronix Solutions, each with its four answer options and the correct answer highlighted in green. Use it to revise every topic before you attempt the test and earn your verifiable certificate.

About this certification: IBM Data Analyst Professional Certificate is one of the top data analytics certificate courses recommended for aspiring data analysts.

Certification Data Analyst Professional Certification
Provider Itronix Solutions
Category Data Science & Analytics
Total questions 100 multiple-choice questions
Marks 1 mark per question (100 marks)
Passing score 80% (80 out of 100)
Retake Available if you do not pass
Certificate Verifiable online certificate

Take the exam: Data Analyst Professional Certification on Itronix Solutions. See every other Itronix exam in our complete list of Itronix certification answers.

Data Analyst Exam Questions and Answers

Questions 1 to 25

1. Data warehouse is a(n) ________, integrated, time-variant, nonvolatile collection of data in support of management’s decision making process.

A. subject-oriented ✔
B. model-oriented
C. analysis-oriented
D. object-oriented

Correct answer: A. subject-oriented

2. A data warehouse maintains historical data that do not necessarily provide current status, except in real-time systems.

A. True ✔
B. False

Correct answer: A. True

3. Which BI analytic application provides the following business value: Interact with customers based on their preference and your need to manage cost?

A. customer attrition
B. channel optimization ✔
C. customer segmentation
D. fraud detection

Correct answer: B. channel optimization

4. Dashboards and information portals are important BI data visualization tools.

A. True ✔
B. False

Correct answer: A. True

5. What is Cognos Analytics?

A. A business intelligence and performance management software ✔
B. A database management system
C. A data mining software
D. A cloud-based data visualization tool

Correct answer: A. A business intelligence and performance management software

6. Which of the following Cognos components is responsible for managing and distributing reports?

A. Query Studio
B. Framework Manager
C. Cognos Connection ✔
D. Report Studio

Correct answer: C. Cognos Connection

7. Which of the following Cognos components is used for creating and modifying business intelligence models?

A. Query Studio
B. Framework Manager ✔
C. Cognos Connection
D. Report Studio

Correct answer: B. Framework Manager

8. What is the purpose of Cognos Transformer?

A. To create and manage reports
B. To create and manage data sources
C. To create and manage data models
D. To create and manage OLAP cubes ✔

Correct answer: D. To create and manage OLAP cubes

9. What are the different types of Simulation Models?

A. Active models
B. Interactive model
C. Computer simulators
D. All of the above ✔

Correct answer: D. All of the above

10. What is the advantage of direct measurement of outcomes over modelled estimates?

A. It is more reliable. ✔
B. It is essential in scientific activity.
C. It is easier to implement.
D. It is inseparable from experimental conditions.

Correct answer: A. It is more reliable.

11. Which of the following options best describes the concept of simulations in statistical modeling?

A. Simulations involve using mathematical formulas to analyze data.
B. Simulations are used to generate random data for statistical analysis. ✔
C. Simulations refer to visual representations of data in graphs or charts.
D. Simulations are used to interpret results of statistical tests.

Correct answer: B. Simulations are used to generate random data for statistical analysis.

12. In Data Processing, what does the abbreviation SAP stand for ?

A. Systems, Authorizations, Programs
B. Systems, Algorithms, Processes
C. Systems, Applications, Products ✔
D. Sales, Allocations, Purchases

Correct answer: C. Systems, Applications, Products

13. The IBM _________ analytics appliances combine high-capacity storage for Big Data with a massively-parallel processing platform for high-performance computing.

A. Watson ✔
B. Netezza
C. InfoSight
D. LityxEQ

Correct answer: A. Watson

14. ______ is an integrated hosted analytics platform for marketing insights, predictive models, and marketing optimization”

A. WatSon
B. LityxIQ ✔
C. InfoSight
D. LityxEQ

Correct answer: B. LityxIQ

15. _______ is rapidly being adopted for computing descriptive and query types of analytics on Big data.

A. InfoSight
B. EDR
C. Hadoop ✔
D. Azure

Correct answer: C. Hadoop

16. _________ involves predicting a response with meaningful magnitude, such as quantity sold, stock price, or return on investment.

A. Summarization
B. Clustering
C. Classification
D. Regression ✔

Correct answer: D. Regression

17. ________ is a JavaScript charting library and feature-rich API set that lets you build interactive Flash or HTML5 charts.

A. ZingChart ✔
B. paleoTS
C. InstantAtlas
D. Alterian

Correct answer: A. ZingChart

18. ______ is simplest class of analytics.

A. Summarization
B. Descriptive ✔
C. Predictive
D. Prescriptive

Correct answer: B. Descriptive

19. Which of the following is preferred for text analytics?

A. EDR
B. R
C. Python ✔
D. S

Correct answer: C. Python

20. Which of the following contains pre-built predictive tools?

A. fossilx
B. paleoTS
C. ssas
D. alteryx ✔

Correct answer: D. alteryx

21. A data analyst mainly:

A. Designs logos
B. Collects, cleans and analyses data to answer business questions ✔
C. Writes legal contracts
D. Builds hardware

Correct answer: B. Collects, cleans and analyses data to answer business questions

22. The data analysis process usually starts with:

A. Building a dashboard
B. Asking a clear business question ✔
C. Buying software
D. Deleting data

Correct answer: B. Asking a clear business question

23. The six phases of the Google data analytics process are:

A. Ask, Prepare, Process, Analyse, Share, Act ✔
B. Plan, Code, Test, Deploy, Monitor, Close
C. Collect, Store, Sell, Report, Audit, Delete
D. Design, Build, Ship, Market, Sell, Support

Correct answer: A. Ask, Prepare, Process, Analyse, Share, Act

24. Structured data is:

A. Organised in rows and columns ✔
B. Free-form text only
C. Audio only
D. Images only

Correct answer: A. Organised in rows and columns

25. Unstructured data includes:

A. Database rows
B. CSV files
C. Spreadsheet tables
D. Emails, images and videos ✔

Correct answer: D. Emails, images and videos

Questions 26 to 50

26. Qualitative data describes:

A. Currency only
B. Dates only
C. Qualities or categories ✔
D. Measured numbers only

Correct answer: C. Qualities or categories

27. Quantitative data is:

A. Descriptive categories only
B. Numeric and measurable ✔
C. Colours only
D. Opinions only

Correct answer: B. Numeric and measurable

28. First-party data is:

A. Bought from strangers
B. Collected directly by an organisation from its own sources ✔
C. Guessed
D. Copied from competitors

Correct answer: B. Collected directly by an organisation from its own sources

29. Data cleaning involves:

A. Changing the question
B. Deleting the whole dataset
C. Adding random values
D. Fixing errors, duplicates and inconsistencies ✔

Correct answer: D. Fixing errors, duplicates and inconsistencies

30. A duplicate record is:

A. An outlier
B. The same entry appearing more than once ✔
C. A new column
D. A missing value

Correct answer: B. The same entry appearing more than once

31. A null value represents:

A. An error message
B. A duplicate
C. Missing or unknown data ✔
D. Zero always

Correct answer: C. Missing or unknown data

32. Data integrity means:

A. Data is large
B. Data is colourful
C. Data is accurate, complete and consistent over its lifecycle ✔
D. Data is secret

Correct answer: C. Data is accurate, complete and consistent over its lifecycle

33. Sampling bias occurs when:

A. Data is clean
B. A sample does not represent the population ✔
C. The sample is random
D. The sample is large

Correct answer: B. A sample does not represent the population

34. A spreadsheet is useful for:

A. Organising, calculating and visualising smaller datasets ✔
B. Running websites
C. Training deep networks
D. Editing video

Correct answer: A. Organising, calculating and visualising smaller datasets

35. In spreadsheets, a function like SUM:

A. Creates charts
B. Adds values in a range ✔
C. Deletes rows
D. Sorts text

Correct answer: B. Adds values in a range

36. COUNTIF counts:

A. Only blank cells
B. Characters
C. Cells that meet a condition ✔
D. All cells

Correct answer: C. Cells that meet a condition

37. VLOOKUP or XLOOKUP is used to:

A. Sort data
B. Retrieve matching data from another table ✔
C. Format cells
D. Create charts

Correct answer: B. Retrieve matching data from another table

38. A pivot table is used to:

A. Send emails
B. Write SQL
C. Store passwords
D. Summarise and aggregate data quickly ✔

Correct answer: D. Summarise and aggregate data quickly

39. Conditional formatting highlights:

A. Cells that meet specific rules ✔
B. Only headers
C. All cells equally
D. Only charts

Correct answer: A. Cells that meet specific rules

40. SQL stands for:

A. Structured Query Language ✔
B. Sequential Query Link
C. Simple Question Language
D. System Quality Log

Correct answer: A. Structured Query Language

41. SELECT in SQL is used to:

A. Back up a database
B. Retrieve data from a table ✔
C. Create a user
D. Delete a table

Correct answer: B. Retrieve data from a table

42. WHERE in SQL is used to:

A. Join tables
B. Group rows
C. Sort results
D. Filter rows based on conditions ✔

Correct answer: D. Filter rows based on conditions

43. ORDER BY in SQL is used to:

A. Sort the results ✔
B. Rename columns
C. Filter rows
D. Count rows

Correct answer: A. Sort the results

44. GROUP BY in SQL is used to:

A. Aggregate rows that share values ✔
B. Delete duplicates
C. Join tables
D. Sort alphabetically only

Correct answer: A. Aggregate rows that share values

45. HAVING in SQL filters:

A. Groups after aggregation ✔
B. Rows before aggregation
C. Tables
D. Databases

Correct answer: A. Groups after aggregation

46. COUNT(*) returns:

A. The number of rows ✔
B. The average
C. The largest value
D. The sum of values

Correct answer: A. The number of rows

47. AVG() returns:

A. The maximum
B. The average of values ✔
C. The minimum
D. The count

Correct answer: B. The average of values

48. An INNER JOIN returns:

A. Rows with matching values in both tables ✔
B. All rows from both
C. Only left rows
D. Only unmatched rows

Correct answer: A. Rows with matching values in both tables

49. A LEFT JOIN returns:

A. All rows from the left table plus matches from the right ✔
B. Only matches
C. No rows
D. Only right rows

Correct answer: A. All rows from the left table plus matches from the right

50. DISTINCT in SQL:

A. Deletes duplicates from the table
B. Returns unique values ✔
C. Counts nulls
D. Sorts values

Correct answer: B. Returns unique values

Questions 51 to 75

51. LIMIT in SQL:

A. Deletes rows
B. Restricts the number of rows returned ✔
C. Groups data
D. Joins tables

Correct answer: B. Restricts the number of rows returned

52. A primary key:

A. Is always text
B. Can repeat freely
C. Links nothing
D. Uniquely identifies each row in a table ✔

Correct answer: D. Uniquely identifies each row in a table

53. A foreign key:

A. Deletes rows
B. References a primary key in another table ✔
C. Sorts data
D. Is always unique in its own table

Correct answer: B. References a primary key in another table

54. CAST or CONVERT is used to:

A. Join tables
B. Count rows
C. Change a value’s data type ✔
D. Sort data

Correct answer: C. Change a value’s data type

55. A CTE (WITH clause) is used to:

A. Grant access
B. Delete data
C. Define a temporary named result set within a query ✔
D. Create a permanent table

Correct answer: C. Define a temporary named result set within a query

56. The mean is affected strongly by:

A. Outliers ✔
B. Data type labels
C. Column names
D. Sorting

Correct answer: A. Outliers

57. The median is:

A. The range
B. The most frequent value
C. The middle value in sorted data ✔
D. The average

Correct answer: C. The middle value in sorted data

58. The mode is:

A. The most frequently occurring value ✔
B. The spread
C. The middle value
D. The mean

Correct answer: A. The most frequently occurring value

59. Range equals:

A. Sum divided by count
B. Mean minus median
C. Mode times two
D. Maximum minus minimum ✔

Correct answer: D. Maximum minus minimum

60. Standard deviation measures:

A. The middle value
B. The count
C. The total
D. Spread of data around the mean ✔

Correct answer: D. Spread of data around the mean

61. Correlation measures:

A. The average
B. The count
C. Causation always
D. The strength and direction of a relationship between two variables ✔

Correct answer: D. The strength and direction of a relationship between two variables

62. A KPI is:

A. A chart type
B. A key performance indicator that tracks progress toward a goal ✔
C. A database key
D. A file format

Correct answer: B. A key performance indicator that tracks progress toward a goal

63. A dashboard:

A. Cleans data
B. Displays key metrics visually in one place ✔
C. Writes SQL
D. Stores raw data only

Correct answer: B. Displays key metrics visually in one place

64. Tableau and Power BI are:

A. Databases
B. Programming languages
C. Email clients
D. Data visualisation and business intelligence tools ✔

Correct answer: D. Data visualisation and business intelligence tools

65. A bar chart is best for:

A. Comparing categories ✔
B. Showing correlation
C. Showing trends over time only
D. Showing parts of a whole precisely

Correct answer: A. Comparing categories

66. A line chart is best for:

A. Comparing many categories
B. Trends over time ✔
C. Showing geographic data
D. Showing parts of a whole

Correct answer: B. Trends over time

67. A scatter plot shows:

A. Category totals
B. The relationship between two numeric variables ✔
C. A single number
D. Text

Correct answer: B. The relationship between two numeric variables

68. A pie chart should be used:

A. Sparingly, for a few parts of a whole ✔
B. For time trends
C. For correlations
D. For dozens of categories

Correct answer: A. Sparingly, for a few parts of a whole

69. Data storytelling combines:

A. Only code
B. Only opinions
C. Only tables
D. Data, visuals and narrative to communicate insights ✔

Correct answer: D. Data, visuals and narrative to communicate insights

70. An effective presentation of findings should:

A. Use jargon heavily
B. Focus on the audience and the key insight ✔
C. Show every number
D. Avoid conclusions

Correct answer: B. Focus on the audience and the key insight

71. R and Python are used by analysts for:

A. Only design
B. Only email
C. Statistical analysis and automation ✔
D. Only word processing

Correct answer: C. Statistical analysis and automation

72. In R, the tidyverse is:

A. A database
B. A collection of packages for data science ✔
C. A chart type
D. An operating system

Correct answer: B. A collection of packages for data science

73. In R, ggplot2 is used for:

A. Web hosting
B. Data visualisation ✔
C. Email
D. Accounting

Correct answer: B. Data visualisation

74. In Python, pandas is used for:

A. Game design
B. Audio editing
C. Data manipulation and analysis ✔
D. Network routing

Correct answer: C. Data manipulation and analysis

75. A CSV file stores data as:

A. Comma-separated values in plain text ✔
B. Encrypted binaries
C. Images
D. Compressed video

Correct answer: A. Comma-separated values in plain text

Questions 76 to 100

76. Data privacy means:

A. Publishing all data
B. Protecting personal information from unauthorised access ✔
C. Selling data freely
D. Ignoring consent

Correct answer: B. Protecting personal information from unauthorised access

77. Data ethics includes:

A. Ignoring bias
B. Manipulating results
C. Hiding methods
D. Transparency, consent, fairness and privacy ✔

Correct answer: D. Transparency, consent, fairness and privacy

78. Metadata is:

A. A chart
B. Data about data ✔
C. A deleted file
D. The largest dataset

Correct answer: B. Data about data

79. A data dictionary documents:

A. Customer complaints
B. Passwords
C. Marketing slogans
D. Field names, types and meanings ✔

Correct answer: D. Field names, types and meanings

80. Exploratory data analysis helps to:

A. Finalise the report immediately
B. Understand patterns, anomalies and relationships ✔
C. Delete data
D. Buy software

Correct answer: B. Understand patterns, anomalies and relationships

81. An outlier should be:

A. Ignored
B. Always kept without checking
C. Always deleted
D. Investigated before deciding to keep or remove it ✔

Correct answer: D. Investigated before deciding to keep or remove it

82. A/B testing compares:

A. Two employees
B. Two databases
C. Two languages
D. Two versions to determine which performs better ✔

Correct answer: D. Two versions to determine which performs better

83. Descriptive analytics answers:

A. What will happen?
B. What happened? ✔
C. Why did it happen only
D. What should we do?

Correct answer: B. What happened?

84. Diagnostic analytics answers:

A. What should we do?
B. Why did it happen? ✔
C. How big is the database?
D. What will happen?

Correct answer: B. Why did it happen?

85. Predictive analytics answers:

A. What is likely to happen? ✔
B. What happened?
C. Who wrote the data?
D. Why did it happen?

Correct answer: A. What is likely to happen?

86. Prescriptive analytics answers:

A. What is the data type?
B. What happened?
C. Where is the data stored?
D. What should we do? ✔

Correct answer: D. What should we do?

87. Data aggregation means:

A. Combining data into summary values ✔
B. Splitting data randomly
C. Encrypting fields
D. Deleting duplicates

Correct answer: A. Combining data into summary values

88. Trimming whitespace in data helps to:

A. Add errors
B. Avoid mismatches caused by extra spaces ✔
C. Change formats randomly
D. Increase file size

Correct answer: B. Avoid mismatches caused by extra spaces

89. Consistent date formats are important for:

A. Chart titles
B. Colour choices
C. Correct sorting and calculations ✔
D. Font sizes

Correct answer: C. Correct sorting and calculations

90. Data validation in spreadsheets:

A. Sends emails
B. Restricts entries to valid values ✔
C. Creates charts
D. Writes SQL

Correct answer: B. Restricts entries to valid values

91. A data warehouse stores:

A. Integrated historical data for analysis ✔
B. Only images
C. Only live transactions
D. Only backups

Correct answer: A. Integrated historical data for analysis

92. ETL stands for:

A. Enter, Track, Log
B. Edit, Test, Launch
C. Export, Transfer, Lock
D. Extract, Transform, Load ✔

Correct answer: D. Extract, Transform, Load

93. Google BigQuery is:

A. A cloud data warehouse that uses SQL ✔
B. A chart tool only
C. A spreadsheet
D. An email service

Correct answer: A. A cloud data warehouse that uses SQL

94. Version control of analysis files helps to:

A. Track changes and collaborate ✔
B. Hide errors
C. Slow work
D. Delete history

Correct answer: A. Track changes and collaborate

95. Stakeholders are:

A. Only competitors
B. Only database admins
C. Only customers
D. People who have an interest in the analysis outcome ✔

Correct answer: D. People who have an interest in the analysis outcome

96. SMART questions are:

A. None of these
B. Short, Messy, Abstract, Random and Timeless
C. Specific, Measurable, Action-oriented, Relevant and Time-bound ✔
D. Simple, Mild, Average, Rare and Typical

Correct answer: C. Specific, Measurable, Action-oriented, Relevant and Time-bound

97. Confirmation bias in analysis means:

A. Checking all evidence fairly
B. Cleaning data
C. Using random samples
D. Favouring data that supports existing beliefs ✔

Correct answer: D. Favouring data that supports existing beliefs

98. Reproducible analysis means:

A. It is secret
B. It only works once
C. It has no documentation
D. Others can repeat it and get the same results ✔

Correct answer: D. Others can repeat it and get the same results

99. The main value of a data analyst is to:

A. Store spreadsheets
B. Collect data without purpose
C. Create complex charts only
D. Turn data into clear insights that support decisions ✔

Correct answer: D. Turn data into clear insights that support decisions

100. A histogram shows:

A. The distribution of a numeric variable ✔
B. Two-variable relationships
C. Text frequency only
D. Category totals only

Correct answer: A. The distribution of a numeric variable

How to Pass the Data Analyst Exam

  • Read every question carefully; most options look similar, so look for the most precise answer.
  • Revise the questions above topic by topic rather than memorising letters, because option order can change in the live test.
  • You need 80 correct answers out of 100 to pass, so aim to understand at least 85 to stay safe.
  • If you do not clear it on the first attempt, review the questions you missed and use the retake option.

Frequently Asked Questions

How many questions are in the Data Analyst Professional Certification exam?

The exam has 100 multiple-choice questions, each worth 1 mark.

What is the passing score for the Data Analyst Professional Certification?

You need at least 80% (80 out of 100) to pass and receive the certificate.

Can I retake the Data Analyst Professional Certification exam?

Yes. If you score below 80%, you can retry the test after reviewing the topics.

Is the Itronix certificate verifiable?

Yes. Every certificate issued by Itronix Solutions has a unique ID that can be checked on the Itronix verify-certificate page.

More Data Science & Analytics Certification Answers

Disclaimer: These answers are provided for learning and revision. Questions and answers are checked regularly; if you find a mistake, let us know in the comments.

About Priya Dogra

Priya Dogra runs priyadogra.com, where she shares free certification courses, internships, jobs, scholarships and exam preparation guides for Indian students and freshers. Follow her on YouTube, LinkedIn and Instagram for the latest opportunities.

Check Also

Unix/ Linux Certification exam answers 2026

Unix/ Linux Certification Exam Answers 2026 (All 100 Questions)

All 100 Unix/ Linux Certification exam questions with correct answers highlighted - updated 2026.

Leave a Reply

Your email address will not be published. Required fields are marked *