Free SNOWPRO-ADVANCED-ARCHITECT – Snowflake SNOWPRO-ADVANCED-ARCHITECT Practice Test Question

Select an option, then click Submit answer.

• ○ Set up replication to allow users to connect from outside the company VPN.
• ○ Provision a unique company Tri-Secret Secure key.
• ○ Use private connectivity from a cloud provider.
• ○ Set up SSO for federated authentication.
• ○ Use a proxy Snowflake account outside the VPN, enabling client redirect for user logins.

Select an option, then click Submit answer.

• ○ Stage integration
• ○ Security integration
• ○ Storage integration
• ○ API integration

Select an option, then click Submit answer.

• ○ Grant ANALYST_ROLE OWNERSHIP on the database, but make sure that ANALYST_ROLE does not have the MANAGE GRANTS privilege on the account.
• ○ Grant SYSADMIN OWNERSHIP of the database, but grant the create schema privilege on the database to the ANALYST_ROLE.
• ○ Make every schema in the database a MANAGED ACCESS schema, owned by SYSADMIN, and grant create privileges on each schema to the ANALYST_ROLE for each type of object that needs to be created.
• ○ Grant ANALYST_ROLE OWNERSHIP on the database, but grant the OWNERSHIP ON FUTURE [object type]s in database privilege to SYSADMIN.

Select an option, then click Submit answer.

• ○ Use the Snowflake Connector for Python, connect to remote storage and download the file.
• ○ Use the GET command in SnowSQL to retrieve the file.
• ○ Use the GET command in Snowsight to retrieve the file.
• ○ Use the Snowflake API endpoint and download the file.

Select an option, then click Submit answer.

• ○ Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.
• ○ Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 Glacier storage.
• ○ Create an AWS Lambda function to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.
• ○ Configure AWS Simple Notification Service (SNS) to notify Snowpipe when new files have arrived in Amazon S3 storage.
• ○ Configure the client application to issue a COPY INTO command to Snowflake when new files have arrived in Amazon S3 Glacier storage.

Select an option, then click Submit answer.

• ○ Connect the applications using the - URL. Use the Business Critical Snowflake edition.
• ○ Connect the applications using the - URL. Use the Virtual Private Snowflake (VPS) edition.
• ○ Connect the applications using the - URL. Use the Enterprise Snowflake edition.
• ○ Connect the applications using the - URL. Use the Business Critical Snowflake edition.

Select an option, then click Submit answer.

• ○ Snowflake cannot handle the joins implied in a 3NF data model.
• ○ The Architect wants to remove data duplication from the data stored in Snowflake.
• ○ The Architect is designing a landing zone to receive raw data into Snowflake.
• ○ The BI tool needs a data model that allows users to summarize facts across different dimensions, or to drill down from the summaries.
• ○ The Architect wants to present a simple flattened single view of the data to a particular group of end users.

Select an option, then click Submit answer.

• ○ Use a Business Intelligence tool for in-memory computation to improve performance.
• ○ Configure a dedicated virtual warehouse for the Store Manager team.
• ○ Configure the virtual warehouse to be multi-clustered.
• ○ Configure the virtual warehouse to size 4-XL.
• ○ Advise the Store Manager team to defer report execution to off-business hours.

Select an option, then click Submit answer.

• ○ It expects a header to be present in the CSV file, which is matched to a case-sensitive table column name.
• ○ The parameter will be ignored.
• ○ The command will return an error.
• ○ The command will return a warning stating that the file has unmatched columns.

Select an option, then click Submit answer.

• ○ Developers create their own datasets to work against transformed versions of the live data.
• ○ Production and development run in different databases in the same account, and Developers need to see production-like data but with specific columns masked.
• ○ Data is in a production Snowflake account that needs to be provided to Developers in a separate development/testing Snowflake account in the same cloud region.
• ○ Developers create their own copies of a standard test database previously created for them in the development account, for their initial development and unit testing.
• ○ The release process requires pre-production testing of changes with data of production scale and complexity. For security reasons, pre-production also runs in the production account.

Select an option, then click Submit answer.

