πŸ”

DA0-001 β€” questions

Page 14 of 15 Β· 294 total questions.

Topic 1 Β· Question 263 Β· Select all that apply

An analyst is training a new coworker on the importance of data governance and is focusing on security requirements. Which of the following should the analyst include in the training? (Choose two.)

  • AData masking (correct answer)
  • BData encryption (correct answer)
  • CData parallelism
  • DData inclusiveness
  • EData exclusiveness
  • FData openness
Reveal answer & explanation
Correct answer: A, B

The correct answer is A, B. Option A: Data masking Option B: Data encryption

Explanation

Encryption protects confidentiality by making data unreadable without the appropriate key. This option keeps traffic private / properly secured as required.

Topic 1 Β· Question 264

During a data collection exercise, enumerators collected information from households in town A. However, only data from households in town B is needed for the analysis. Which of the following best describes the type of data that was collected?

  • ARedundant
  • BDuplicate
  • CInvalid (correct answer)
  • DMissing
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Invalid

Topic 1 Β· Question 265

Which of the following terms best describes a situation in which a rating scale does not conform to previously agreed upon requirements?

  • ASpecification mismatch (correct answer)
  • BIncorrect sampling
  • CData corruption
  • DRedundancy
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Specification mismatch This option scales automatically to match demand.

Topic 1 Β· Question 266

Which of the following centralized documents best describes table schema and mapping used in future analyses?

  • ATechnical specification
  • BProject requirements
  • CTerms and conditions
  • DData dictionary (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Data dictionary

Topic 1 Β· Question 267

An analyst compiled a high-level report that includes the following data points: β€’ Total dollars closed for the year β€’ Annual quota/goal β€’ Top 10 customers β€’ Average deal size β€’ Largest deals lost Which of the following groups is the most likely audience for this report?

  • AExternal vendors
  • BGeneral public
  • CLower-level managers
  • DC-suite officers (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: C-suite officers

Topic 1 Β· Question 268

The administrative team granted approval for the development of a dashboard. This dashboard was deployed straight to production. Which of the following should have occurred first?

  • AProof of concept
  • BLoad testing
  • CEnd-user testing (correct answer)
  • DData acquisition
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: End-user testing

Topic 1 Β· Question 269

Which of the following best describes a reason for a corporation to review compliance data integration practices?

  • ADissolution
  • BMerger (correct answer)
  • CBankruptcy
  • DData breach
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Merger

Topic 1 Β· Question 270

Which of the following techniques should an analyst use to analyze a data set to get a snapshot of basic measures of central tendency?

  • AForecasting
  • BTrend analysis
  • CGap analysis
  • DDescriptive statistics (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Descriptive statistics

Topic 1 Β· Question 271

A data analyst is working with a data set and would like to combine two fields into a single field. Which of the following data manipulation techniques should the analyst use?

  • AData merge
  • BTranspose
  • CData append
  • DConcatenation (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Concatenation

Explanation

Network address translation maps addresses between networks and commonly lets private hosts share public connectivity.

Topic 1 Β· Question 272

Which of the following is the most likely data format for an image to be saved in on a database?

  • ABit
  • BString
  • CBinary (correct answer)
  • DHex
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Binary

Topic 1 Β· Question 273

Given the following produce data for a small retail grocery store: Which of the following queries returns the quantity from highest to lowest?

Exhibit 1 for question 273
  • AGROUP BY
  • BMAX
  • CORDER (correct answer)
  • DSELECT
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: ORDER

Topic 1 Β· Question 274

A data analyst is selecting charts to include in a report. Which of the following is the most important in selecting appropriate charts?

  • AReport audience (correct answer)
  • BDate range
  • CCorporate branding
  • DReport frequency
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Report audience

Topic 1 Β· Question 275

A manager would like an analyst to create a new report on new data. Which of the following should the analyst do to determine the appropriate analysis?

  • ALink new data to existing sources.
  • BEvaluate vendor platforms.
  • CReview and refine business questions. (correct answer)
  • DDesign layout requirements.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Review and refine business questions.

Topic 1 Β· Question 276

Given the following tables: Referencing Table A, which of the following functions would be the most appropriate to summarize total items sold in Table B across the two channels?

Exhibit 1 for question 276Exhibit 2 for question 276
  • ABinning
  • BLookup
  • CSystem
  • DAggregate (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Aggregate

Topic 1 Β· Question 277

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?

  • ABubble chart
  • BStacked chart (correct answer)
  • CLine graph
  • DHeat map
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Stacked chart

Topic 1 Β· Question 278

Which of the following should a data analyst use to most efficiently gather recently released statistical information from one site?

  • ASurveys
  • BApplication programming interface (correct answer)
  • CWeb scraping
  • DPublic databases
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Application programming interface

Topic 1 Β· Question 279

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 are abbreviated and not easily identifiable. Which of the following types of documentation would be most useful for reference lookup?

  • AData flow diagrams
  • BDatabase specifications
  • CEntity-relationship diagrams
  • DData dictionary (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Data dictionary

Topic 1 Β· Question 280

Which of the following report types is considered the most important in a legal and compliance context?

  • ARegulatory (correct answer)
  • BInvestment
  • CPerformance
  • DOperational
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Regulatory

Topic 1 Β· Question 281

Giving the following values: 47 59 83 33 51 39 52 Which of the following is the mean?

  • A47
  • B51
  • C52 (correct answer)
  • D59
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: 52

Topic 1 Β· Question 282

Which of the following situations best describes an unclear and inconsistent column definition that can lead to an enabled analysis process?

  • AUndefined field (correct answer)
  • BDuplicated data
  • CTranspose
  • DOut-of-date dashboard
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Undefined field

Showing questions 261–280 of 294 Β· Page 14 of 15