اضغط هنا للانضمام الى قروب فوجي للإختبارات على تيليقرام

أرشيف أسئلة الاختبار

اختبار شهادة البيانات CompTIA Data+

هذه الصفحة مخصصة للأرشفة وتعرض جميع أسئلة الاختبار وروابط كل سؤال مع الخيارات والنقاشات.

الأسئلة

133 سؤال
  1. Which of the following aggregate functions are suitable for retrieving the total quantity sold by each employee?
  2. An analyst is working on a visual that shows the performance of sales by quarter for the last two years. Which of the following visuals should the analyst use t ...
  3. Which of the following occurs if a 90% confidence interval increases to 95%?
  4. Which of the following types of analysis would be best for an analyst to use to examine the relationships between authors who cited other authors in a library o ...
  5. An organization wants to evaluate whether project activities are within the set projections and in line to meet the desired project targets. Which of the follow ...
  6. Which of the following is the median of the number set: 3, 7, 5, 5, 6, 9?
  7. Which of the following database types is the best to use for transactional SQL?
  8. A data analyst is selecting charts to include in a report. Which of the following is the most important in selecting appropriate charts?
  9. Which of the following is the range value?
  10. Which of the following technologies would be best suited for creating a multiple linear regression model?
  11. Which of the following is the best reason for cleansing the data?
  12. Which of the following functions best describes adding new data based on combining the values in other separate columns?
  13. A database consists of one fact table that is composed of multiple dimensions. Each dimension is represented by a denormalized table. This structure is an examp ...
  14. Which of the following should an analyst do to best summarize the data on a data set?
  15. Which of the following integration techniques should the analyst use?
  16. Which of the following data types would most likely represent multidimensional data?
  17. Which of the following data manipulation techniques should the analyst use?
  18. Which of the following dashboard elements should the analyst consider first to satisfy this request?
  19. Which of the following is an example of a structured data type?
  20. Which of the following data manipulation techniques should the analyst use?
  21. Which of the following best describes the data quality issue?
  22. Which of the following is the best reason to use database views instead of tables?
  23. Which of the following statistical methods should a data analyst most likely use when extrapolating from a data set with multiple variables?
  24. Which of the following activities is most likely performed during data preparation in the ETL process?
  25. Which of the following should the analyst and client do first to create the report?
  26. A data analyst is evaluating a data set to see the width of a variable. Which of the following statistical methods is appropriate?
  27. A reporting analyst needs to create a report that refreshes automatically and is accessible to the entire sales organization. Which of the following tools is th ...
  28. Which of the following best describes a 95% confidence interval?
  29. A data analyst needs to determine which size of shirt is likely to be the most popular at a store. Shirts come in small, medium, and large sizes. Which of the f ...
  30. A client has requested an analysis of all pet care items purchased by current customers and their social media connections in the past 12 months. Which of the f ...
  31. A data analyst wants to use data manipulation to store newly acquired data. Which of the following techniques should the analyst use?
  32. A data analyst needs to determine the most common number of minutes users spend on a company's website. Which of the following statistical measures should be ap ...
  33. An analyst needs to know what data an organization possesses. Which of the following is the best document for the analyst to consult?
  34. Which of the following are the first steps a company should take after discovering a data breach?
  35. Which of the following data sampling methods involves dividing a population into subgroups by similar characteristics?
  36. Which of the following activities occurs during the ETL process?
  37. Which of the following terms best describes a non-typical data point that is far away from the central data distribution or deviates from the general trend?
  38. A data analyst has received a data set that contains actual and projected sales for the fourth quarter of 2019. Which of the following statistical methods shoul ...
  39. A data profiling rule checks the quality of all email addresses in a database. The rule returns a value with the number of email addresses that conformed to the ...
  40. A data engineer is creating a database field to capture whether a customer likes vanilla ice cream. Which of the following data types is the best to capture thi ...
  41. A database administrator is required to mask certain table columns containing PII in order to comply with the company privacy policy. Which of the following are ...
  42. A sales manager requested a report that contains the first name, last name, and phone number of all of the company’s customers and employees. The data engineer ...
  43. A data analyst is cleaning the following data set... The analyst produces the following version... Which of the following best explains why the analyst cleane ...
  44. A data analyst is considering moving PHI to a cloud server. Which of the following should the data analyst most likely be concerned with when determining where ...
  45. A membership organization wants to determine whether renewals have declined in specific regions over the past three years. Which of the following types of analy ...
  46. Under which of the following circumstances should the null hypothesis be accepted when α = 0.05?
  47. A retail company found discrepancies in its product inventory data, with some items having negative quantities. Which of the following is the most appropriate a ...
  48. Which of the following data file types is supported by a database that provides content for a multimedia website?
  49. Which of the following data types is represented in the values in the RefNo column?
  50. A data set was recorded using multimedia technology. Which of the following is a necessary step on the way to interpretation?
  51. A junior analyst with a relational database system needs to maintain the relations between the data using a schema of the relations. Which of the following best ...
  52. A data analyst is creating a high-level report for the Chief Executive Officer. Which of the following data would most likely be included in the report?
  53. A data analyst created a dashboard with confidential corporate information and wants to distribute the dashboard to select corporate officers. Which of the foll ...
  54. A stakeholder wants to see daily sales targets organized in a dashboard by country, state, city, and ZIP Code. Which of the following delivery considerations mu ...
  55. A database administrator needs to ensure only approved users can access specific database tables to perform financial functions. Which of the following is the b ...
  56. A healthcare data analyst notices that one data set in the column for Blood_Pressure contains several outliers that need to be replaced with meaningful values. ...
  57. Which of the following aggregate functions are suitable for retrieving the total quantity sold by each employee? (Select two).
  58. An analyst is working on a visual that shows the performance of sales by quarter for the last two years. Which of the following visuals should the analyst use t ...
  59. Which of the following types of analysis would be best for an analyst to use to examine the relationships between authors who cited other authors in a library o ...
  60. An organization wants to evaluate whether project activities are within the set projections and in line to meet the desired project targets. Which of the follow ...
  61. Which of the following database types is the best to use for transactional SQL?
  62. A data analyst is selecting charts to include in a report. Which of the following is the most important in selecting appropriate charts?
  63. Which of the following technologies would be best suited for creating a multiple linear regression model?
  64. Which of the following is the best reason for cleansing the data?
  65. Which of the following is the best reason for cleansing the data?
  66. Which of the following functions best describes adding new data based on combining the values in other separate columns?
  67. A database consists of one fact table that is composed of multiple dimensions. Each dimension is represented by a denormalized table. This structure is an examp ...
  68. Which of the following should an analyst do to best summarize the data on a data set?
  69. Which of the following data types would most likely represent multidimensional data?
  70. Which of the following dashboard elements should the analyst consider first to satisfy this request?
  71. An analyst is developing a dashboard for a company's managment team. the managment team wants to see insghts related to revenue, expenses, and profitability ove ...
  72. An analyst is developing a dashboard for a company's management team. The management team wants to see insights related to revenue, expenses, and profitability ...
  73. Which of the following is an example of a structured data type?
  74. Which of the following best describes the data quality issue?
  75. Which of the following is the best reason to use database views instead of tables?
  76. Which of the following statistical methods should a data analyst most likely use when extrapolating from a data set with multiple variables?
  77. Which of the following activities is most likely performed during data preparation in the ETL process?
  78. Which of the following should the analyst and client do first to create the report?
  79. An analyst is creating a report to show a trend analysis of sales for a national company, but the only information received was based on region, vendor, and sal ...
  80. A data analyst is evaluating a data set to see the width of a variable. Which of the following statistical methods is appropriate?
  81. A reporting analyst needs to create a report that refreshes automatically and is accessible to the entire sales organization. Which of the following tools is th ...
  82. Which of the following best describes a 95% confidence interval?
  83. A data analyst needs to determine which size of shirt is likely to be the most popular at a store. Shirts come in small, medium, and large sizes. Which of the f ...
  84. A client has requested an analysis of all pet care items purchased by current customers and their social media connections in the past 12 months. Which of the f ...
  85. A data analyst wants to use data manipulation to store newly acquired data. Which of the following techniques should the analyst use?
  86. A data analyst needs to determine the most common number of minutes users spend on a company's website. Which of the following statistical measures should be ap ...
  87. An analyst needs to know what data an organization possesses. Which of the following is the best document for the analyst to consult?
  88. Which of the following are the first steps a company should take after discovering a data breach? (Select two).
  89. Which of the following are the first steps a company should take after discovering a data breach? (Select two).
  90. Which of the following data sampling methods involves dividing a population into subgroups by similar characteristics?
  91. Which of the following activities occurs during the ETL process?
  92. Which of the following terms best describes a non-typical data point that is far away from the central data distribution or deviates from the general trend?
  93. A data analyst has received a data set that contains actual and projected sales for the fourth quarter of 2019. Which of the following statistical methods shoul ...
  94. A data profiling rule checks the quality of all email addresses in a database. The rule returns a value with the number of email addresses that conformed to the ...
  95. A data engineer is creating a database field to capture whether a customer likes vanilla ice cream. Which of the following data types is the best to capture thi ...
  96. A database administrator is required to mask certain table columns containing PII in order to comply with the company privacy policy. Which of the following are ...
  97. A sales manager requested a report that contains the first name, last name, and phone number of all of the company’s customers and employees. The data engineer ...
  98. A data analyst is cleaning the following data set... The analyst produces the following version... Which of the following best explains why the analyst cleane ...
  99. A data analyst is considering moving PHI to a cloud server. Which of the following should the data analyst most likely be concerned with when determining where ...
  100. A membership organization wants to determine whether renewals have declined in specific regions over the past three years. Which of the following types of analy ...
  101. Under which of the following circumstances should the null hypothesis be accepted when α = 0.05?
  102. A retail company found discrepancies in its product inventory data, with some items having negative quantities. Which of the following is the most appropriate a ...
  103. Which of the following data file types is supported by a database that provides content for a multimedia website?
  104. Which of the following data types is represented in the values in the RefNo column?
  105. A data set was recorded using multimedia technology. Which of the following is a necessary step on the way to interpretation?
  106. A junior analyst with a relational database system needs to maintain the relations between the data using a schema of the relations. Which of the following best ...
  107. A data analyst is creating a high-level report for the Chief Executive Officer. Which of the following data would most likely be included in the report?
  108. A data analyst created a dashboard with confidential corporate information and wants to distribute the dashboard to select corporate officers. Which of the foll ...
  109. A stakeholder wants to see daily sales targets organized in a dashboard by country, state, city, and ZIP Code. Which of the following delivery considerations mu ...
  110. A database administrator needs to ensure only approved users can access specific database tables to perform financial functions. Which of the following is the b ...
  111. A healthcare data analyst notices that one data set in the column for Blood_Pressure contains several outliers that need to be replaced with meaningful values. ...
  112. An analyst conducted a preliminary analysis for a data set and identified several patterns and anomalies. Which of the following analysis techniques did the ana ...
  113. An analyst needs to join two data sets that compare vehicle weights. One data set is in pounds, and the other has various units of measure. Which of the followi ...
  114. Which of the following is an object associated with a table that sorts and stores table row data in a key-value pair?
  115. Which of the following should an analyst use to determine the relationship between the years of schooling and amount of income earned?
  116. A research analyst collects ten data points from 1,000 specimens. The analyst will not need any additional data to complete the analysis and will not need to re ...
  117. Which of the following best describes the granularity of a table?
  118. A data analyst who works for a government agency is required to obtain the average income of citizens. The list of citizens is given in the following table: A ...
  119. Which of the following best describes standard deviation?
  120. An analyst is currently working on a ticket for revamping a company-wide dashboard that has been in use for five years. Which of the following should be the fir ...
  121. Which of the following defines the policies and procedures for managing the master data?
  122. Which of the following policies is included in a data user requirement guideline?
  123. Which of the following components need to be added to ensure the report is point-in-time and static? (Select two).
  124. Which of the following components need to be added to ensure the report is point-in-time and static? (Select two).
  125. A client wants a new report that will be automatically emailed to all global sales teams on a weekly basis. Each sales team must be able to view the sales for i ...
  126. An analyst created a report showing a high-level summary of the business performance for the year. Which of the following audiences is this report most likely f ...
  127. Which of the following terms best describes a situation in which a rating scale does not conform to previously agreed upon requirements?
  128. Which of the following analysis techniques is an unsupervised data mining process?
  129. Which of the following types of statistical analysis is the most appropriate to see the change in mortgage payments with changes in interest rates?
  130. Which of the following is a data collection method used to gain firsthand knowledge in a natural social setting that is being investigated?
  131. A data analyst needs to observe the relationship between two numeric variables and identify the clustering pattern as well as the outliers. Which of the followi ...
  132. Which of the following is the best way to show a static number's percentage totaling 100%?
  133. Which of the following data processing systems should be adopted to support a real-time, high-volume, and high-frequency data stream ?