Appendix C. Exam day guide
Time management strategy. You have 60 minutes to answer 35 questions, which gives you an average of roughly 1 minute and 40 seconds per question. On your first pass through the paper, answer 2-point conceptual questions and clear-cut boundary questions within 60 to 80 seconds. If a complex 3-point ordering or multi-constraint scenario question takes longer than 90 seconds, flag it and keep moving to the end of the paper first—saving your final 15 minutes to tackle flagged analytical questions methodically.
Underline the bold constraints in every scenario. On infrastructure questions, a single constraint in the prompt determines which option is right:
- "With zero downtime and without dropping active sessions": Immediately eliminate any option that overwrites a single secret key in place, runs
RENAME COLUMNorDROP COLUMNdirectly, or lowers DNS TTL on migration day and shuts down the old server immediately. Look for Dual-Key rotation, Expand-Contract migrations, and advance TTL reduction. - "Inside a private corporate network where no inbound firewall ports may be opened": Eliminate port forwarding and public IP security group rules; select an outbound-only
cloudflared(Cloudflare Tunnel) connector or a mesh VPN Subnet Router. - "In a high-concurrency serverless runtime (such as Vercel)": Eliminate direct or Session Mode connections on port
5432for runtime queries; select Supavisor Transaction Mode on port6543and colocate the function region (icn1) with the primary database. - "Preventing client bundle exposure and enforcing least privilege": Immediately eliminate options that prefix secrets with
NEXT_PUBLIC_, call Supabase with theservice_rolekey from client or general user routes, or setNODE_TLS_REJECT_UNAUTHORIZED=0.
Five golden rules for spotting wrong-answer traps.
- Workarounds that turn off security controls are always wrong. Disabling RLS, turning off Deployment Protection globally, switching Cloudflare SSL to
Flexible, passing-lock=falseto Terraform, or settingNODE_TLS_REJECT_UNAUTHORIZED=0is never the correct answer on the exam or in production. - Distinguish UI masking from actual encryption and access control. Setting
sensitive = truein Terraform only hides terminal output and does not encryptterraform.tfstate. Turning on the Cloudflare orange cloud only changes DNS responses and does not block direct-to-IP attacks if the origin firewall is left open to0.0.0.0/0. - Watch out for reversed evaluation timing or direction. In PostgreSQL RLS,
USINGfilters existing rows whileWITH CHECKvalidates new or updated rows. In DNS migrations, lowering the TTL must happen at least one full old-TTL window before cutover day, never at the moment of cutover. - Never mix shared edge caching with personalized or streaming responses. Applying
Cache Everythingto/api/*user routes, responses carryingSet-Cookie, or SSE streams (text/event-stream) causes cache poisoning data leaks and broken streams. - The first step in any live incident is always mitigation (rollback, isolation, or emergency revocation). Stopping customer impact via an instant rollback, kill switch, or key revocation always comes before root-cause debugging or writing postmortem documents.
Key point
During the final 10 minutes before entering the exam room, scan the five Summary at a glance tables at the end of each chapter and lock these key pairs into memory: 6543 (Transaction Mode) vs. 5432 (Session/Direct), USING (existing rows) vs. WITH CHECK (new/updated rows), ~ (in-place update) vs. -/+ (destroy and recreate), Alias (Zone Apex) vs. CNAME (subdomain), Full (Strict) vs. Flexible (redirect loop), NODE_EXTRA_CA_CERTS (appends CA) vs. SSL_CERT_FILE (replaces with combined bundle), and Expand → Dual-Write → Cutover → Contract.