Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Databricks Certified Data Analyst Associate

Databricks Certified Data Analyst Associate Exam Practice Questions (P. 4)

  • Full Access (45 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #16
Which of the following benefits of using Databricks SQL is provided by Data Explorer?
  1. A
    It can be used to run UPDATE queries to update any tables in a database.
  2. B
    It can be used to view metadata and data, as well as view/change permissions.
  3. C
    It can be used to produce dashboards that allow data exploration.
  4. D
    It can be used to make visualizations that can be shared with stakeholders.
  5. E
    It can be used to connect to third party BI cools.

Correct Answer:
B

Question #17
The stakeholders.customers table has 15 columns and 3,000 rows of data. The following command is run:

After running SELECT * FROM stakeholders.eur_customers, 15 rows are returned. After the command executes completely, the user logs out of Databricks.
After logging back in two days later, what is the status of the stakeholders.eur_customers view?
  1. A
    The view remains available and SELECT * FROM stakeholders.eur_customers will execute correctly.
  2. B
    The view has been dropped.
  3. C
    The view is not available in the metastore, but the underlying data can be accessed with SELECT * FROM delta. `stakeholders.eur_customers`.
  4. D
    The view remains available but attempting to SELECT from it results in an empty result set because data in views are automatically deleted after logging out.
  5. E
    The view has been converted into a table.

Correct Answer:
B

Question #18
A data analyst created and is the owner of the managed table my_ table. They now want to change ownership of the table to a single other user using Data Explorer.
Which of the following approaches can the analyst use to complete the task?
  1. A
    Edit the Owner field in the table page by removing their own account
  2. B
    Edit the Owner field in the table page by selecting All Users
  3. C
    Edit the Owner field in the table page by selecting the new owner's account
  4. D
    Edit the Owner field in the table page by selecting the Admins group
  5. E
    Edit the Owner field in the table page by removing all access

Correct Answer:
C

Question #19
A data analyst has a managed table table_name in database database_name. They would now like to remove the table from the database and all of the data files associated with the table. The rest of the tables in the database must continue to exist.
Which of the following commands can the analyst use to complete the task without producing an error?
  1. A
    DROP DATABASE database_name;
  2. B
    DROP TABLE database_name.table_name;
  3. C
    DELETE TABLE database_name.table_name;
  4. D
    DELETE TABLE table_name FROM database_name;
  5. E
    DROP TABLE table_name FROM database_name;

Correct Answer:
B

Question #20
A data analyst runs the following command:

SELECT age, country -

FROM my_table -
WHERE age >= 75 AND country = 'canada';
Which of the following tables represents the output of the above command?
  1. A
  2. B
  3. C
  4. D
  5. E

Correct Answer:
E

Previous Questions Next Questions

All Pages