Snowflake ADA-C02 Certification Exam Sample Questions

ADA-C02 Braindumps, ADA-C02 Exam Dumps, ADA-C02 Examcollection, ADA-C02 Questions PDF, ADA-C02 Sample Questions, SnowPro Advanced - Administrator Dumps, SnowPro Advanced - Administrator Official Cert Guide PDF, SnowPro Advanced - Administrator VCEWe have prepared Snowflake SnowPro Advanced - Administrator (ADA-C02) certification sample questions to make you aware of actual exam properties. This sample question set provides you with information about the SnowPro Advanced - Administrator exam pattern, question formate, a difficulty level of questions and time required to answer each question. To get familiar with Snowflake Certified SnowPro Advanced - Administrator exam, we suggest you try our Sample Snowflake ADA-C02 Certification Practice Exam in simulated Snowflake certification exam environment.

To test your knowledge and understanding of concepts with real-time scenario based Snowflake ADA-C02 questions, we strongly recommend you to prepare and practice with Premium Snowflake SnowPro Advanced - Administrator Certification Practice Exam. The premium Snowflake SnowPro Advanced - Administrator certification practice exam helps you identify topics in which you are well prepared and topics in which you may need further training to achieving great score in actual Snowflake Certified SnowPro Advanced - Administrator exam.

Snowflake ADA-C02 Sample Questions:

01. One large warehouse serves a nightly ELT job, a set of BI dashboards and an ad-hoc data science team. Dashboard users wait while the ELT job runs, and the settings that suit one workload suit neither of the others: the batch job wants a large warehouse for a short window, while the dashboards want a modest one that stays warm across the day.
What does giving each workload its own warehouse achieve here that resizing the shared warehouse does not?
a) Each workload runs on compute sized, suspended and scaled for its own shape of work, and the batch job's bursts no longer delay the dashboards.
b) Snowflake distributes statements across every warehouse a role is permitted to use, so once several warehouses exist the load spreads automatically and no single warehouse becomes a bottleneck during the batch window.
c) Separate warehouses share one local data cache, so the dashboards keep reading the tables the batch job has just scanned.
d) Storage charges fall, because each warehouse is billed only for the tables its own workload touches.
 
02. To stop a group of contractors signing in with passwords at all, an administrator creates a password policy and sets it on the account. The contractors' password logins keep succeeding.
What is the correct assessment of this attempt?
a) A password policy only takes effect once it has also been set on each user, because a policy attached to the account governs only the administrators who manage the account itself.
b) Password policies are enforced for sign-in through the web interface, so contractors who connect through a driver or through SnowSQL fall outside the policy's reach entirely.
c) A password policy governs what a password may be, not whether passwords may be used, so the method restriction belongs to an authentication policy.
d) Password policies apply only to service users, never to users who sign in interactively.
 
03. Every object a platform team built last quarter was created while ACCOUNTADMIN was the active role, and ACCOUNTADMIN is also the default role on each engineer's user. Other teams report that they still cannot see those databases even after being granted a role, and a security review has flagged how widely ACCOUNTADMIN is held.
Which remediation should the administrator design?
a) Transfer ownership of the objects to a custom role in the SYSADMIN hierarchy, change each engineer's default role to that custom role, and keep ACCOUNTADMIN for account-level work by a small custodian group.
b) Grant ACCOUNTADMIN to the other teams' roles so that the objects they cannot see become reachable through the role hierarchy.
c) Clone the objects into a new database, leave the originals in place, and grant the other teams usage on the clone so ownership does not have to change.
d) Enforce multi-factor authentication on every user who holds ACCOUNTADMIN and leave object ownership as it is.
 
04. A platform team converts a schema with CREATE SCHEMA ... WITH MANAGED ACCESS. The roles that created the tables in that schema still hold OWNERSHIP of them, and several of those tables already carry SELECT grants that were issued to reporting roles before the conversion.
What does managed access change for those object owners?
a) Privileges already granted on objects in the schema are revoked at the moment of conversion, and every role has to go back to the schema owner to request its access all over again.
b) Grant authority moves to the schema owner, so object owners can no longer issue new grants on objects they own, while the grants already in force are untouched.
c) Object owners keep grant authority on the objects they own, and the schema owner simply gains the same authority alongside them, so either party is able to issue a grant.
d) Each object owner must reissue its grants once the schema is converted.
 
