
I am really happy today because I passed my CISSP-ISSAP exam, and I give 70% of the credit to Cert Stash, which helped me a lot in my preparation.
Snowflake ADA-C02 SnowPro Advanced Administrator Exam Practice Questions
Every question comes with the correct answer and a clear explanation.
- 99% pass rate
- 62 questions
- 2 PDFs, instant delivery
US$39Pay in your own currency at checkout
- Free updates for lifeEvery new version of this pack, emailed to you free.
- Secure checkoutPayPal or card. Pay once, no subscription.
- Questions-only copyA second PDF without the answers, for timed practice runs.
Try before you buy
Five of the 62 questions in this pack
Question 1
The following commands were executed: Grant usage on database PROD to role PROD_ANALYST; Grant usage on database PROD to role PROD_SUPERVISOR; Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_ANALYST; Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_SUPERVISOR; Grant role PROD_ANALYST to user A; Grant role PROD_SUPERVISOR to user B; What authority does each user have on the WORKING schema?
Not this one. Try another answer.
Why A is wrong
PROD_ANALYST received the same schema privileges as PROD_SUPERVISOR, so user A can create tables too.
Not this one. Try another answer.
Why B is wrong
A new table is owned by the role that created it, and the other role needs its own grant on that table to see it.
Not this one. Try another answer.
Why C is wrong
Schema privileges do not include SELECT on existing tables, which must be granted on the tables themselves.
Right, D is the answer.
Why D is right
ALL PRIVILEGES on a schema includes CREATE TABLE, and both roles also hold USAGE on the PROD database. Each user has one of those roles, so both can create tables in PROD.WORKING.
Question 2
What steps are required to set up OKTAAPI token integration in Snowflake?
Not this one. Try another answer.
Why A is wrong
Granting the role and creating the integration does not generate the access token, and the token does not last 12 months.
Not this one. Try another answer.
Why B is wrong
The token expires after six months, not 12.
Not this one. Try another answer.
Why C is wrong
Creating the integration alone does not generate the access token.
Right, D is the answer.
Why D is right
The Okta API token is generated by ACCOUNTADMIN with SYSTEM$GENERATE_SCIM_ACCESS_TOKEN for the SCIM security integration. The token expires after six months, so it has to be generated again before then.
Question 3
Which command can temporarily disable Multi-factor Authentication (MFA) for the Snowflake username user1 for 24 hours?
Right, A is the answer.
Why A is right
MINS_TO_BYPASS_MFA is the user property that temporarily lets a user log in without MFA for the stated number of minutes. 24 hours is 1,440 minutes.
Not this one. Try another answer.
Why B is wrong
DISABLE_MFA takes TRUE and cancels the user's MFA enrollment; it does not take a number of minutes.
Not this one. Try another answer.
Why C is wrong
TEMPORARY_MFA_BYPASS is not a Snowflake user property.
Not this one. Try another answer.
Why D is wrong
HOURS_TO_BYPASS_MFA is not a Snowflake user property.
Question 4
A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant. An application with the accountant role should use this warehouse to run financial reports, and should keep track of compute credits used by the warehouse. What minimal privileges on the warehouse should be granted to the role to meet the requirements for the application? (Choose two.)
Not this one. Try another answer.
Why A is wrong
OPERATE is for manually suspending, resuming and aborting queries, which auto-resume makes unnecessary here.
Not this one. Try another answer.
Why B is wrong
MODIFY allows changing warehouse properties such as size, which the application does not need.
Right, C is one of the answers.
Why C is right
USAGE lets the role run queries on the warehouse, and because AUTO_RESUME is on, a suspended warehouse starts by itself when a query arrives. MONITOR lets the role see the warehouse's usage, which covers tracking the credits it consumes.
Right, D is one of the answers.
Why D is right
USAGE lets the role run queries on the warehouse, and because AUTO_RESUME is on, a suspended warehouse starts by itself when a query arrives. MONITOR lets the role see the warehouse's usage, which covers tracking the credits it consumes.
Not this one. Try another answer.
Why E is wrong
OWNERSHIP gives full control of the warehouse and is far more than the minimum.
Question 5
A user has enrolled in Multi-factor Authentication (MFA) for connecting to Snowflake. The user informs the Snowflake Administrator that they lost their mobile phone the previous evening. Which step should the Administrator take to allow the user to log in to the system, without revoking their MFA enrollment?
Right, A is the answer.
Why A is right
Setting MINS_TO_BYPASS_MFA on the user suspends the MFA prompt for that number of minutes, so the user can log in with a password while the enrollment itself stays in place.
Not this one. Try another answer.
Why B is wrong
DISABLE_MFA cancels the user's enrollment, which the question rules out.
Not this one. Try another answer.
Why C is wrong
SnowSQL supports MFA, so an enrolled user is still prompted.
Not this one. Try another answer.
Why D is wrong
Snowflake has no login URL suffix that bypasses MFA.
How much of the Snowflake ADA-C02 SnowPro Advanced Administrator bank is free ?
62 questions in the bank
- Free sample: 21 questions21 real questions, every answer explained, in one PDF.Get the free PDF
- Full pack, US$39All 62 questions. Plus the questions-only PDF, free updates for life, refund if you fail.Get the full pack
ADA-C02 SnowPro Advanced Administrator exam questions with answers : all 62 for Snowflake ADA-C02 SnowPro Advanced Administrator .
- 62 questions
mapped to the ADA-C02 exam study guide - Answers and explanations for every question, including the wrong options
- A questions-only PDF for timed practice runs
- Instant delivery by email the moment you check out
- Free updates for life
- Pass or your money back
ADA-C02 exam questions: the short answers
Snowflake lists the SnowPro Advanced exams at US$375 per attempt.
What does the exam cover?
Account administration, data security and governance, database objects and virtual warehouses, monitoring, tuning and optimization, data sharing and the Marketplace, and disaster recovery, backups and replication.
What experience does Snowflake recommend?
Snowflake recommends at least two years of hands-on experience as a Snowflake administrator in production.
What makes the ADA-C02 exam hard
The exam is scenario based and spans five administrator areas. Snowflake lists account management and security and governance, database objects and virtual warehouses, monitoring and tuning, data sharing and the Marketplace, and disaster recovery and replication.
Snowflake does not publish weights for these areas on its certification page, so study all five, especially role and privilege management, which the sample questions focus on.
About the exam
SnowPro Advanced: Administrator is Snowflake's advanced credential for administrators. It tests the ability to manage accounts, security, warehouses, sharing and recovery in production.
Before you buy
What you get for US$39
- All 62 questions, each with the correct answer and why the other options are wrong
- 2 PDFs: the full pack, plus a questions-only copy for timed practice
- Emailed the moment you pay
- Updated once a month, with free updates for life, emailed to the address you used at checkout
How a question works
Example: tap an answer, it is marked right or wrong, and the reason for that answer appears under the options.
What do I get?
Every pack comes as 2 PDFs: one with every answer explained, and a questions-only copy for timed practice. Products are delivered instantly as digital downloads, and every pack includes free updates for life.
How often are the questions updated?
Question sets are updated once a month.
Will I receive updates after purchasing?
Yes. All PDF purchases include lifetime updates. Updated versions are emailed automatically to the email address used during checkout.
What if an answer looks wrong?
We correct mistakes as we find them, and the monthly update sends those fixes to you. No question bank this size is ever completely flawless, so if something still looks off to you, check it against the vendor's own documentation and send it to support@certstash.com. We reply to every message, and the fix ships in the next update, free, for life.
Are your materials enough to pass the exam?
Most candidates use them as their main practice source. If you study with them and still fail, we refund you in full.
What happens if I fail my exam?
You get your money back. Sit the exam 7 to 30 days after buying, then email support@certstash.com within 7 days of the exam with your order number and a copy of your official score report showing the fail. Full terms are in the refund policy.
Do you have discount codes?
Yes, when you buy more than one exam pack. For 2 packs, use code BUY2 for 15% off. For 3 or more packs, use code BUY3 for 20% off. Enter the code in the discount box at checkout.
What payment methods do you accept?
Visa, Mastercard and other cards, Apple Pay, Google Pay and PayPal.
Do you offer shipping?
No. All products are digital downloads. There is no physical shipping.
I did not receive my order after payment.
Contact support@certstash.com with your order number and payment confirmation details.
