/avatar.png

AWS SysOps Exam

Billing and Cost Management User-Defined Cost Allocation Tags User-defined tags are tags that you define, create and apply to resources.After you have create and applied them, you can activate them on the Billing and Cost Management console for cost allocation tracking. The detailed steps are: Log in to the AWS Management Console of the new account Use the Tag Editor to create the new user-defined tags Use the Cost Allocation Tag manager in the payer account to mark the tags as cost allocation tags Certificate Manager (ACM) When you request a public certificate, AWS Certificate Manager (ACM) generates a public/private key pair

Snowflake Concepts FAQ

Basic Concept Architecture Snowflake’s architecture is a hybrid of traditional shared-disk database architectures and shared-nothing databases architectures. Similar to shared-disk architectures, Snowflake uses a central data repository for persisted data that is accessible from all compute nodes in the data warehouse. But similar to shared-nothing architectures, Snowflake processes queries using MPP (massively parallel processing) compute clusters where each node in the cluster stores a portion of the entire dataset locally.

Snowflake Common Command Reference

DML Show warehouse with filters 1 SHOWWAREHOUSESlike'%testing%'; Show most recent query id 1 SELECTlast_query_id() If you want to retrieve the second most recent query id, you can also provide -2 argument and do something like 1 SELECTlast_query_id(-2) Reference Snowflake: General Reference