An Architect has designed a data pipeline that Is receiving small CSV files from multiple sources. All of the
files are landing in one location. Specific files are filtered for loading into Snowflake tables using the copy
command. The loading performance is poor.
What changes can be made to Improve the data loading performance?
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).
When loading data into a table that captures the load time in a column with a default value of either
CURRENT_TIME () or CURRENT_TIMESTAMP() what will occur?
sources to support a wide variety of use cases and data consumer requirements which include:
1) Finance and Vendor Management team members who require reporting and visualization
2) Data Science team members who require access to raw data for ML model development
3) Sales team members who require engineered and protected data for data monetization
What Snowflake data modeling approaches will meet these requirements? (Choose two.)
What Snowflake system functions are used to view and or monitor the clustering metadata for a table? (Select
TWO).
© Copyrights Dumpscity 2024. All Rights Reserved
We use cookies to ensure your best experience. So we hope you are happy to receive all cookies on the Dumpscity.