Sadan's Oracle dba Blog

  1. Architecture & Storage Explain Snowflake’s unique architecture. * Answer: It is a hybrid of shared-disk and shared-nothing architectures. It consists of three layers: Database Storage (columnar format, micro-partitions), Query Processing (Virtual Warehouses), and Cloud Services (metadata, security, optimization). What are Micro-partitions and how do they benefit the DBA? Answer: All data in Snowflake is automatically divided into micro-partitions (50MB to 500MB of uncompressed data). This eliminates the need for manual partitioning and enables "Pruning," where the engine only scans relevant partitions. What is the difference between Time Travel and Fail-safe? Answer: Time Travel allows you to access historical data (up to 90 days for Enterprise) for recovery or querying. Fail-safe is a non-configurable 7-day period after Time Travel expires where Snowflake Support can recover data in case of extreme failure. 2. Virtual Warehouses & Performance Tuning How...

 1. Identify the SID/Session Running the UPDATE                                                                                                                                                                                                                                                          ...

  ------------------------------------------------------------------------------------- 1.    Explain Sql architecture briefly. 2.    What is .wrk file & .tuf file. 3.    How to do patching. 4.    How to failover in Always On / Mirroring / Logshipping. 5.    How many jobs available in Logshipping and what are they? 6.    How the data moves in logshipping from primary server to secondary. 7.    How to configure logshipping 8.    Microsoft will support for which versions. 9.    Have you raised any MS cases? 10. What is snapshot is SQL. 11. What is split backup. 12. What is copy only backup. 13. What is latency logshipping. 14. How much is latency in logshipping. 15. Can you give drawback of each in HA techniques. 16. What is synchronous and asynchronous in SQL. 17....