- All Exams Instant Download
You are asked to write a python function that can read data from a delta table and return the Data-Frame, which of the following is correct?
You are asked to write a python function that can read data from a delta table and return the Data-Frame, which of the following is correct?A . Python function cannot return a DataFrameB . Write SQL UDF to return a DataFrameC . Write SQL UDF that can return tabular dataD...
Why does AUTO LOADER require schema location?
Why does AUTO LOADER require schema location?A . Schema location is used to store user provided schemaB . Schema location is used to identify the schema of target tableC . AUTO LOADER does not require schema location, because its supports Schema evolutionD . Schema location is used to store schema...
What could be the expected output of query SELECT COUNT (DISTINCT *) FROM user on this table
What could be the expected output of query SELECT COUNT (DISTINCT *) FROM user on this table A . 3B . 2 (Correct)C . 1D . 0E . NULLView AnswerAnswer: B Explanation: The answer is 2, Count (DISTINCT *) removes rows with any column with a NULL value
Which of the following statements can be used to test the functionality of code to test number of rows in the table equal to 10 in python?
Which of the following statements can be used to test the functionality of code to test number of rows in the table equal to 10 in python? row_count = spark.sql("select count(*) from table").collect()[0][0]A . assert (row_count = 10, "Row count did not match")B . assert if (row_count = 10, "Row...
Which of the following technique can be used to implement fine-grained access control to rows and columns of the Delta table based on the user's access?
Which of the following technique can be used to implement fine-grained access control to rows and columns of the Delta table based on the user's access?A . Use Unity catalog to grant access to rows and columnsB . Row and column access control listsC . Use dynamic view functionsD ....
What would you recommend for reducing the overall cost of this approach?
You noticed that a team member started using an all-purpose cluster to develop a notebook and used the same all-purpose cluster to set up a job that can run every 30 mins so they can update un-derlying tables which are used in a dashboard. What would you recommend for reducing...
Which of the following describes how Databricks Repos can help facilitate CI/CD workflows on the Databricks Lakehouse Platform?
Which of the following describes how Databricks Repos can help facilitate CI/CD workflows on the Databricks Lakehouse Platform?A . Databricks Repos can facilitate the pull request, review, and approval process before merging branchesB . Databricks Repos can merge changes from a secondary Git branch into a main Git branchC ....
as total_sales from sales
as total_sales from salesView AnswerAnswer: C Explanation: The answer is
How to determine if a table is a managed table vs external table?
How to determine if a table is a managed table vs external table?A . Run IS_MANAGED(‘table_name’) functionB . All external tables are stored in data lake, managed tables are stored in DELTA lakeC . All managed tables are stored in unity catalogD . Run SQL command DESCRIBE EXTENDED table_name and...
How would you approach resolving this issue?
A SQL Dashboard was built for the supply chain team to monitor the inventory and product orders, but all of the timestamps displayed on the dashboards are showing in UTC format, so they requested to change the time zone to the location of New York. How would you approach resolving...
