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

Given the diagram below:

Which of the following types of sampling is depicted in the image?

Options :

A : Stratified

B : Random

C : Cluster

D : Systematic

Answer: D

Question 3

Joe. an analyst. tests the loading time on a dashboard he is preparing to go live and finds it is slower than he would like. Which of the following must occur to decrease the loading time?

Options :

A : Deploy the dashboard to production.

B : Change the field definitions.

C : Update the dashboard subscribers.

D : Optimize the dashboard.

Answer: D

Question 4

Which of the following is an example of a data-mining ETL tool?

Options :

A : SSIS

B : Stata

C : SPSS

D : Cognos

Answer: A

Question 5

Which one of the following is a common data warehouse schema?

Options :

A : Snowflake.

B : Square.

C : Spiral.

D : Sphere.

Answer: A