DA0-001 Exam Questions
548 real DA0-001 exam questions with expert-verified answers and explanations. Page 5 of 11.
- Question #205Data Analysis
Which of the following best describes the law of large numbers?
Law of Large NumbersStatisticsSamplingPopulation mean - Question #206Data Analysis
A C-suite executive would like to monitor KPIs for each department on a monthly basis. Which of the following explains why the executive wants to conduct this performance analysis?
KPIsPerformance MonitoringBusiness ObjectivesGoal Tracking - Question #207Data Governance, Quality, and Controls
An analyst is working on a project for a director. During this process, the analyst pulled the data, created summarized tables and graphs with descriptions, created a report summar...
Report qualityData reporting workflowQuality assurance - Question #208Data Governance, Quality, and Controls
A collections manager has a team calling customers who are past due on their accounts in an attempt to collect payments. The manager receives the call list in the form of a printed...
Data currencyReporting frequencyBusiness process improvementData quality - Question #209Data Concepts and Environments
A data analyst is developing a data dictionary that aligns with a company's data management processes and policies. Which of the following best describes what should be included in...
Data DictionaryMetadataData Management - Question #210Data Mining
After completing web scraping, which of the following file formats needs to be parsed?
Web scrapingHTMLData parsingData extraction - Question #211Data Analysis
A data analyst received the information in the table below from a recently completed marketing campaign: Which of the following is the total order conversion rate?
Conversion RateMarketing AnalyticsData MetricsKPIs - Question #212Data Concepts and Environments
An analyst reviews the following table: Which of the following data types is represented in the values in the RefNo column?
Data TypesDatabase ConceptsData ClassificationColumn Properties - Question #213Data Concepts and Environments
Given the information in the following tables: Online transactions: In-store transactions: Which of the following describes merging these tables to create a master file that includ...
Data consolidationData integrationData mergingData processing - Question #214Data Governance, Quality, and Controls
Given the image below: The data should be cleaned because of the presence of:
OutliersData cleaningData qualityData preprocessing - Question #215Data Governance, Quality, and Controls
Several analysts are working simultaneously to compile a company's annual report and meet a tight deadline. Since each analyst is making changes, the analysts are concerned that th...
Version controlData collaborationData integrityDocument management - Question #216Data Governance, Quality, and Controls
Data was previously stored in the following relational tables: A database architect changes the relational database structure to include an additional lookup table, which includes...
Database designLookup tablesData redundancyMaster Data Management (MDM) - Question #217Data Concepts and Environments
Which of the following BEST describes the difference between discrete and continuous values?
Discrete valuesContinuous valuesData typesData characteristics - Question #218Data Concepts and Environments
A survey asks participants to rate a company on a scale of one to ten. Which of the following BEST describes the rating variable?
Data typesVariable classificationOrdinal data - Question #219Visualization
A director who is responsible for reporting performance to executives has requested a dashboard for C-suite users who are not satisfied with the current multipage printed reports....
Dashboard designRequirements gatheringStakeholder managementUser experience - Question #220Data Analysis
Which of the following statistical methods can be used to measure changes over time?
Statistical methodsHypothesis testingDependent t-testChanges over time - Question #221Data Concepts and Environments
A feature can take certain values (A, B, C, D, E, and F) and represents a grade of students from a college. Which of the following variables does this describe?
Data typesVariablesOrdinal dataCategorical data - Question #222Data Concepts and Environments
Given the image below: Which of the following data schemas is portrayed?
Data schemaStar schemaDimensional modeling - Question #223Data Governance, Quality, and Controls
Which of the following is a best practice when updating a legacy data source?
Data MigrationData DocumentationData GovernanceBest Practices - Question #224Data Concepts and Environments
Which of the following BEST defines a data outlier?
data outlierdata anomalystatistical concepts - Question #225Data Governance, Quality, and Controls
An analyst needs to create a dashboard with three tiers of information: management, general public (internal users), and external stakeholders. The management team should be able t...
Dashboard deliveryAccess controlUser permissionsData security - Question #227Data Governance, Quality, and Controls
An analyst needs to modify an existing dashboard because data is often out of date. Which of the following is the BEST way for the analyst to help resolve the issue?
data refreshreal-time datadata currencydashboard updates - Question #228Data Governance, Quality, and Controls
A data analyst has just finished cleansing a database table and is now ready to update the master. However, the analyst must first check to ensure all the work is accurate. Which o...
Data QualityData TransformationData CleansingData Validation - Question #229Data Concepts and Environments
Which of the following data formats are examples of unstructured data? (Choose two.)
Unstructured dataData formatsData types - Question #230Data Analysis
A data analyst is preparing a presentation for the company's board of directors. The presentation will not contain any confidential information and will only be provided to the boa...
Presentation skillsProfessional communicationBusiness etiquetteCorporate branding - Question #231Data Governance, Quality, and Controls
Given the following table: Which of the following explains why this data set needs to be cleansed?
Data cleansingRedundant dataData quality - Question #232Data Governance, Quality, and Controls
An analyst is summarizing the results from a recently completed survey. The results have been validated, but the analyst notices a few rows of data are missing at the bottom. For w...
Data qualityData completenessData issues - Question #233Data Concepts and Environments
Which of the following data analytics tools would be BEST to retrieve data from a relational database management system?
SQLRelational DatabasesData RetrievalDatabase Query Language - Question #234Data Analysis
A data analyst is reviewing the results of a survey. Respondents used the terms "avg," "average," and "avg." throughout the survey in a response for the word "average." Because of...
Data qualityData consistencyData cleaningText standardization - Question #235Data Concepts and Environments
A business analyst reviews the following text: txt = "I have registered for a certification exam and will take it within a couple of months. I need to work hard to pass the exam wi...
String operationsText processingData preparation - Question #236Data Concepts and Environments
A customer's telephone number is in the format 123-456-7890. Which of the following data types is used for the phone number?
data typestext datadata representationphone number formatting - Question #237Data Concepts and Environments
A team is planning to automate daily reporting for a company. Prior to this rollout, the team wants to determine how to ensure the data is refreshed at approximately the same time...
Data AutomationData RefreshData WarehousingAutomated Scheduling - Question #238Data Concepts and Environments
Which of the following describes a formal process for acquiring data from websites?
Web scrapingData acquisitionData sourcesData collection - Question #239Data Analysis
A data analyst needs to survey customers about their preferences for various types of soda. Which of the following sampling methods should the analyst use to collect the survey dat...
Sampling methodsData collectionStatistical samplingSimple random sampling - Question #240Data Governance, Quality, and Controls
Given the following data set: Which of the following steps would be MOST appropriate to cleanse the data set?
Data CleansingData QualityDuplicate DataData Preparation - Question #241Data Analysis
An analyst notices changes in sales ratios when analyzing a quarterly report. Which of the following is the analyst conducting?
Trend analysisData analysis techniquesBusiness metricsReporting - Question #242Data Concepts and Environments
Which of the following is the BEST example of unstructured data?
Unstructured DataData TypesData FormatsAudio Files - Question #243Data Analysis
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 should the analyst use to...
statistical methodsmeasure of dispersionvariancedata analysis - Question #244Data Analysis
A data analyst has received a list of customer names in alphabetical order that needs to instead be put in order by transaction date. Which of the following data manipulation techn...
Data manipulationSorting dataData orderingData preparation - Question #245Data Analysis
A data analyst has been asked to find the mean, median, and mode of the distribution in the data shown below: Which of the following is the correct answer?
MeanMedianModeDescriptive Statistics - Question #246Data Concepts and Environments
Which of the following is the correct extension for a tab-delimited spreadsheet file?
File formatsData filesTab-delimitedTSV - Question #247Data Analysis
A data analyst needs to analyze a sales data set to identify the sales representatives who are selling the most units per month. Which of the following should the analyst perform?
Performance analysisSales analyticsBusiness metricsData analysis types - Question #248Data Concepts and Environments
Which of the following concepts should be applied if a data set with 40 fields needs to be pared down to 20 fields and contains similar data across multiple fields?
Data consolidationData reductionData preprocessingData redundancy - Question #249Data Governance, Quality, and Controls
Which of the following is the BEST description of the term "data governance"?
data governancedata integritydata securitydata availability - Question #250Data Concepts and Environments
In comparison to other data types, which of the following can hold a mix of numbers and letters?
Data typesAlphanumeric dataBasic data concepts - Question #251Data Governance, Quality, and Controls
Company A recently merged with Company B and will be reporting first quarter numbers soon. Prior to the release, an analyst wants to ensure the data was accurately blended together...
Data validationData quality assuranceData integrationData reconciliation - Question #252Data Analysis
Given the following numbers: 7, 2, 3, 3, 5 Which of the following is the mean?
MeanAveragesDescriptive StatisticsStatistical Measures - Question #253Data Analysis
A data analyst has been asked to manipulate the data in the table below by first applying a DISTINCT function, and then applying a SUM function, to get the total product cost for a...
Data ManipulationSQL FunctionsDISTINCTSUM - Question #254Visualization
A market research firm has data sets based on surveys. A data analyst wants to know if any outliers are present in a data set. Which of the following would be the BEST method to ex...
Outlier detectionData visualizationNumerical dataExploratory data analysis - Question #255Visualization
A staff member is analyzing open-ended customer comments from an email survey. Which of the following is the EASIEST way to visualize the data?
Word cloudText visualizationOpen-ended commentsVisualization techniques