- All Exams Instant Download
Data engineering team has provided 10 queries and asked Data Analyst team to build a dashboard and refresh the data every day at 8 AM, identify the best approach to set up data refresh for this dashaboard?
Data engineering team has provided 10 queries and asked Data Analyst team to build a dashboard and refresh the data every day at 8 AM, identify the best approach to set up data refresh for this dashaboard?A . Each query requires a separate task and setup 10 tasks under a...
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 performance B. Eliminate duplicate records C. Preserves grain of original data, without any aggregations D. Data quality checks and schema enforcement E. Powers ML applications, reporting, dashboards and adhoc reports.View AnswerAnswer: E...
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 lake B. Efficient storage and querying of full, unprocessed history of data C. Eliminates duplicate data, quarantines bad data D. Refined views with aggregated data E. Optimized query performance for business-critical dataView...
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 LOADER B. JOBS and TASKS C. SQL Endpoints...
Which of the following approaches can enable the data engineering team to be notified if the ELT job has not been run in an hour?
A data engineer is using a Databricks SQL query to monitor the performance of an ELT job. The ELT job is triggered by a specific number of input records being ready to process. The Databricks SQL query returns the number of minutes since the job’s most recent runtime. Which of...
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 attached B. global temporary views can be accessed across many clusters C. global temporary views can be still accessed even if the notebook is detached and...
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 statistics B. A job that queries aggregated data to publish key insights into a dashboard C. A job that ingests raw data from a streaming...
table("uncleanedSales")
table("uncleanedSales")View AnswerAnswer: B Explanation: The answer is
Which of the following SQL statements can be used to update a transactions table, to set a flag on the table from Y to N
Which of the following SQL statements can be used to update a transactions table, to set a flag on the table from Y to NA . MODIFY transactions SET active_flag = 'N' WHERE active_flag = 'Y' B. MERGE transactions SET active_flag = 'N' WHERE active_flag = 'Y' C. UPDATE transactions...
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 lake B. Efficient storage and querying of full, unprocessed history of data C. Eliminates duplicate data, quarantines bad data D. Refined views with aggregated data E. Optimized query performance for business-critical dataView...
