Question 131

One of the team members Steve who has the ability to create views, created a new view called re-gional_sales_vw on the existing table called sales which is owned by John, and the second team member Kevin who works with regional sales managers wanted to query the data in region-al_sales_vw, so Steve granted the permission to Kevin using command GRANT VIEW, USAGE ON regional_sales_vw to [email protected] but Kevin is still unable to access the view?
  • Question 132

    A junior data engineer has manually configured a series of jobs using the Databricks Jobs UI. Upon reviewing their work, the engineer realizes that they are listed as the "Owner" for each job. They attempt to transfer
    "Owner" privileges to the "DevOps" group, but cannot successfully accomplish this task.
    Which statement explains what is preventing this privilege transfer?
  • Question 133

    The data engineer team is configuring environment for development testing, and production before beginning migration on a new data pipeline. The team requires extensive testing on both the code and data resulting from code execution, and the team want to develop and test against similar production data as possible.
    A junior data engineer suggests that production data can be mounted to the development testing environments, allowing pre production code to execute against production data. Because all users have Admin privileges in the development environment, the junior data engineer has offered to configure permissions and mount this data for the team.
    Which statement captures best practices for this situation?
  • Question 134

    What is the main difference between the silver layer and gold layer in medallion architecture?
  • Question 135

    Which of the following SQL keywords can be used to append new rows to an existing Delta table?