ARA-C01 無料問題集「Snowflake SnowPro Advanced Architect Certification」

（A）IMPORT PRIVILEGES;

（B）IMPORT SHARE;

（C）CREATE DATABASE;

（D）CREATE SHARE;

（E）IMPORT DATABASE;

（A）Notifications identify the cloud storage event and the actual data in the files.

（B）Snowflake can process all older notifications when a paused pipe Is resumed.

（C）When a pipe Is paused, event messages received for the pipe enter a limited retention period.

（D）The load history is stored In the metadata of the target table.

（A）Assign the accountadmin role to the user who is executing the object.

（B）Determine if there are ownership privileges on the masking policy that would allow the use of any function.

（C）Set masking policy conditions using is_role_in_session targeting the role in use for the current account.

（D）Set masking policy conditions using current_role targeting the role in use for the current session.

（E）Set masking policy conditions using invoker_role targeting the executing role in a SQL statement.

（A）lnmon/3NF

（B）Graph model

（C）Data vault

（D）Data lake

（E）Dimensional/Kimball

（F）Bayesian hierarchical model

（A）FAIL

（B）SKIP_FILE

（C）CONTINUE

（D）ABORT_STATEMENT

（A）Stored procedure

（B）Stream

（C）Secure view

（D）Standard view

（E）External table

（A）Create a clustering key that contains all columns used in the access paths.

（B）Create multiple materialized views with different cluster keys.

（C）Create super projections that will automatically create clustering.

（D）Create multiple clustering keys for a table.

（A）At the table level (TMK)

（B）At the account level (AMK)

（C）At the root level (HSM)

（D）At the micro-partition level

（A）Create an additional table in the schema for longitude and latitude. Determine a regular task to fill this information by extracting it from the JSON dataset.

（B）Divide the table into several tables for each year by using the timeframe information from the JSON dataset in order to process the queries in parallel.

（C）Divide the table into several tables for each location by using the location address information from the JSON dataset in order to process the queries in parallel.

（D）Add search optimization service on the variant column for longitude and latitude in order to query the information by using specific metadata.

（A）The company must use a specific network policy for certain users to allow and block given IP addresses.

（B）The company needs to share data between two databases, where one must support Payment Card Industry Data Security Standard (PCI DSS) compliance but the other one does not.

（C）The company security policy mandates the use of different Active Directory instances for the development, test, and production environments.

（D）The company needs to support different role-based access control features for the development, test, and production environments.

（E）The company wants to clone a production database that resides on AWS to a development database that resides on Azure.