- All Exams Instant Download
What is the purpose of a silver layer in Multi hop architecture?
What is the purpose of a silver layer in Multi hop architecture?A . Replaces a traditional data lakeB . Efficient storage and querying of full and unprocessed history of dataC . A schema is enforced, with data quality checks.D . Refined views with aggregated dataE . Optimized query performance for...
Which of the following data workloads will utilize a Bronze table as its destination?
Which of the following data workloads will utilize a Bronze table as its destination?A . A job that aggregates cleaned data to create standard summary statisticsB . A job that queries aggregated data to publish key insights into a dashboardC . A job that ingests raw data from a streaming...
You are currently working with the application team to setup a SQL Endpoint point, once the team started consuming the SQL Endpoint you noticed that during peak hours as the number of concur-rent users increases you are seeing degradation in the query performance and the same queries are taking longer to run, which of the following steps can be taken to resolve the issue?
You are currently working with the application team to setup a SQL Endpoint point, once the team started consuming the SQL Endpoint you noticed that during peak hours as the number of concur-rent users increases you are seeing degradation in the query performance and the same queries are taking longer...
table(table_name))
table(table_name))A . format, checkpointlocation, schemalocation, overwriteB . cloudfiles.format, checkpointlocation, cloudfiles.schemalocation, overwriteC . cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, mergeSchemaD . cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, overwriteE . cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, appendView AnswerAnswer: C Explanation: The answer is cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, mergeSchema. Here is the end to end syntax of streaming ELT, below link contains complete...
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 ....
Which of the following commands can be used to run one notebook from another notebook?
Which of the following commands can be used to run one notebook from another notebook?A . notebook.utils.run("full notebook path")B . execute.utils.run("full notebook path")C . dbutils.notebook.run("full notebook path")D . only job clusters can run notebookE . spark.notebook.run("full notebook path")View AnswerAnswer: C Explanation: The answer is dbutils.notebook.run(" full notebook path ") Here...
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?A . MERGE INTO table_nameB . COPY INTO table_nameC . UPDATE table_nameD . INSERT INTO OVERWRITE table_nameE . INSERT IF EXISTS table_nameView AnswerAnswer: A Explanation:...
You are noticing job cluster is taking 6 to 8 mins to start which is delaying your job to finish on time, what steps you can take to reduce the amount of time cluster startup time
You are noticing job cluster is taking 6 to 8 mins to start which is delaying your job to finish on time, what steps you can take to reduce the amount of time cluster startup timeA . Setup a second job ahead of first job to start the cluster, so...
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?A . MERGE INTO table_nameB . COPY INTO table_nameC . UPDATE table_nameD . INSERT INTO OVERWRITE table_nameE . INSERT IF EXISTS table_nameView AnswerAnswer: A Explanation:...
