DA-ASSOC practice questions 51–60

1. Question 51 · 65 in bank

   A data analyst is working in an organization that utilizes a multi-hop, medallion architecture. They have been tasked with creating a new Gold table from an existing Silver table. Which query is performing a hop from a Silver table to a Gold table?

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

   Show answer

   Answer: C

   Next question

2. Question 52 · 65 in bank

   What is used as a compute resource for Databricks SQL?

   • AStandard clusters
   • BSingle-node clusters
   • CSQL warehouses
   • DDownstream BI tools integrated with Databricks SQL

   Show answer

   Answer: C

   Next question

3. Question 53 · 65 in bank

   A data analyst has opened up the SQL Editor page and written a new SQL statement. The data analyst now wants to save that statement to easily refer back to it later to add it to a dashboard. The results of the SQL statement must be able to be displayed as a counter, table, or a data visualization. Which approach should the data analyst use to accomplish this task?

   • ASave the SQL statement as a Dashboard
   • BSave the SQL statement within a Notebook
   • CSave the SQL statement as a Query
   • DSave the SQL statement in the Query History page

   Show answer

   Answer: C

   Next question

4. Question 54 · 65 in bank

   A data analyst wants to create a Databricks SQL dashboard with multiple data visualizations and multiple counters. What must be completed before adding the data visualizations and counters to the dashboard?

   • AAll data visualizations and counters must be created using Queries.
   • BA SQL warehouse (formerly known as SQL endpoint) must be turned on and selected.
   • CA markdown-based tile must be added to the top of the dashboard displaying the dashboard’s name.
   • DThe dashboard owner must also be the owner of the queries, data visualizations, and counters.

   Show answer

   Answer: B

   Next question

5. Question 55 · 65 in bank

   What does Partner Connect do when connecting Power BI and Tableau?

   • ACreates a Personal Access Token, downloads and installs an ODBC driver, and downloads a configuration file for connection by Power BI or Tableau to a SQL Warehouse (formerly known as a SQL Endpoint).
   • BCreates a Personal Access Token for authentication into Databricks SQL and emails it to you.
   • CDownloads a configuration file for connection by Power BI or Tableau to a SQL Warehouse (formerly known as a SQL Endpoint).
   • DDownloads and installs an ODBC driver.

   Show answer

   Answer: A

   Next question

6. Question 56 · 65 in bank

   A data analyst is working with a nested array column products in table transactions. The analyst wants to return the first item in the array for each row. The data analyst is using the following incomplete command:

   

   Which lines of code should the data analyst use to fill in the blank in the above code block so that it successfully completes the task?

   • Aproducts.1
   • Bproducts.0
   • Cproducts[0]
   • Dproducts[1]

   Show answer

   Answer: C

   Next question

7. Question 57 · 65 in bank

   A dashboard contains a bar chart visualization. The bar chart has a Date widget parameter associated with it. Which statement about the Date widget parameter is true?

   • AThe Date widget parameter provides a start date and an end date that is used by a WHERE clause in the query that provides data to the bar chart.
   • BThe Date widget parameter provides a start date and an end date that sets the x-axis range of the bar chart.
   • CThe Date widget parameter provides a start date and an end date that filters all visualizations in the dashboard.
   • DThe Date widget parameter functions only as a text box that tells the dashboard's users what date range the dashboard is using.

   Show answer

   Answer: A

   Next question

8. Question 58 · 65 in bank

   A data analyst needs to share a Databricks SQL dashboard with stakeholders that are not permitted to have accounts in the Databricks deployment. The stakeholders need to be notified every time the dashboard is refreshed. Which approach can the data analyst use to accomplish this task with minimal effort?

   • ABy granting the stakeholders’ email addresses permissions to the dashboard
   • BBy adding the stakeholders’ email addresses to the refresh schedule subscribers list
   • CBy granting the stakeholders’ email addresses to the SQL Warehouse (formerly known as endpoint) subscribers list
   • DBy downloading the dashboard as a PDF and emailing it to the stakeholders each time it is refreshed

   Show answer

   Answer: B

   Next question

9. Question 59 · 65 in bank

   What describes Partner Connect in Databricks?

   • AIt allows for free use of Databricks partner tools through a common API.
   • BIt allows multi-directional connection between Databricks and Databricks partners easier.
   • CIt exposes connection information to third-party tools via Databricks partners.
   • DIt is a feature that runs Databricks partner tools on a Databricks SQL Warehouse (formerly known as a SQL Endpoint).

   Show answer

   Answer: B

   Next question

10. Question 60 · 65 in bank

    A data analyst has come across a column in a table that contains personally identifiable information (PII). The data analyst should not have access to this type of PII data. How should the data analyst proceed?

    • AStop working with the data and delete the table and any existing metadata or data files.
    • BStop working with the data and proceed with the project using other data.
    • CStop working with the data and notify their supervisor to ensure the data is handled following organizational and legal best practices.
    • DDrop the column containing PII data and continue with the project without notifying anybody.

    Show answer

    Answer: C

    Next question

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

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