Question 1

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?

Options :

A : Sub setting the records.

B : Parameterizing the query.

C : Recompiling the query.

D : Adding an index.

Answer: D

Question 2

Which of the following best describes a business analytics tool with interactive visualization and business capabilities and an interface that is simple enough for end users to create their own reports and dashboards?

Options :

A : Python

B : R

C : Microsoft Power Bl

D : SAS

Answer: D

Question 3

Which of the following is the FIRST step to develop a clean and well-structured dashboard according to CompTIA dashboard development process?

Options :

A : Grant approval

B : Mockup design

C : Develop dashboard

D : Deploy to production

Answer: B

Question 4

Which of the following data analytics tools is a cloud-based platform designed to provide direct, simplified, real-time access to business data for decision-makers across the company with minimal IT involvement?

Options :

A :

Snowflake

B : OLTP

C : Delta load

D : Domo

Answer: D

Question 5

Which one of the following values would not be appropriately stored in integer data type?

Options :

A : -16

B : 10921

C : 0

D : 1.2

Answer: D