Domain 2: watsonx.data Fundamentals

IBM Certified watsonx Data Lakehouse Engineer v1 - Associate · 64 questions

• What is the core architectural principle of IBM watsonx.data?
• What is the primary function of Infrastructure Manager in watsonx.data?
• In watsonx.data; when should you choose Spark over Presto for a workload?
• Which statement about Presto in IBM watsonx.data is correct?
• What is the role of the IBM Hive Metastore built into watsonx.data?
• When would you connect an external Hive Metastore to watsonx.data instead of using the built-in one?
• What is IBM Cloud Object Storage (COS) used for in a watsonx.data deployment?
• Why is watsonx.data compatible with AWS S3 storage?
• Through which watsonx.data component would you register a new object storage bucket for use as a lakehouse data store?
• How are Apache Iceberg tables typically created and managed in watsonx.data?
• What does the data catalog in watsonx.data provide to end users?
• How does IBM Cloud Pak for Data integrate with watsonx.data?
• What capability in watsonx.data allows different types of SQL queries to be automatically directed to the most appropriate engine?
• What key benefit does watsonx.data's shared metadata layer provide when multiple engines query the same table?
• On which platforms can IBM watsonx.data be deployed?
• Before a Presto engine in watsonx.data can query a table; what must be done first?
• Which data formats does watsonx.data natively support for data stored in object storage?
• How does IBM Knowledge Catalog complement watsonx.data?
• What is the relationship between IBM watsonx.data and IBM watsonx.ai?
• What happens to data in watsonx.data when a Presto or Spark engine is paused?
• Which catalog types can be registered in IBM watsonx.data?
• What mechanism does Presto use in watsonx.data to query different data sources like Db2; PostgreSQL; and object storage?
• When you run CREATE SCHEMA in watsonx.data's Presto engine; where is the schema definition stored?
• Which UI section in IBM watsonx.data would you use to browse tables and preview data?
• How does a Spark engine in watsonx.data access tables managed by the IBM Hive Metastore?
• How does IBM watsonx.data's pricing model differ from traditional data warehouse pricing?
• Which open specification does IBM watsonx.data use to enable interoperability of Iceberg tables with external engines?
• A watsonx.data administrator wants to add a second Presto engine dedicated to ETL workloads. What is the correct tool to use?
• After registering a new object storage bucket in watsonx.data; what additional step is required before a Presto engine can query tables stored in that bucket?
• An architect is describing the watsonx.data architecture to a new team. Which statement correctly characterises the relationship between the storage layer and the query engines?
• An organisation must keep certain regulated datasets inside its own data centre but wants elastic compute for analytics on non-regulated data. Which deployment approach for watsonx.data fits?
• A finance team asks to control who can read a sensitive table in the lakehouse. Where should that control be applied?
• An organisation runs both interactive BI queries and long-running batch transformations against the same lakehouse tables. What is the recommended design?
• A team lists the components involved when an analyst runs a query in watsonx.data. Which sequence reflects how the platform actually satisfies the request?
• A pilot ran on a single-node local install and worked well. The team proposes the same topology for production, serving several hundred analysts. What should the review raise?
• Why is it a poor practice for analysts to manage access by copying data into CSV extracts they share among themselves?
• What is the main drawback of running every workload on a single engine regardless of fit?
• A team proposes managing table permissions inside their BI tool rather than in watsonx.data, arguing that all reporting goes through that tool anyway. Why is this a weak design?
• A deployment plan for watsonx.data covers sizing, storage and engine topology but does not mention how users will authenticate or how the platform reaches existing systems on the corporate network. Why does this matter?
• Which capability lets a governance team answer the question "where did this table's data come from and what transformed it?"
• A team proposes giving each engine its own private copy of the data so engines never interfere. What is wrong with this?
• During a capacity review, a team asks whether adding a second query engine to watsonx.data will require duplicating the data those queries read. What is the correct answer?
• Which factor should most directly drive the choice between deploying watsonx.data on-premises, in the cloud, or as a hybrid?
• A team proposes dropping formal schema definitions so their tables can "stay flexible" as requirements change. What is the main problem with this?
• When a user switches from one engine to another to run the same query, what happens to the governance controls on the data?
• A stakeholder asks what distinguishes watsonx.data from simply keeping Parquet files in a bucket and pointing a query tool at them. Which answer best captures the difference?
• An organisation with substantial existing on-premises data infrastructure wants to adopt watsonx.data without decommissioning those systems. Which characteristic of the platform most supports this?
• An organisation governs only the dashboards its executives see, leaving the underlying tables uncontrolled. What risk does this create?
• Which factor should primarily drive the choice of engine for a given workload?
• A design document for a new watsonx.data deployment lists buckets, catalogs and engines, together with how they will be associated, but says nothing about who may access which tables. What is missing?
• A customer's compliance team requires that a specific dataset never leave a designated jurisdiction, while analysts in another region need to run reports that include aggregates from it. Which design satisfies both?
• A proof of concept is being promoted to production. Which governance work is required before data is opened to a wider audience?
• Interactive dashboard queries have become slow since a nightly transformation job was moved onto the same engine. What is the appropriate remedy?
• Which description best fits the role of the catalog in watsonx.data?
• A team is choosing between a managed cloud deployment and a self-operated installation. Which consideration most favours the managed option?
• What is the role of metadata in keeping lakehouse data trustworthy?
• What is the architectural benefit of supporting multiple query engines over one shared set of governed data?
• A proof of concept used one engine, one catalog and one bucket, all created by a single administrator working in the console. Moving to production, which platform capability becomes essential that the proof of concept did not exercise?
• After deploying watsonx.data, analysts can sign in but every one of them sees only an empty catalog list, while the administrator sees all catalogs. What is the most likely cause?
• An auditor asks who has been able to read a regulated table over the past quarter. Which combination answers the question?
• Which statement about engine selection in watsonx.data is correct?
• In watsonx.data, which two components must both be correct before a user can successfully read rows from a specific table?
• Which statement best reflects how deployment choices should be made for watsonx.data?
• Which statement best summarises how watsonx.data keeps lakehouse data trustworthy?