CompTIA DA0-002 Online Practice Questions and Exam Preparation

CompTIA DA0-002 Online Questions & Answers

• Question 91:

  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 analyst receives the following notification when running a

  recurring analysis that connects to the database:

  Log-in failed for user `'

  Which of the following is most likely the reason for this issue?

  A. The company changed its database authentication method.
  B. The password expiration process locked the account.
  C. The analyst did not change the password used to launch the report.
  D. The company is experiencing issues with password replication.
  C. The analyst did not change the password used to launch the report.

• Question 92:

  Which of the following pieces of information, if made public, results in a data privacy violation?

  A. Gender
  B. Driver's license
  C. Age
  D. Employment status
  B. Driver's license

• Question 93:

  Which of the following best describes how discrete data differs from continuous data?

  A. Discrete data cannot create a sloped line.
  B. Discrete data can only be a finite number of values.
  C. Discrete data can have decimal points.
  D. Discrete data applies only to numbers.
  B. Discrete data can only be a finite number of values.

• Question 94:

  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?

  A. 29
  B. 36
  C. 40
  D. 63
  B. 36

• Question 95:

  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 analyst use for this task?

  A. Augmentation
  B. Imputation
  C. Scaling
  D. Binning
  D. Binning

• Question 96:

  Which of the following reports can be used when insight into operational performance is needed each Wednesday?

  A. Static report
  B. Tactical report
  C. Recurring report
  D. Ad hoc report
  C. Recurring report

• Question 97:

  Samantha needs to share a list of her organization's top 50 customers with the VP of sales.

  She would like to include the name of the customer, the business they represent, their contact information, and their total sales over the past year.

  The VP does not have any specialized analytics skills or software but would like to make some personal notes on the dataset.

  What would be the best tool for Samantha to use to share this information?

  A. Power BI.
  B. Microsoft Excel.
  C. Minitab.
  D. SAS.
  B. Microsoft Excel.

• Question 98:

  An administrator needs to design a table that will include foreign words. Which of the following is the best option for storing non-native language characters?

  A. VARCHAR
  B. NVARCHAR
  C. CLOB
  D. CHAR
  B. NVARCHAR

• Question 99:

  Which of the following supports capabilities such as automatic versioning, corruption checks, KPIs, and user authentication?

  A. Notebook
  B. REST API
  C. Pipeline
  D. Source control
  D. Source control

• Question 100:

  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?

  A. A granular daily report in a dashboard
  B. A detailed text document
  C. A spreadsheet with raw data
  D. A high-level email
  D. A high-level email