AWS SysOps Exam Preparation

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...

August 8, 2020 · 9 min · 1914 words · Eric

Talk Note - Influence without Authority

General Idea The fundamental reason why other people wants to listen to you, and follow you is not because you know more than him/her, it’s because you care him/her. The more you care about your audience, the easier they can follow you. Keep telling the facts and figures won’t help you to influent other people. Instead, try to ask questions to your audience and keep them involved into the conversation is a better approach....

August 2, 2020 · 1 min · 119 words · Eric

Navigate Through Ambiguity

General Steps to Navigate Through Ambiguity Step 1 - Understand the Expectation What is your goal? What will success look like? Is this goal measurable? Step 2 - Describe & Evaluate Current Situation Step 3 - Categorise Goals with Cynefin Framework Simple Complex Complicated Chaos Step 4 - Work backward Apply the MECE Framework Mutually Exclusive Collectively Exhaustive In general, the starting point for MECE is hard to determine. What you can do is to use following methods and try to find the starting point, e....

June 11, 2020 · 1 min · 183 words · Eric

Snowflake Concepts

Basic Concept Snowflake is a new model cloud-based enterprise-level data warehouse. 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....

May 13, 2020 · 3 min · 625 words · Eric

Snowflake Common Command Reference

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

May 12, 2020 · 1 min · 46 words · Eric