DA0-001 Exam Questions
548 real DA0-001 exam questions with expert-verified answers and explanations. Page 3 of 11.
- Question #102Data Analysis
Which one of the following is a measure of dispersion?
Descriptive statisticsMeasures of dispersionVariance - Question #103Data Concepts and Environments
Which one of the following in NOT a common data integration tool?
Data integrationETLELTAPIs - Question #104Data Concepts and Environments
Which one of the following is a common data warehouse schema?
Data WarehouseSchemaSnowflake SchemaData Modeling - Question #105Data Governance, Quality, and Controls
What would be an example of an acceptable form of primary identification for the Data+ exam?
Exam administrationIdentification requirementsCompTIA policiesCertification integrity - Question #106Data Analysis
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?
Statistical softwareData analysis toolsMinitab - Question #107Data Concepts and Environments
What SQL command is used to delete an entire table from a database?
SQLDDLDatabase managementTable operations - Question #108Data Analysis
Which one of the following programming languages is specifically designed for use in analytics applications?
Programming languagesR languageAnalytics toolsStatistical programming - Question #109Data Governance, Quality, and Controls
What role in a data governance is typically responsible for day-to-day oversight of data use?
data governancedata stewarddata rolesdata oversight - Question #110Data Governance, Quality, and Controls
What category of data stewardship work is focused on ensuring that the organization respects the wishes of data subjects?
Data privacyData stewardshipData subjects' rightsData governance - Question #111Data Concepts and Environments
You are working with a dataset and need to swap the values in rows with those in columns. What action do you need to perform?
Data manipulationTranspositionDataset operationsData transformation - Question #112Data Analysis
When analyzing the values of two variables, you decide to convert both variables so they are on a scale of 0 to 1. What term describes this action?
NormalizationData PreprocessingData Transformation - Question #113Data Analysis
Taylor wants to investigate how manufacturing, marketing, and sales expenditures impact overall profitability for her company. Which of the following systems is the most appropriat...
Data WarehousingBusiness IntelligenceAnalytical SystemsData Architecture - Question #114Data Concepts and Environments
Emma is working in a data warehouse and finds a finance fact table links to an organization dimension, which in turn links to a currency dimension that not linked to the fact table...
Data Warehouse DesignSnowflake SchemaFact TablesDimension Tables - Question #115Data Concepts and Environments
Encryption is a mechanism for protecting data. When should encryption be applied to data? Choose the best answer.
EncryptionData SecurityData ProtectionData states - Question #116Data Concepts and Environments
What subset of Structured Query Language (SQL) is used to add, remove, modify, or retrieve the information stored within a relational database?
SQLDMLRelational DatabasesDatabase Operations - Question #117Data Governance, Quality, and Controls
Which of the following roles is responsible for ensuring an organization's data quality, security, privacy, and regulatory compliance?
Data stewardshipData governance rolesData qualityRegulatory compliance - Question #118Data Concepts and Environments
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 b...
Statistical conceptsPopulation and sampleData collection methods - Question #119Data Analysis
Mario works with a group of R programmers tasked with copying data from an accounting system into a data warehouse. In what phase are the group's R skills most relevant?
ETLData TransformationR ProgrammingData Warehousing - Question #120Data Analysis
You would like to measure how well an organization is achieving its goals. What type of analysis should you perform?
Performance analysisOrganizational goalsBusiness analysisData analysis types - Question #121Data Analysis
Which one of the following would not normally be considered a summary statistic?
Summary statisticsDescriptive statisticsZ-score - Question #122Data Analysis
What analytics suite is offered by Microsoft and directly integrates with SQL Server Databases?
Power BIBusiness Intelligence ToolsData IntegrationMicrosoft Technologies - Question #123Data Analysis
You should always choose the analytics tool that is most appropriate for any given situation, even if that means acquiring a new tool.
Analytics toolsTool selectionBusiness considerationsData analysis strategy - Question #124Data Analysis
What R package makes it easy to work with dates?
R programmingDate-time dataData manipulationLubridate package - Question #125Data Concepts and Environments
You have two databases tables that you would like to join together using a foreign key relationship. What term best describes this action?
Database operationsForeign keysData mergingRelational databases - Question #126Data Concepts and Environments
Which one of the following values will appear first if they are sorted in descending order?
SortingDescending orderAlphabetical sorting - Question #127Data Concepts and Environments
Which one the following is not considered an aggregate function?
SQLAggregate FunctionsDatabase Concepts - Question #128Data Concepts and Environments
You are working with a dataset and want to change the names of categories that you used for different types of books. What term best describes this action?
Data manipulationData recordingData entryCategorization - Question #129Data Analysis
Joseph is interpreting a left skewed distribution of test scores. Joe scored at the mean, Alfonso scored at the median, and gaby scored and the end of the tail. Who had the highest...
Skewed distributionMeasures of central tendencyStatistical concepts - Question #130Data Governance, Quality, and Controls
Kelly wants to get feedback on the final draft of a strategic report that has taken her six months to develop. What can she do to get prevent confusion as see seeks feedback before...
Document managementProfessional communicationDrafting reportsFeedback process - Question #131Data Concepts and Environments
The sample customers table below is an example of which description of data?
Structured dataData typesData organization - Question #132Data Analysis
An analyst binds a dashboard item to the data source shown in Exhibit 1. The analyst applies processing that results in the output shown in Exhibit 2. Which of the following statem...
Data dimensionsData processingCategorical dataDashboard concepts - Question #133Data Analysis
A data analyst evaluates the data below. The analyst must present the cloud coverage percentage using the following scale: 0-33%: mostly sunny 34-66%: partly cloudy 67-100%: mostly...
Data recodingData manipulationData transformationCategorization - Question #134Data Analysis
An analyst performs a random survey at an entertainment event. The analyst gathers the ages for each survey participant: 32, 16, 81, 17, 50, 93, 24, 10, 67, 42, 89, 15, 76, 29, 33,...
Descriptive StatisticsRangeData analysisMin/Max values - Question #135Data Governance, Quality, and Controls
Which of the following methods is used to permanently replace sensitive information with symbols or random characters?
Data MaskingData SecurityData PrivacySensitive Information - Question #136Data Analysis
A hypothesis test sometimes rejects the null hypothesis even if the true value of the population parameter is the same as the value in the null hypothesis. This type of result is k...
Hypothesis TestingType I ErrorStatistical InferenceNull Hypothesis - Question #137Data Analysis
The sales of a grocery store had an average of $8,000 per day. The store introduced several advertising campaigns in order to increase sales. To determine whether the advertising c...
Hypothesis TestingNull HypothesisAlternative HypothesisPopulation Mean - Question #139Data Analysis
Given the diagram below. Which of the following types of sampling is depicted in the image?
Sampling methodsSystematic samplingData collection - Question #140Data Governance, Quality, and Controls
A data analyst has a set with more than 40,000 rows in the sample schema below: The analyst would like to create one column that contains the customers' birth dates. Which of the f...
Data QualityData IntegrityData TransformationData Dimensions - Question #141Data Analysis
Given the table below. Which of the following boxes indicates that a Type Il error has occurred?
Hypothesis TestingType II ErrorStatistical ErrorsNull Hypothesis - Question #142Data Concepts and Environments
Which of the thing is the correct ion for a tab-delimited spre file?
File FormatsDelimited FilesData StorageText Files - Question #143Data Governance, Quality, and Controls
A financial institution is reporting on sales performance to a company at the account level. Due to the sensitive nature of the government the does it with, some account informatio...
Data MaskingData PrivacyPIIData Governance - Question #144Data Analysis
Which of the following is an example of a strategy to reduce statistical errors?
Statistical errorsSample sizeSamplingData analysis strategies - Question #145Visualization
A data analyst needs to create a data visualization that aids in the cumulative impact of sequentially introduced values that are positive or negative. Which of the following data...
Data visualizationChart typesScatter plotCumulative analysis - Question #146Visualization
A data analyst is developing a dashboard to track and monitor metrics. Which of the following best practices should be taken into during the FIRST implement process?
Dashboard developmentBest practicesData visualizationProject planning - Question #147Data Concepts and Environments
A company derives proprietary leads from monthly sales calls and sends them to dealers through a connection that matches the correct leads to the correct dealers. Which of the foll...
APIData exchangeSystem integration - Question #149Data Mining
Which of the following is an example of a data-mining ETL tool?
ETLSSISData IntegrationData Tools - Question #150Data Analysis
An analyst has conducted a review of business questions. Which of the following should the analyst do next to conduct an analysis?
Data Analysis ProcessData RequirementsData SourcingBusiness Understanding - Question #151Data Analysis
A data analyst is compiling a report that a Chief Executive Officer needs for an impromptu meeting. The report should include information on the previous day's performance. Which o...
Report typesAd hoc reportsBusiness reportingData analyst tasks - Question #152Data Analysis
Which of the following tools would be best to use to calculate the interquartile range, median, mean, and standard deviation of a column in a table that has 5,000,000 rows?
Statistical computingData analysis toolsLarge datasetsR programming - Question #153Data Concepts and Environments
Which of the following data acquisition concepts is the most appropriate for determining the quality of a company's product?
Data AcquisitionSurveysProduct Quality AssessmentData Collection Methods