DA-ASSOC practice questions 31–40

1. Question 31 · 65 in bank

   Which of the following statements about a refresh schedule is incorrect?

   • AA query can be refreshed anywhere from 1 minute to 2 weeks.
   • BRefresh schedules can be configured in the Query Editor.
   • CA query being refreshed on a schedule does not use a SQL Warehouse (formerly known as SQL Endpoint).
   • DA refresh schedule is not the same as an alert.
   • EYou must have workspace administrator privileges to configure a refresh schedule.

   Show answer

   Answer: C

   Next question

2. Question 32 · 65 in bank

   A data analyst creates a Databricks SQL Query where the result set has the following schema: region STRING number_of_customer INT When the analyst clicks on the "Add visualization" button on the SQL Editor page, which of the following types of visualizations will be selected by default?

   • AViolin Chart
   • BLine Chart
   • CBar Chart
   • DHistogram
   • EThere is no default. The user must choose a visualization type.

   Show answer

   Answer: C

   Next question

3. Question 33 · 65 in bank

   A data analyst has created a Query in Databricks SQL, and now they want to create two data visualizations from that Query and add both of those data visualizations to the same Databricks SQL Dashboard. Which of the following steps will they need to take when creating and adding both data visualizations to the Databricks SQL Dashboard?

   • AThey will need to alter the Query to return two separate sets of results.
   • BThey will need to add two separate visualizations to the dashboard based on the same Query.
   • CThey will need to create two separate dashboards.
   • DThey will need to decide on a single data visualization to add to the dashboard.
   • EThey will need to copy the Query and create one data visualization per query.

   Show answer

   Answer: B

   Next question

4. Question 34 · 65 in bank

   A data analyst has been asked to produce a visualization that shows the flow of users through a website. Which of the following is used for visualizing this type of flow?

   • AHeatmap
   • BChoropleth
   • CWord Cloud
   • DPivot Table
   • ESankey

   Show answer

   Answer: E

   Next question

5. Question 35 · 65 in bank

   A data analyst has been asked to configure an alert for a query that returns the income in the accounts_receivable table for a date range. The date range is configurable using a Date query parameter. The Alert does not work. Which of the following describes why the Alert does not work?

   • AAlerts don't work with queries that access tables.
   • BQueries that return results based on dates cannot be used with Alerts.
   • CThe wrong query parameter is being used. Alerts only work with Date and Time query parameters.
   • DQueries that use query parameters cannot be used with Alerts.
   • EThe wrong query parameter is being used. Alerts only work with dropdown list query parameters, not dates.

   Show answer

   Answer: D

   Next question

6. Question 36 · 65 in bank

   Which of the following statements about adding visual appeal to visualizations in the Visualization Editor is incorrect?

   • AVisualization scale can be changed.
   • BData Labels can be formatted.
   • CColors can be changed.
   • DBorders can be added.
   • ETooltips can be formatted.

   Show answer

   Answer: D

   Next question

7. Question 37 · 65 in bank

   A data team has been given a series of projects by a consultant that need to be implemented in the Databricks Lakehouse Platform. Which of the following projects should be completed in Databricks SQL?

   • ATesting the quality of data as it is imported from a source
   • BTracking usage of feature variables for machine learning projects
   • CCombining two data sources into a single, comprehensive dataset
   • DSegmenting customers into like groups using a clustering algorithm
   • EAutomating complex notebook-based workflows with multiple tasks

   Show answer

   Answer: C

   Next question

8. Question 38 · 65 in bank

   Which of the following statements describes descriptive statistics?

   • AA branch of statistics that uses summary statistics to quantitatively describe and summarize data.
   • BA branch of statistics that uses a variety of data analysis techniques to infer properties of an underlying distribution of probability.
   • CA branch of statistics that uses quantitative variables that must take on a finite or countably infinite set of values.
   • DA branch of statistics that uses summary statistics to categorically describe and summarize data.
   • EA branch of statistics that uses quantitative variables that must take on an uncountable set of values.

   Show answer

   Answer: A

   Next question

9. Question 39 · 65 in bank

   In which of the following situations will the mean value and median value of variable be meaningfully different?

   • AWhen the variable contains no outliers
   • BWhen the variable contains no missing values
   • CWhen the variable is of the boolean type
   • DWhen the variable is of the categorical type
   • EWhen the variable contains a lot of extreme outliers

   Show answer

   Answer: E

   Next question

10. Question 40 · 65 in bank

    A data analyst is working with gold-layer tables to complete an ad-hoc project. A stakeholder has provided the analyst with an additional dataset that can be used to augment the gold-layer tables already in use. Which of the following terms is used to describe this data augmentation?

    • AData testing
    • BAd-hoc improvements
    • CLast-mile dashboarding
    • DLast-mile ETL
    • EData enhancement

    Show answer

    Answer: E

    Next question

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

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