Question 66

A retail company has over 3000 stores all using the same Point of Sale (POS) system. The company wants to deliver near real-time sales results to category managers. The stores operate in a variety of time zones and exhibit a dynamic range of transactions each minute, with some stores having higher sales volumes than others.
Sales results are provided in a uniform fashion using data engineered fields that will be calculated in a complex data pipeline. Calculations include exceptions, aggregations, and scoring using external functions interfaced to scoring algorithms. The source data for aggregations has over 100M rows.
Every minute, the POS sends all sales transactions files to a cloud storage location with a naming convention that includes store numbers and timestamps to identify the set of transactions contained in the files. The files are typically less than 10MB in size.
How can the near real-time results be provided to the category managers? (Select TWO).
  • Question 67

    How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)
  • Question 68


    Based on the architecture in the image, how can the data from DB1 be copied into TBL2? (Select TWO).
  • Question 69

    Company A would like to share data in Snowflake with Company B. Company B is not on the same cloud platform as Company A.
    What is required to allow data sharing between these two companies?
  • Question 70

    A user can change object parameters using which of the following roles?