Exam Databricks-Certified-Professional-Data-Engineer Topic 2 Question 194 Discussion

Actual exam question for Databricks's Databricks-Certified-Professional-Data-Engineer exam
Question #: 194
Topic #: 2

A data analyst has provided a data engineering team with the following Spark SQL query:
1.SELECT district,
2.avg(sales)
3.FROM store_sales_20220101
4.GROUP BY district;
The data analyst would like the data engineering team to run this query every day. The date at the end of the
table name (20220101) should automatically be replaced with the current date each time the query is run.
Which of the following approaches could be used by the data engineering team to efficiently auto-mate this
process?

A. They could request that the data analyst rewrites the query to be run less frequently B. They could pass the table into PySpark and develop a robustly tested module on the existing query C. They could wrap the query using PySpark and use Python's string variable system to automatically
update the table name D. They could manually replace the date within the table name with the current day's date E. They could replace the string-formatted date in the table with a timestamp-formatted date

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business