DA0-002 Exam Questions
124 real DA0-002 exam questions with expert-verified answers and explanations. Page 3 of 3.
- Question #102Data Acquisition and Preparation
A data analyst must combine service calls into low-, medium-, and high-priority levels in order to analyze organizational responses. Which of the following techniques should the an...
BinningData PreparationCategorizationData Transformation - Question #103Data Acquisition and Preparation
A data analyst learns that a report detailing employee sales is reflecting sales only for the current month. Which of the following is the most likely cause?
SQL errorsData filteringReport accuracy - Question #104Visualization and Reporting
An analyst is building a reporting deck. The deck must include tracking and visualizing metrics and row-level security. Which of the following actions should the analyst take after...
ReportingData VisualizationProject WorkflowRow-Level Security - Question #105Data Analysis
A data analyst is working on an initial analysis of the dataset in the following table: Which of the following issues should the analyst flag in the data report?
Outlier detectionData qualityExploratory data analysisData anomaly - Question #106Visualization and Reporting
A company's analytics manager wants all reports to be delivered once every seven days. Which of the following is the best delivery method?
Report deliveryReport schedulingRecurring reportsAnalytics reporting - Question #107Data Governance
A data breach occurs at a company. Which of the following actions should be taken?
Data breachIncident responseRegulatory complianceData governance - Question #108Data Concepts and Environments
Which of the following data repositories should a company use when structured data about the whole company needs to be stored in a predefined data structure?
Data warehouseData repositoriesStructured dataData architecture - Question #109Data Acquisition and Preparation
A data analyst is evaluating all conditions in a query. Which of the following is the best logical function to accomplish this task?
logical operatorsSQL queriesquery conditionsboolean logic - Question #110Data Concepts and Environments
An analyst is recording the following financial transaction data with a vendor: 59.99, 49.50, 70.49 Which of the following data types is the best way to record this information?
Data typesFinancial dataData classification - Question #111Visualization and Reporting
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?
Executive reportingReporting audienceBusiness metricsData granularity - Question #112Data Concepts and Environments
Which of the following is a reason for sampling?
SamplingPopulationData collectionStatistical inference - Question #113Visualization and Reporting
A data analyst is creating a dashboard to monitor and manage processes on a daily, weekly, and quarterly basis. Which of the following types of dashboards is the best for this purp...
DashboardsDashboard TypesData MonitoringProcess Management - Question #114Data Concepts and Environments
Which of the following is a flat file data format?
Data formatsFlat filesCSV - Question #115Visualization and Reporting
Which of the following is business intelligence software?
Business IntelligenceBI softwareData visualization toolsTableau - Question #116Data Acquisition and Preparation
Which of the following best describes an assessment a data analyst would use to validate that the number of records in a dataset matches the expected results?
Data validationData qualityTesting methodologiesUnit testing - Question #117Visualization and Reporting
A data company needs a visualization that shows the availability zones from the last ten years and any future availability zones that the company will be using in the next five yea...
Data visualizationMapsAvailability zonesVisualization types - Question #118Virtualization and cloud computing
Which of the following best describes the method used to combine files, software, and libraries for use on various operating systems and environments?
ContainerizationApplication deploymentPortabilitySoftware environments - Question #119Visualization and Reporting
A recent server migration applied an update to dataset naming conventions. Multiple users are now reporting stale information in an existing dashboard. The date in the dataset conf...
Dashboard troubleshootingData currencyDataset linkingData migration impact - Question #120Data Acquisition and Preparation
A developer builds an online survey that requires all questions to have an answer. Which of the following inconsistencies does this setting prevent?
Data validationMissing valuesData qualityData integrity - Question #121Data Acquisition and Preparation
A data analyst is gathering data from multiple tables in a database. The analyst needs certain columns from each table. Which of the following is the best method to accomplish this...
SQL JoinsRelational DatabasesData QueryingData Integration - Question #122Visualization and Reporting
A senior manager needs a report that can be generated and accessed at any time. Which of the following delivery methods should a data analyst use?
Self-service reportingReport delivery methodsBusiness intelligenceData accessibility - Question #123Data Acquisition and Preparation
A data analyst is creating a new dataset that involves bringing together the following datasets: Which of the following would be the output if the data analyst does a FULL JOIN?
FULL JOINSQL JOINsData integrationDataset creation - Question #124Data Acquisition and Preparation
Software end users are happy with the quality of product support provided. However, they frequently raise concerns about the long wait time for resolutions. An IT manager wants to...
Data collectionUser feedbackProcess improvementSurveys - Question #125Data Concepts and Environments
Which of the following is the best reason for a company to use a CSV file to share data instead of an Excel file?
CSVFile FormatsData SharingInteroperability