Snowflake is designed for which type of workloads? (Choose two.)
Snowflake is designed for which type of workloads? (Choose two.)
Snowflake is primarily designed for OLAP (Online Analytical Processing) workloads, facilitating complex queries and analytical operations efficiently. Additionally, it is well-suited for concurrent workloads due to its unique architecture, which allows multiple virtual warehouses to run simultaneously and scale independently based on demand. This design helps handle a high number of concurrent users and queries without performance degradation. Although there have been developments like Snowflake Unistore to support transactional (OLTP) data, Snowflake's core strength remains in OLAP and concurrent workloads.
I think the answer is A and C, OLTP is not best use case for snowflake https://www.quora.com/Can-Snowflake-be-used-for-an-OLTP-system-or-is-it-only-best-suited-for-warehousing
Though Snowflake can handle transactions, it is never built to process OLTP.. infact it is built only for BI & Analytics.
A & C are the correct answer
A&C is correct: https://www.snowflake.com/guides/olap-vs-oltp
A & C are correct
AC is the correct answer✅
A. OLAP (Analytics) workloads C. Concurrent workloads Snowflake is primarily designed for analytical processing (OLAP) and can efficiently handle concurrent workloads due to its architecture, which allows multiple virtual warehouses to operate independently and scale as needed. It is not optimized for OLTP (Transactional) workloads, which typically require low-latency operations, nor is it designed specifically for on-premise workloads, as it is a cloud-based data warehousing solution.
Answer should be AC
A and C should be correct
A & C shoud be correct
Yes, community is right . The answer should be A & C . Because Snowflake is not designed for OLTP workloads. You can simply search on google for confirmation. Please update this answer list.
AC is the correct answer. - https://www.snowflake.com/trending/online-analytical-processing - https://www.snowflake.com/guides/olap-vs-oltp
Check this new feature of Unistore! A new workload that delivers a modern approach to working with transactional and analytical data together in a single platform https://www.snowflake.com/blog/introducing-unistore/
A. OLAP (Analytics) workloads B. OLTP (Transactional) workloads
The correct answer is OLAP and OLTP. Why? Because Snf introduced a new feature "Unistore" which enables hybrid tables with both transactional type data (OLTP) and analytical data (OLAP), in the PAST the answer would be different as one can see in the answer given by Snowflake below. https://community.snowflake.com/s/question/0D50Z00008BDIPTSA5/snowflake-oltp https://www.snowflake.com/en/data-cloud/workloads/unistore/
A and B Snowflake Unistore offers modern approach to working with transactional and analytical data together in a single platform. https://www.snowflake.com/guides/olap-vs-oltp
A.OLAP (Analytics) workloads B.Concurrent workloads
Snowflake in ideally made for OLAP system, not for OLTP.
OLTP isn't right
https://www.snowflake.com/guides/olap-vs-oltp OLTP is possible with Snowflake but Snowflake is designed for OLAP
Isn't oltp vs concurrent workloads same? What are the differences
AC is correct option
Snowflake Database is not designed for OLTP as Snowflake uses Columnar storage. OLTP typically are Row-oriented storage.
Sorry but snowflake says it is https://www.snowflake.com/en/data-cloud/workloads/unistore/
AC is the correct answer
Part of the Data Cloud, Snowflake Unistore offers modern approach to working with transactional and analytical data together in a single platform. https://www.snowflake.com/guides/olap-vs-oltp
AB is correct
As a Data Warehouse it's surely optimised for OLAP and concurrent workloads.
B and C Snowflake Unistore offers modern approach to working with transactional and analytical data together in a single platform https://www.snowflake.com/guides/olap-vs-oltp
A.OLAP (Analytics) workloads B.Concurrent workloads
OLAP AND Concurrent Workloads
Snowflake is designed for OLAP (Analytics) workloads and Concurrent workloads.
B?C is corrct
noncurrent and analytics