DA0-001 Exam Questions
548 real DA0-001 exam questions with expert-verified answers and explanations. Page 9 of 11.
- Question #406Data Analysis
An analyst wants to test the association between the number of doors in a car and the number of gears in the car. Which of the following is the best test to use?
Statistical testsChi-squared testCategorical dataAssociation - Question #407Data Analysis
An analyst is compiling a series of reports for the new executive board to review. Which of the following elements provides a snapshot of what is contained in the reports for the e...
Report componentsExecutive summaryData insightsBusiness reporting - Question #408Data Analysis
An analyst wants to determine whether a relationship between an individual's age and voting preferences exists. Which of the following is the best statistical method for the analys...
Chi-squared testHypothesis testingCategorical data analysisAssociation between variables - Question #409Data Concepts and Environments
A data architect is designing a data solution for a retail clothing store chain. Each store has a database that tracks sales transactions. The data architect needs to create a summ...
Database designUnique constraintData integrityRelational databases - Question #410Data Analysis
Consider two different datasets, one with gas prices and the other with food prices. Which of the following measures is most affected by outliers?
OutliersMeasures of Central TendencyMeanMedian - Question #411Visualization
A data analyst was asked to create a visual representation of sales for the first quarter of 2020. Which of the following visualizations should be used when a time element is prese...
Data VisualizationLine ChartsTime Series Data - Question #412Data Analysis
Which of the following formulas correctly illustrates an IF statement?
IF statementSpreadsheet formulaLogic functionSyntax - Question #413Data Analysis
A user wants a dynamic report that presents a moving average of sales throughout the company's history and also for select periods. Which of the following attributes should the rep...
Moving averageReport designDate rangeBusiness analytics - Question #414Data Analysis
A user needs a live report that always displays the current week performance and can also show the past weeks, months, and years performance for all time, if needed. Which of the f...
Report requirementsTime-based reportingDate filteringPerformance reporting - Question #415Data Analysis
A sales director wants a report that provides a view into company sales over multiple quarters in order to gain a better understanding of trends. Which of the following report type...
Report typesTrend analysisBusiness intelligenceAnalytical reporting - Question #416Data Concepts and Environments
Which of the following activities is most likely performed during data preparation in the ETL process?
ETL processData preparationData cleaningData transformation - Question #417Data Governance, Quality, and Controls
Which of the following data quality features can be added to a technology platform?
Data qualityData integrationETLData platform - Question #418Data Analysis
A membership organization wants to determine whether renewals have declined in specific regions over the past three years. Which of the following types of analysis would be best fo...
Trend analysisData analysis typesHistorical dataBusiness analytics - Question #419Data Analysis
A manager would like to see a report that details lost deals for the week. Which of the following report delivery methods best supports this requirement?
ReportingBusiness IntelligenceOperational ReportsReport Delivery Methods - Question #420Data Analysis
Given the following data sets: Which of the following data manipulation techniques was performed?
Data manipulationData transformationTranspose - Question #421Data Governance, Quality, and Controls
After returning from a vacation, a sales manager finds multiple hard copies of the prior week's sales report on a desk with the same date but different information. Which of the fo...
Version controlData integrityData qualityDocument management - Question #422Data Concepts and Environments
Which of the following data types is the "number of packages delivered" an example of?
data typesdiscrete dataquantitative data - Question #423Data Concepts and Environments
Which of the following is a key feature of a temporary table?
Temporary tablesDatabase conceptsSQL - Question #424Data Analysis
An intern needs to compile a report that will be used in a customer proposal at the end of the month. Which of the following best describes the type of report the intern should use...
Report typesStatic reportsBusiness reportingData reporting - Question #425Data Concepts and Environments
Which of the following is an example of a structured data type?
Structured dataData typesSQL databaseData organization - Question #426Data Governance, Quality, and Controls
An analyst is working with a data set that contains information regarding refugee status, income, identification numbers, place of residence, and employment status. The analyst nee...
Data maskingData privacyData securitySensitive data - Question #427Data Concepts and Environments
An analyst wrote the following code: Which of the following formats did the analyst use?
Data FormatsXMLData Representation - Question #428Data Analysis
A healthcare data analyst is working with data sets containing patient information, medical records, and metrics. The data analyst needs to combine two data sets that have a common...
Data manipulationData integrationMerge operationsCommon key - Question #429Data Concepts and Environments
Which of the following is a characteristic of structured data?
structured datadata characteristicsdata types - Question #430Data Concepts and Environments
Which of the following best describes structured data?
structured datadata typesdata organizationdata querying - Question #431Data Analysis
A college student has taken four exams in a class. The student hopes to finish the class with a weighted average of at least 90% to get an A. Given the following: With one test rem...
Weighted averageCalculationQuantitative reasoningDescriptive statistics - Question #432Data Concepts and Environments
Which of the following relationships is necessary to define a third table called a "joining table" in relational databases?
Relational databasesMany-to-many relationshipsJoining tablesDatabase design - Question #433Data Analysis
An analyst is conducting a survey to measure height. Which of the following is the most likely to decrease as the analyst collects more survey responses?
Confidence IntervalSample SizeStatistical InferenceData Collection - Question #434Data Analysis
An analyst is reviewing a company document to identify why sales have declined over multiple sales quarters. Which of the following analysis techniques should the analyst use?
Trend analysisData analysis techniquesBusiness performance - Question #435Data Analysis
A field marketing team needs to assess the relationship between gender and volume of sales. The team provided an analyst with the data to be modified. The data sets are shown below...
Data recodingData manipulationData preparationCategorical data - Question #436Data Analysis
A data analyst added some missing data to a list of observations, since only a small amount of the data was absent. Which of the following actions did the data analyst perform?
Data CleaningMissing DataData ManipulationAppend - Question #437Data Analysis
A director wants a data set that can be used to visualize how various marketing campaigns have performed. The information will be provided by internal and external sources and then...
Data BlendingData IntegrationData PreparationMulti-Source Data - Question #438Data Analysis
An analyst wants to show the population of each district in a city and the associated crime rates. Which of the following describes the appropriate analytical technique that the an...
Descriptive analysisAnalytical techniquesData analysis types - Question #439Data Concepts and Environments
Which of the following should a developer use to interact with data from external resources?
APIExternal data interactionData accessDeveloper tools - Question #440Data Governance, Quality, and Controls
Given the following data table: Which of the following data editing methods is the best to use to make the data usable for analysis?
Data preprocessingMissing dataImputationData quality - Question #441Data Analysis
An analyst is looking at the relationship between age and certain health disparities. Which of the following analysis techniques should the analyst use?
Exploratory Data AnalysisData Analysis TechniquesRelationship Analysis - Question #442Data Analysis
A business analyst has performed the following steps: - Reviewed research questions and business needs. - Identified data needs and how to collect this information. - Scoped the ty...
Data analysis processBusiness requirementsProject scopingData collection planning - Question #443Data Concepts and Environments
A company CRM has more than one million email addresses. The company wants to create a new reduced and simplified table that can be exported in a flat file. Which of the following...
SQLData manipulationDatabase operations - Question #444Visualization
The marketing team has a C-level executive who requires a dashboard that displays real-time sales data and performance metrics. The dashboard needs to be accessible on the executiv...
Dashboard designExecutive reportingMobile accessibilityReal-time data - Question #445Data Concepts and Environments
During an interview, a hiring manager asks an analyst about the analyst's experience using programming languages. The analyst has used HTML, Python, and SQL. Which of the following...
HTMLFront-end DevelopmentWeb TechnologiesProgramming Languages - Question #446Visualization
An analyst is creating a chart that shows the frequencies of values of a variable bucketed into ranges. Which of the following is the most appropriate visual for the analyst to use...
Data visualizationHistogramFrequency distributionChart types - Question #447Data Concepts and Environments
Which of the following data types is most commonly used to store address data?
Data typesString data typeData storageAddress data - Question #448Data Concepts and Environments
Which of the following is a reason to remove duplicate data?
Data cleaningDuplicate dataUnique valuesData manipulation - Question #449Data Analysis
A retail data analyst needs to create a new variable that represents the total purchase amount for each customer. Which of the following data manipulation techniques should the ana...
Derived variablesData manipulationAggregationData transformation - Question #450Data Concepts and Environments
Which of the following is a characteristic of alphanumeric data in a table?
Alphanumeric dataData typesData characteristics - Question #451Data Analysis
A biologist is recording the length of five fish with the following measurements: 5.6in (152mm) 11in (280mm) 3.6in (91mm) 13in (330mm) 4.4in (112mm) Which of the following is the m...
MeanAverageStatistical calculationDescriptive statistics - Question #452Data Governance, Quality, and Controls
An analyst is working to identify trends in a study and finds the data set has a lot of missing values. Which of the following best describes the data quality issue?
Data qualityMissing valuesData completenessData quality dimensions - Question #453Data Governance, Quality, and Controls
A team is working on a quarterly business review deck and needs to ensure the team is always working on the most recent iteration. Which of the following does the deck need?
Version controlDocument managementCollaboration - Question #454Data Concepts and Environments
Given a database with the following fields: - Item_Name - First_Name - Item_Price - Customer_ID Which of the following is the best primary key?
Primary KeyDatabase DesignData ModelingRelational Databases - Question #455Data Analysis
Which of the following statistical methods would be best for an analyst to use to determine if two nominal variables are unrelated?
Chi-squared testNominal variablesStatistical methodsHypothesis testing