- All Exams Instant Download
What is the purpose of a gold layer in Multi-hop architecture?
What is the purpose of a gold layer in Multi-hop architecture?A . Optimizes ETL throughput and analytic query performanceB . Eliminate duplicate recordsC . Preserves grain of original data, without any aggregationsD . Data quality checks and schema enforcementE . Powers ML applications, reporting, dashboards and adhoc reports.View AnswerAnswer: E...
You are currently asked to work on building a data pipeline, you have noticed that you are currently working on a very large scale ETL many data dependencies, which of the following tools can be used to address this problem?
You are currently asked to work on building a data pipeline, you have noticed that you are currently working on a very large scale ETL many data dependencies, which of the following tools can be used to address this problem?A . AUTO LOADERB . JOBS and TASKSC . SQL EndpointsD...
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...
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...
ELSE (temp C 33 ) * 5/9 5.END
ELSE (temp C 33 ) * 5/9 5.ENDView AnswerAnswer: D Explanation: The answer is
A DELTA LIVE TABLE pipelines can be scheduled to run in two different modes, what are these two different modes?
A DELTA LIVE TABLE pipelines can be scheduled to run in two different modes, what are these two different modes?A . Triggered, IncrementalB . Once, ContinuousC . Triggered, ContinuousD . Once, IncrementalE . Continuous, IncrementalView AnswerAnswer: C Explanation: The answer is Triggered, Continuous https://docs.microsoft.com/en-us/azure/databricks/data-engineering/delta-live-tables/delta-live-tables-concepts#--continuous-and-triggered-pipelines • Triggered pipelines update each table...
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 is the purpose of the silver layer in a Multi hop architecture?
What is the purpose of the silver layer in a Multi hop architecture?A . Replaces a traditional data lakeB . Efficient storage and querying of full, unprocessed history of dataC . Eliminates duplicate data, quarantines bad dataD . Refined views with aggregated dataE . Optimized query performance for business-critical dataView...
Which of the following is correct for the global temporary view?
Which of the following is correct for the global temporary view?A . global temporary views cannot be accessed once the notebook is detached and attachedB . global temporary views can be accessed across many clustersC . global temporary views can be still accessed even if the notebook is detached and...
What is the purpose of the silver layer in a Multi hop architecture?
What is the purpose of the silver layer in a Multi hop architecture?A . Replaces a traditional data lakeB . Efficient storage and querying of full, unprocessed history of dataC . Eliminates duplicate data, quarantines bad dataD . Refined views with aggregated dataE . Optimized query performance for business-critical dataView...
