Question 161
The security team is exploring whether or not the Databricks secrets module can be leveraged for connecting to an external database.
After testing the code with all Python variables being defined with strings, they upload the password to the secrets module and configure the correct permissions for the currently active user. They then modify their code to the following (leaving all other variables unchanged).
Which statement describes what will happen when the above code is executed?
After testing the code with all Python variables being defined with strings, they upload the password to the secrets module and configure the correct permissions for the currently active user. They then modify their code to the following (leaving all other variables unchanged).
Which statement describes what will happen when the above code is executed?
Question 162
The marketing team is launching a new campaign to monitor the performance of the new campaign for the first two weeks, they would like to set up a dashboard with a refresh schedule to run every 5 minutes, which of the below steps can be taken to reduce of the cost of this refresh over time?
Question 163
A healthcare analytics team is implementing a dimensional model in Delta Lake for patient care analysis.
They have a date dimension table and are evaluating design options to ensure it supports a wide range of time- based analyses.
Which design approach for the date dimension will support efficient time-based querying and aggregation?
They have a date dimension table and are evaluating design options to ensure it supports a wide range of time- based analyses.
Which design approach for the date dimension will support efficient time-based querying and aggregation?
Question 164
A production workload incrementally applies updates from an external Change Data Capture feed to a Delta Lake table as an always-on Structured Stream job. When data was initially migrated for this table, OPTIMIZE was executed and most data files were resized to 1 GB. Auto Optimize and Auto Compaction were both turned on for the streaming production job. Recent review of data files shows that most data files are under 64 MB, although each partition in the table contains at least 1 GB of data and the total table size is over 10 TB.
Which of the following likely explains these smaller file sizes?
Which of the following likely explains these smaller file sizes?
Question 165
Which Python variable contains a list of directories to be searched when trying to locate required modules?