CompTIA DA0-001 Quiz 17 Topic 6 Questions 81-85

Question: 1

Given the diagram below:

q1_DA0-001

Which of the following data schemas shown?

AKey-value pairs

BOnline transactional processing

CData lake

DRelational database

Show Answer

Question: 2

A data analyst has been asked to organize the table below in the following ways:

By sales from high to low -

By state in alphabetic order -

q2_DA0-001

Which of the following functions will allow the data analyst to organize the table in this manner?

AConditional formatting

BGrouping

CFiltering

DSorting

Show Answer

Question: 3

A publishing group has requested a dashboard to track submissions before publication. A key requirement is that all changes are tracked, as multiple users will be checking out documents and editing them before submissions are considered final. Which of the following is the BEST way to meet this stakeholder requirement?

ADisplay the version number next to each submission on the dashboard.

BPresent a data refresh date at the top of the dashboard.

CConfirm the dashboard is adhering to the corporate style guide.

DUse permissions to ensure users only see certain versions of the submissions.

Show Answer

Question: 4

A data analyst is asked to create a sales report for the second-quarter 2020 board meeting, which will include a review of the business's performance through the second quarter. The board meeting will be held on July 15, 2020, after the numbers are finalized. Which of the following report types should the data analyst create?

AStatic

BReal-time

CSelf-service

DDynamic

Show Answer

Question: 5

You have a database where queries are performing slowly.

Investigating the results, you find that the database is performing a time-consuming table scan.

What action can best improve the query performance?

ASub setting the records.

BParameterizing the query.

CRecompiling the query.

DAdding an index.

Show Answer

CompTIA DA0-001 Quiz:17 Topic:6 Questions:81-85