• ○ Increase the size of the virtual warehouse.
• ○ Increase the maximum number of clusters for the virtual warehouse.
• ○ Define a clustering key on columns used for selective filtering with a high clustering depth.
• ○ Ensure primary keys and foreign keys are defined for large tables referenced by the query.
• ○ Decrease the data retention period for tables referenced by the query.

Select an option, then click Submit answer.

• ○ DB_OWNER
• ○ OBJECT_OWNER
• ○ SECURITYADMIN
• ○ SYSADMIN

Select an option, then click Submit answer.

• ○ SYSTEM$ALLOWLIST()
• ○ SYSTEM$GET_PRIVATELINK
• ○ SYSTEM$AUTHORIZE_PRIVATELINK
• ○ SYSTEM$ALLOWLIST_PRIVATELINK()

Select an option, then click Submit answer.

• ○ Data Vault modeling
• ○ Dimensional data modeling
• ○ Star schema modeling
• ○ Snowflake schema modeling

Select an option, then click Submit answer.

• ○ Define a schema for the data before it is loaded from the application, so that it is loaded in a structured way and easy to build reports on top.
• ○ Load the semi-structured data into Snowflake and after minimal transformations, query it for the reports.
• ○ For the data that only has top-level key-value pairs and no nesting, load it in semi-structured format. For more complex data, define a schema and then load it in a structured table.
• ○ Share the data in the third normal form (3NF). Load the data in semi-structured format and apply transformations to normalize the data for reporting.

Select an option, then click Submit answer.

• ○ select o[customer][name][first]::string as first_name from contacts_data;
• ○ select o['customer']['name']['first']::string as first_name from contacts_data;
• ○ select o:['customer']:['name']:['first']::string as first_name from contacts_data;
• ○ select 0:Customer.Name.First::string as first_name from contacts_data;
• ○ select 0:customer.name.first::string as first_name from contacts_data;

Select an option, then click Submit answer.

• ○ Isolated compute and shared storage allowing data teams to manage their own workloads.
• ○ Data sharing, the Snowflake Marketplace, and the Data Exchange supporting the Data Mesh publish-and-serve model.
• ○ Dynamic Data Masking ensuring that data is always masked with hashing functions.
• ○ Materialized views supporting that external tables in the mesh are visible from all databases and accounts.
• ○ Built-In data governance managing the visibility and accessibility of data product components.
• ○ Federated authentication supporting external user access to Snowflake data products accounts.

Select an option, then click Submit answer.

• ○ Use Time Travel to recover the data using this command: SELECT * FROM employees BEFORE(statement => ‘01a5c8b3-0601-ad2b-0067-a503000al312’);
• ○ Use Time Travel with the timestamp to recover the data using this command: SELECT * FROM employees AT(timestamp => ‘2022-07-22 16:35:00.000 -0700’::timestamp_tz);
• ○ Revert to the original employees table using this command: UNDROP TABLE employees;
• ○ Rename the new employees table and undrop the original employees table using this command: ALTER TABLE employees rename to employees_bad; UNDROP TABLE employees;

Select an option, then click Submit answer.

• ○ Use a third-party orchestration tool to execute the transformation pipeline at 5 minute intervals.
• ○ Create a series of views that contain the transformation logic, so that the user can query the views and have access to new data as soon as it arrives.
• ○ Create a task that runs at 5 minute intervals and executes a merge statement that queries the table. Then process any rows that have arrived since the last time the pipeline was executed.
• ○ Create a stream on the landing table. Then create a task to run a transformation pipeline at 5 minute intervals using the SYSTEM$STREAM_HAS_DATA function.

Select an option, then click Submit answer.

• ○ Configure SAML 2.0 to authenticate users in the Snowflake environment.
• ○ Configure detailed logging and monitoring of all network traffic to and from Snowflake using Snowflake’s native capabilities.
• ○ Use public endpoints with SSL encryption to secure data transfers between Snowflake and the company’s AWS infrastructure.
• ○ Configure network policies to restrict access to Snowflake based on IP ranges corresponding to corporate offices.
• ○ Use AWS PrivateLink to establish private connectivity between the company’s Snowflake account and its AWS VPCs.