DA0-002 Exam Questions
124 real DA0-002 exam questions with expert-verified answers and explanations. Page 2 of 3.
- Question #51Visualization and Reporting
A manager needs a report to be sent by email every Monday for the next six months. Which of the following is the best way to accomplish this task?
Report schedulingAutomated reportingRecurring processesData delivery - Question #52Data Concepts and Environments
A data analyst is creating a forecast for a product line introduced early last year. Which of the following should the analyst use to create projected sales and customer satisfacti...
Data typesNumerical dataOrdinal dataForecasting - Question #53Data Governance
A company wants to limit an employee's access to a production environment. Which of the following access control practices is the best to implement?
Access ControlRole-based Access Control (RBAC)Security PoliciesProduction Environment Access - Question #54Data Concepts and Environments
A data analyst encounters an issue with new software and a code that they are using. The analyst includes print statements in the code to try to identify the issue, without success...
TroubleshootingDebuggingProblem SolvingData Analyst Tools - Question #55Data Acquisition and Preparation
A data analyst receives a new data source that contains employee IDs, job titles, dates of birth, addresses, years of service, and employees' birth months. Which of the following i...
Data RedundancyData InconsistencyData Quality - Question #56Visualization and Reporting
A sales manager wants a dashboard that shows sales aggregated by region and identifies high- volume sales by salesperson per region. Which of the following communication techniques...
DashboardsData VisualizationFilter OptionsInteractive Reporting - Question #57Data Analysis
Before distributing a report, a marketing analyst notices that the total distinct promotional email messages is less than the combined total of emails sent. Which of the following...
Data DiscrepancyData AggregationDuplicate DataMarketing Analytics - Question #58Data Acquisition and Preparation
A data analyst needs to create a combined report that includes information from the following two tables: Which of the following query methods should the analyst use for this task?
SQLData CombiningUnion OperatorQuery Methods - Question #59Data Acquisition and Preparation
Given the following tables: Which of the following is the best option to display output from FirstName and LastName as FullName?
SQLString manipulationData transformationData preparation - Question #60Visualization and Reporting
A manager wants a report that contains the days off for each direct report. The manager needs this report to always be up-to-date with the latest data. Which of the following descr...
Real-time dataReport refreshData timelinessReporting frequency - Question #61Data Acquisition and Preparation
The following SQL code returns an error in the program console: SELECT firstName, lastName, SUM(income) FROM companyRoster SORT BY lastName, income Which of the following changes a...
SQLAggregate FunctionsGROUP BYQuery Syntax - Question #62Data Acquisition and Preparation
Which of the following is the most efficient to use when programming repeatable tasks?
RPAProcess AutomationRepeatable TasksData Efficiency - Question #63Data Concepts and Environments
Which of the following data repositories stores unaltered data?
Data LakeData StorageRaw DataData Repositories - Question #64Data Governance
Which of the following allows a data analyst to send out a spreadsheet containing sensitive information without revealing personal details?
Data PrivacyPIIData RedactionSensitive Data - Question #65Visualization and Reporting
A data analyst needs to identify outliers from a given dataset. Which of the following visualizations is the best way to identify outliers?
Box plotOutliersData visualizationStatistical plots - Question #66Data Acquisition and Preparation
A data analyst is preparing a survey for Paralympic Games athletes. Which of the following should the analyst consider when creating this survey?
Survey designAccessibilityData collectionUser experience - Question #67Data Acquisition and Preparation
The human resources department wants to know the number of employees who earn $125,000 or more. However, the department is concerned about duplicates in the dataset. Given the foll...
SQL QueriesData AggregationDISTINCT KeywordFiltering Data - Question #68Data Governance
Which of the following best explains the purpose of data lineage?
data lineagedata transformationdata traceability - Question #69Visualization and Reporting
A data analyst needs to modify a dashboard that was created by another employee. Upon opening the dashboard, the analyst notices that the information is not loading properly. Which...
Dashboard troubleshootingData source issuesData layer errorsVisualization data connectivity - Question #70Data Analysis
A data analyst wants to use the following tables to find all the customers who have not placed an order: Which of the following SQL statements is the best way to accomplish this ta...
SQLLEFT JOINDatabase queriesRelational databases - Question #71Data Analysis
Given the following dataset: Which of the following is the mode?
descriptive statisticsmodemeasures of central tendencydata characteristics - Question #72Data Acquisition and Preparation
A data analyst calculated the average score per student without making any changes to the following table: Which of the following exploration techniques should the analyst have con...
Data QualityDuplicate DataData PreprocessingExploratory Data Analysis - Question #73Data Analysis
A marketing firm wants to find the average age of its consumers to better promote its products. Given the following dataset: Which of the following is the mean of the consumer ages...
Mean calculationAverageDescriptive statisticsCentral tendency - Question #74Virtualization and cloud computing
Which of the following best represents a type of infrastructure that requires a company to purchase and maintain all of its own servers?
Infrastructure modelsPrivate infrastructureOn-premises serversServer ownership - Question #75Data Governance
A data analyst receives an email from the IT department about renewing the company password, and the analyst follows the password reset link as required. Later in the week, the ana...
Password managementDatabase connectivityAutomated processesCredential management - Question #76Data Acquisition and Preparation
A data analyst receives a flat file that includes dates. The analyst needs to calculate the number of days from the dates on the file to the current date. Which of the following is...
Date handlingData transformationDate functionsData types - Question #77Data Concepts and Environments
Which of the following is a NoSQL database?
NoSQL databasesDatabase typesData storage - Question #78Visualization and Reporting
A data analyst needs to provide a weekly sales report for the Chief Financial Officer. Which of the following delivery methods is the most appropriate?
Reporting best practicesExecutive communicationData deliveryAudience analysis - Question #80Visualization and Reporting
An analyst compiled data on the preferred color of various models of cars over a period of time. Which of the following visualizations is best way to present this information?
Data VisualizationChart TypesStacked ChartsData Presentation - Question #81Data Acquisition and Preparation
Which of the following should a data analyst use to most efficiently gather recently released statistical information from one site?
Data AcquisitionAPIsEfficiencyData Sources - Question #82Data Concepts and Environments
A complex report is being created from a database. Within the database the storage location of the orders, packaging, and logistics details is unclear. The table's attributes names...
Data dictionaryDatabase documentationDatabase schemaData management - Question #83Visualization and Reporting
Which of the following report types is considered the most important in a legal and compliance context?
ReportingComplianceRegulatory requirementsLegal context - Question #84Data Analysis
Giving the following values: 47 59 83 33 51 39 52 Which of the following is the mean?
Mean calculationDescriptive statisticsAveragesCentral tendency - Question #85Visualization and Reporting
Which of the following is the best tool for creating a dynamic dashboard?
Dynamic dashboardsPower BIData visualization toolsBusiness Intelligence - Question #86Data Acquisition and Preparation
Which of the following best describes the semi-structured data that is gathered when web scraping?
Web scrapingSemi-structured dataJSONData formats - Question #87Visualization and Reporting
A report triggers an error that prevents information from being displayed. However, the report was functional before a database upgrade. Which of the following should a data analys...
TroubleshootingDatabase ConnectivityReport ErrorsData Sources - Question #88Data Governance
Which of the following explains the purpose of UAT?
UATSoftware testingRequirements validationQuality assurance - Question #89Visualization and Reporting
A data analyst is generating a custom report for a Chief Executive Officer's executive meeting. Later, the analyst learns that other custom reports will be required for future exec...
Reporting methodsCustom reportsRecurring reportsReport delivery - Question #90Visualization and Reporting
A grocery store wants to view the revenue from the previous year, highlighting individual departments. Which of the following is the most appropriate chart to communicate this info...
Chart typesData visualizationPie chartsReporting - Question #91Data Acquisition and Preparation
A data analyst receives the following sales data for a convenience store: The analyst needs to provide information on the products that contain chocolate. Which of the following Re...
Regular ExpressionsData FilteringText ProcessingData Preparation - Question #92Visualization and Reporting
A manager wants to use the information in a recurring report on incomplete timesheets for the prior month to guide employee outreach. Which of the following report types is the bes...
Report typesBusiness reportingSummary reportsManagerial reporting - Question #93Data Governance
A company has a document that includes the names of key metrics and the standard for how those metrics are calculated company-wide. Which of the following describes this documentat...
Data dictionaryMetadataData governanceData standards - Question #94Visualization and Reporting
A data analyst needs to create and deliver a dashboard that displays the company's financial transactions as they are updated. Which of the following delivery methods should the an...
Dashboard delivery methodsReal-time dataDynamic reportingData updates - Question #95Data Acquisition and Preparation
A data analyst receives a request for the current employee head count and runs the following SQL statement: SELECT COUNT(EMPLOYEE_ID) FROM JOBS The returned head count is higher th...
SQLCOUNT functionDISTINCT keywordData querying - Question #96Data Acquisition and Preparation
Which of the following situations best describes an unclear and inconsistent column definition that can lead to an enabled analysis process?
Data QualityColumn DefinitionData PreparationData Consistency - Question #97Data Acquisition and Preparation
An analyst is developing a form to collect data from clients. Which of the following techniques should the analyst use to best ensure data integrity?
Data integrityData validationData collectionForm design - Question #98Data Acquisition and Preparation
Which of the following data integration concepts should be used if only new data is being added to a table since the previous load?
Data IntegrationDelta LoadIncremental LoadData Loading - Question #99Data Analysis
Which of the following statistical measures is the most suitable and simple measure of the strengthsimple measure of the strength and direction of the linear relationship between p...
Statistical MeasuresCorrelation CoefficientLinear RelationshipsData Analysis Fundamentals - Question #100Data Acquisition and Preparation
An analyst needs to produce a final dataset using the following tables: The expected output should be formatted as follows: | CourseID | SectionNumber | StudentID | FirstName | Las...
Data integrationTable joinsDatabase operationsData manipulation - Question #101Data Concepts and Environments
Which of the following data repositories stores unstructured and structured data?
data repositoriesdata lakestructured dataunstructured data