BCS PDP9 Exam
BCS Practitioner Certificate in Data Protection

Join the PDP9 Discussion

mark Commented on July 26, 2025
very interesting
EUROPEAN UNION

Kannamani Ramasamy Commented on July 26, 2025
Good practice questions
Anonymous

lp Commented on July 25, 2025
good set of questions to help prep
UNITED STATES

gm Commented on July 25, 2025
Question 59 - False. In Snowflake, when a role is created, the role that is active at the time of creation is assigned ownership, not the individual user. This ownership can be transferred to another role using the GRANT OWNERSHIP command.
SINGAPORE

gm Commented on July 25, 2025
Question 48 - ? They roll up and release approximately monthly, but customers can request early release application. - While behavior changes are bundled monthly, releases themselves are weekly. Early access is available for Enterprise Edition and higher, but this applies to weekly releases, not monthly rollups. ? A customer is assigned a 30-minute window during which the system will be unavailable and upgraded. - Snowflake upgrades are seamless and do not involve downtime. Customers are not assigned maintenance windows.
SINGAPORE

gm Commented on July 25, 2025
Question 42 - Explaining why not others ? Snowflake tables are the physical instantiation of data: This is misleading because Snowflake abstracts physical storage from users. ? Clustering keys are required for optimal performance: Clustering keys are optional and used for very large tables to improve query performance, but not required. ? Snowflake tables are owned by a user: Tables are owned by roles, not individual users, as part of Snowflake's role-based access control (RBAC) model.
SINGAPORE

MK Commented on July 25, 2025
excellent website for preparing for the ms 900 exam
UNITED STATES

gm Commented on July 25, 2025
Question 37: Explaination - Here are the three correct statements about Snowflake data loading: ? VARIANT "null" values are not the same as SQL NULL values In Snowflake, the string "null" stored in a VARIANT column is treated as a string, not as a SQL NULL. This distinction is important when querying or transforming semi-structured data like JSON. ? It is recommended to validate the data before loading into the Snowflake target table Validating data helps ensure integrity, prevents errors during loading, and avoids polluting production tables with bad or malformed data. ? It is recommended to use staging tables to manage MERGE statements Staging tables allow for cleaner, more controlled data transformations and help manage complex MERGE operations efficiently. ? It is recommended to do frequent, single row DMLs This is not recommended. Snowflake is optimized for bulk operations. Frequent single-row DMLs (INSERT, UPDATE, DELETE) can be inefficient and costly.
SINGAPORE

gm Commented on July 25, 2025
True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake. Answer should be False because Snowflake provides standard JDBC and ODBC drivers that allow connections from tools supporting these standards
SINGAPORE

gm Commented on July 25, 2025
Helpful questions
SINGAPORE

Ankitha Commented on July 25, 2025
Its very useful
UNITED STATES

ADB Commented on July 25, 2025
very relevant questions providing accurate answers which helps in certification preparation
INDIA

Ricardo Nelumba Commented on July 25, 2025
On question 49, answer B makes more sense because Athena requires files to be in queryable formats (e.g., CSV/JSON), not audio/text transcripts. Glacier Select has high latency (hours).
Anonymous

Nayeh Commented on July 25, 2025
Anyone passed exam recently? shade a light on questions asked from here
Anonymous

ADB Commented on July 25, 2025
this questions provides contextual insights for exam preparations
INDIA

cc Commented on July 25, 2025
nice questions
JAPAN

cuuns Commented on July 25, 2025
good questioins
JAPAN

harry Commented on July 25, 2025
great content
JAPAN

BV Commented on July 25, 2025
The answer to question 34 is incorrect. It should be: ALTER TABLE ... ADD CONSTRAINT ... PRIMARY KEY NONCLUSTERED NOT ENFORCED Fabric does not support clustered index primary keys and does not support enforcing constraints.
CANADA

Maarten Commented on July 25, 2025
Looking good
NETHERLANDS