When investigating a data issue, if you are looking compare the current version of the data with the previous version, what is the best way to query historical data?
You were asked to create a table that can store the below data, note that orderDate is the truncated date format of OrderTime, fill in the blank to complete the DDL.
CREATE TABLE orders (
orderId int,
orderTime timestamp,
orderdate date _____________________________________________ ,
You currently working with marketing team to setup a dashboard on ad campaign analysis, since the team is not sure how often the dashboard should refreshed they have decided to do a manual refresh on as needed basis. Which of the following steps can be taken to reduce the overall cost of the compute?
The sales team has asked the Data engineering team to develop a dashboard that shows sales performance for all stores, but the sales team would like to use the dashboard but would like to select individual store location, which of the following approaches Data Engineering team can use to build this functionality into the dashboard.
Operations team is using a centralized data quality monitoring system, a user can publish data quality metrics through a webhook, you were asked to develop a process to send messages using webhook if there is atleast one duplicate record, which of following approaches can be taken to integrate with current data quality monitoring system