DA-ASSOC practice questions 41–50

1. Question 41 · 65 in bank

   A data analyst needs to query the data in my_table. They want to return the values in columns user_id and email_address where records fit the following filter criteria: age is greater than 25 and country is Canada. The analyst does not want to return values from any other columns. Which code block will accomplish the above task?

   • ASELECT * FROM my_table WHERE age > 25 AND country = ’Canada’;
   • BSELECT user_id, email_address FROM my_table WHERE age > 25 AND country = ’Canada’;
   • CSELECT age, country FROM my_table WHERE age > 25 AND country = ’Canada’;
   • DSELECT user_id, email_address FROM my_table WHERE age = 25 AND country > ’Canada’;

   Show answer

   Answer: B

   Next question

2. Question 42 · 65 in bank

   Which example of data projects represents a common analytics application to be completed in Databricks SQL?

   • AAugmenting gold-layer tables with additional external information
   • BAutomating complex notebook-based workflows with multiple tasks
   • CTesting the quality of data as it is imported from a source
   • DSegmenting customers into like groups using a clustering algorithm

   Show answer

   Answer: A

   Next question

3. Question 43 · 65 in bank

   A data analyst wants the following output:

   

   Which statement will produce this output?

   • A//IMG//
   • B//IMG//
   • C//IMG//
   • D//IMG//

   Show answer

   Answer: D

   Next question

4. Question 44 · 65 in bank

   What is an advantage of using a Delta Lake-based data lakehouse over classic enterprise data warehouse solutions?

   • AOpen-source formats
   • BSchema enforcement
   • CACID transactions
   • DGeneric optimizations

   Show answer

   Answer: A

   Next question

5. Question 45 · 65 in bank

   Query History provides Databricks SQL users with a lot of benefits. A data analyst has been asked to share all of these benefits with their team as part of a training exercise. One of the benefit statements the analyst provided to their team is incorrect. Which statement about Query History is incorrect?

   • AIt can be used to troubleshoot slow running queries.
   • BIt can be used to view the query plan of queries that have run.
   • CIt can be used to debug queries.
   • DIt can be used to automate query execution on multiple warehouses (formerly endpoints).

   Show answer

   Answer: D

   Next question

6. Question 46 · 65 in bank

   A data scientist has asked a data analyst to create histograms for every continuous variable in a data set. The data analyst needs to identify which columns are continuous in the data set. What describes a continuous variable?

   • AA quantitative variable that never stops changing
   • BA quantitative variable that can take on a finite or countably infinite set of values
   • CA quantitative variable that can take on an uncountable set of values
   • DA categorical variable in which the number of categories continues to increase over time

   Show answer

   Answer: C

   Next question

7. Question 47 · 65 in bank

   A data analyst has been asked to use the below table sales_table to rank products within region by the sales:

   

   The result of the query should look like this:

   

   Which query will accomplish this task?

   • A//IMG//
   • B//IMG//
   • C//IMG//
   • D//IMG//

   Show answer

   Answer: D

   Next question

8. Question 48 · 65 in bank

   A database was created in Databricks SQL using the following statement: CREATE SCHEMA accounting LOCATION ’dbfs:/accounting/data’; Where will data for this database be stored?

   • Adbfs:/accounting/data/accounting.db
   • Bdbfs:/accounting/data
   • Cdbfs:/accounting/data.db
   • Ddbfs:/user/hive/warehouse/accounting.db

   Show answer

   Answer: B

   Next question

9. Question 49 · 65 in bank

   A data analyst is processing a complex aggregation on a table with zero null values and the query returns the following result:

   

   Which query did the analyst execute in order to get this result?

   • A//IMG//
   • B//IMG//
   • C//IMG//
   • D//IMG//

   Show answer

   Answer: C

   Next question

10. Question 50 · 65 in bank

    What describes the variance of a set of values?

    • AVariance is a measure of how far a single observed value is from a set of values.
    • BVariance is a measure of how far an observed value is from the variable’s maximum or minimum value.
    • CVariance is a measure of central tendency of a set of values.
    • DVariance is a measure of how far a set of values is spread out from the set's central value.

    Show answer

    Answer: D

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DA-ASSOC practice, question 41. 65 questions available.