05. Analysts maintain a non-materialized view that joins two large tables. An engineer creates a stream on that view to drive an incremental pipeline, but every query against the stream comes back empty even though both underlying tables are being loaded steadily.
What is the most likely cause?
a) Streams are not supported on views of any kind, so the object was silently created against the view's first underlying table instead.
b) A directory table, not a stream, is what tracks changes to a view.
c) A stream on a view captures only changes to the view's own definition, not to the data it returns.
d) Change tracking has not been enabled on the view and on every underlying table the view reads from.
 
06. Four teams share one large warehouse. Finance wants each team's compute charged back to that team. The administrator can change the warehouse topology and can apply object tags, but cannot change the unit Snowflake meters compute in.
What is the sound basis for the chargeback?
a) Create a resource monitor for each team on the shared warehouse so that each team's credits are counted and capped separately.
b) Give each team its own warehouse and tag those warehouses with the team's cost center, so credits arrive attributed.
c) Tag each team's tables and databases, then apportion the shared warehouse's credits across the four teams by tagged storage volume.
d) Give every team member a distinct role and read credits by role from WAREHOUSE_METERING_HISTORY.
 
07. An administrator runs data classification across a new schema of customer tables. The results come back with a semantic category and a privacy category for a number of columns, including two columns the team did not expect to be flagged.
What is the right thing to do with this output?
a) Review the returned categories and associate the ones that are right as tags on those columns, because classification proposes categories for a person to confirm rather than protecting anything by itself.
b) Treat the classified columns as protected from that point, since classification attaches the account's masking policies to every column it categorizes.
c) Re-run the classification as ACCOUNTADMIN so that the categories are written into the table definitions, because a lower role only previews them.
d) Drop the unexpected categories and reload the affected tables, so that the next classification run returns a clean result.
 
08. Role ANALYST has been granted SELECT directly on the table SALES.FINANCE.LEDGER, and SHOW GRANTS TO ROLE ANALYST lists that SELECT grant together with USAGE on the database SALES and USAGE on the warehouse the session is running.
A user whose active role is ANALYST runs SELECT * FROM SALES.FINANCE.LEDGER; and the statement fails, saying the object does not exist or is not authorized.
What accounts for the failure?
a) A privilege granted directly on a table does not take effect until the role holding it has itself been granted to a role above it in the hierarchy.
b) SELECT on an existing table takes effect only through a future grant, which has to be in place before the table is queried.
c) The role holds no USAGE on the schema FINANCE.
d) The role lacks a privilege on the warehouse, which Snowflake reports in the same words as an unauthorized object.
 
09. Users of a multi-cluster warehouse report that the first queries each morning wait noticeably before they start. The warehouse has a short auto-suspend and sits idle overnight.
Query history for those statements records almost all of the wait as queued provisioning time, with queued overload time at or near zero.
What does this pattern indicate, and what addresses it?
a) Concurrency is exceeding what the warehouse can serve, so raising the maximum cluster count and moving to the more responsive scaling policy is what clears the waits users see each morning.
b) The warehouse is undersized for the individual statements, so resizing it to a larger size removes the recorded wait.
c) Result cache misses or cold metadata at the start of the day are what the recorded wait measures.
d) The wait is compute starting up rather than contention, so keeping a cluster warm through a longer auto-suspend or a higher minimum cluster count removes it.
 
10. Several COPY INTO statements, owned by different teams, load the same CSV layout from the same stage. The delimiter used by the upstream extract is about to change, and the administrator wants one place to make that edit rather than opening every loading job.
What should the administrator do?
a) Give each COPY a FORMAT_NAME together with the replacement delimiter option inside the same FILE_FORMAT clause.
b) Keep the full option list inline in each COPY statement, so that every loading job stays self-contained.
c) Create one named file format object and reference it by FORMAT_NAME in each COPY.
d) Set the parsing options once as session variables and have each job set them before its COPY runs.

Answers:

Question: 01
Answer: a		 Question: 02
Answer: c		 Question: 03
Answer: a		 Question: 04
Answer: b		 Question: 05
Answer: d
Question: 06
Answer: b		 Question: 07
Answer: a		 Question: 08
Answer: c		 Question: 09
Answer: d		 Question: 10
Answer: c

Note: Please update us by writing an email on feedback@vmexam.com for any error in Snowflake Certified SnowPro Advanced - Administrator certification exam sample questions

Rating: 5 / 5 (75 votes)