An Architect has a VPN_ACCESS_LOGS table in the SECURITY_LOGS schema containing timestamps of the connection and disconnection, username of the user, and summary statistics.
What should the Architect do to enable the Snowflake search optimization service on this table?
A. Assume role with ALL PRIVILEGES on VPN_ACCESS_LOGS and ADD SEARCH OPTIMIZATION in the SECURITY_LOGS schema.
B. Assume role with ALL PRIVILEGES including ADD SEARCH OPTIMIZATION in the SECURITY LOGS schema.
C. Assume role with OWNERSHIP on VPN_ACCESS_LOGS and ADD SEARCH OPTIMIZATION in the SECURITY_LOGS schema.
D. Assume role with OWNERSHIP on future tables and ADD SEARCH OPTIMIZATION on the SECURITY_LOGS schema.
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?
A. FAIL
B. CONTINUE
C. ABORT_STATEMENT
D. SKIP_FILE
正解:B,C,D
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
A company's client application supports multiple authentication methods, and is using Okta.
What is the best practice recommendation for the order of priority when applications authenticate to Snowflake?
A. 1) OAuth (either Snowflake OAuth or External OAuth)
2) External browser
3) Okta native authentication
4) Key Pair Authentication, mostly used for service account users
5) Password
B. 1) External browser, SSO
2) Key Pair Authentication, mostly used for development environment users
3) Okta native authentication
4) OAuth (ether Snowflake OAuth or External OAuth)
5) Password
C. 1) Password
2) Key Pair Authentication, mostly used for production environment users
3) Okta native authentication
4) OAuth (either Snowflake OAuth or External OAuth)
5) External browser, SSO
D. 1) Okta native authentication
2) Key Pair Authentication, mostly used for production environment users
3) Password
4) OAuth (either Snowflake OAuth or External OAuth)
5) External browser, SSO
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?
A. The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML.
B. The Connector only works in Snowflake regions that use AWS infrastructure.
C. The Connector creates and manages its own stage, file format, and pipe objects.
D. Loads using the Connector will have lower latency than Snowpipe and will ingest data in real time.
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
An Architect is integrating an application that needs to read and write data to Snowflake without installing any additional software on the application server.
How can this requirement be met?
A. Use SnowSQL.
B. Use the Snowpipe REST API.
C. Use the Snowflake ODBC driver.
D. Use the Snowflake SQL REST API.
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
福*美 -
出題範囲をカバーしている。解説も丁寧に。
Pass4Test高印象です。