Domain 5: Consumption

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

• Which interface provides an interactive SQL editor for running Presto queries in IBM watsonx.data?
• How does IBM Cognos Analytics consume data from watsonx.data?
• How would a data scientist connect a Jupyter Notebook to watsonx.data to query Iceberg tables?
• What does watsonx.data's REST API enable for application developers?
• A BI developer wants to connect a third-party SQL client (DBeaver) to watsonx.data. What is the recommended approach?
• How does the cost-based optimizer (CBO) in Presto improve query performance in watsonx.data?
• A data analyst queries a large sales table partitioned by region and year. Which query pattern enables partition pruning?
• How would IBM SPSS Modeler access data stored in watsonx.data for predictive modeling?
• What benefit does result set caching provide in watsonx.data query workloads?
• What is the advantage of using materialized views in watsonx.data for frequently executed aggregate queries?
• A business user in the Finance department should only see finance-related tables in watsonx.data. How is this implemented?
• A data analyst has run a complex aggregation query in watsonx.data and needs to share the results with a stakeholder who does not have watsonx.data access. What is the appropriate approach?
• What additional information does EXPLAIN ANALYZE provide compared to EXPLAIN in Presto?
• How can a data analyst writing Presto queries in watsonx.data reduce the amount of data scanned from Parquet files?
• In watsonx.data; a BI analyst role requires read-only access to Gold-layer tables for reporting. Which privilege assignment is correct?
• What Python library would a developer use to submit SQL queries to watsonx.data Presto programmatically?
• Which statement about integrating watsonx.data with downstream analytics tools is correct?
• What does the Query History feature in watsonx.data provide to users?
• A data analyst needs to compare current sales figures with sales as they appeared 30 days ago. Which Iceberg feature enables this comparison?
• An executive dashboard powered by watsonx.data Presto shows slow load times due to expensive aggregate queries. What is the most effective architectural solution?
• A business intelligence team needs to build dashboards over curated Iceberg tables held in watsonx.data. They ask the platform team how their BI tool should reach the data. What is the appropriate answer?
• An analyst has been asked to find out why returns rose last quarter. There is no defined target variable and no hypothesis yet. Which analytic approach fits?
• An application team needs their service to read governed lakehouse tables as part of a nightly process. What is the appropriate integration approach?
• A user's query against a lakehouse table returns a permission error. What is the correct interpretation?
• An analyst has been granted access to a governed catalog in watsonx.data and wants to explore its tables and run ad hoc SQL without installing any client software. What should they use?
• A team wants to forecast next month's support ticket volume per product line. They have three years of daily history. Which approach is appropriate?
• A BI platform must connect to watsonx.data to run its scheduled reports. Which interface is intended for this?
• A query fails immediately with a message pointing at a specific position in the statement. Which cause should be investigated first?
• A department has been emailing spreadsheet extracts of lakehouse tables to its stakeholders because it finds that easier than granting platform access. A governance review flags the practice. What is the core problem?
• A dashboard applies a filter for high-value customers in a specific region and shows the resulting revenue. A manager describes this as the team's predictive model. Why is that mischaracterisation a problem?
• A developer's integration works when they run it under their own account but must now run unattended in production. What should change?
• A federated query fails while queries against native lakehouse tables succeed. What is the most likely cause?
• Two teams report different totals for the same monthly revenue figure. Investigation shows one team queries the governed lakehouse table through a Presto engine and the other maintains its own copy loaded into a departmental database. What is the sustainable fix?
• A team wants to predict which customers will churn but has never recorded whether a customer churned. What must happen before a predictive model can be built?
• Why is scraping the watsonx.data web interface an unsuitable integration strategy for an application?
• Why is increasing storage capacity before reading a query's error message an unsound response to a failure?
• An application team requests a connection to watsonx.data for a reporting tool. The platform team must supply the connection details. Which set is required for a JDBC connection to a Presto engine?
• Which statement correctly distinguishes exploratory from predictive analytics?
• An application requires programmatic access to watsonx.data and the team asks how governance applies to it. What is the correct answer?
• A query succeeds on one engine and fails on another with a function-related error. What should be examined?
• A data science team wants to read a large governed lakehouse table into notebooks for feature engineering. They ask whether they should copy the table to a local disk first for speed. What guidance fits the watsonx.data consumption model?
• A team plans to skip exploratory work and begin modelling immediately, arguing that the algorithm will find whatever matters. What is the practical risk?
• An application's queries against watsonx.data begin failing with permission errors after a governance review, though the application code has not changed. What is the most likely explanation?
• Which sequence best describes a systematic approach to a failed query?
• A dashboard built on a watsonx.data table returns no rows for one group of users while working correctly for another, and both groups run the identical query against the same engine. What is the most likely explanation?
• A manager asks whether predictive analytics can tell them which of two marketing designs to run next quarter, given that no such campaign has been run before. What is the appropriate advice?
• Which practice best supports maintainable programmatic access to watsonx.data over time?
• Why is it wrong to treat every failed query as an indication that data has been lost?
• An organization wants business users to explore lakehouse data without writing SQL, while keeping every access subject to the same governance as engineered queries. Which approach is consistent with the platform's consumption model?
• In a governed lakehouse, what is a practical advantage of doing both exploratory and predictive work against the platform's own tables rather than on extracted copies?
• A team wants an application to trigger administrative operations, such as creating a catalog association, as part of an automated deployment. What is the appropriate mechanism?
• A query worked yesterday and now returns an object-not-found error, with no infrastructure changes. What is the most likely cause?
• A platform team is defining how downstream consumers should reach curated lakehouse tables. Which principle should the standard be built on?
• A team has an exploratory finding that two product categories show markedly different return rates. What is the appropriate next step if they want to act on it operationally at scale?
• Which statement about programmatic access to watsonx.data is correct?
• Which statement best summarises query troubleshooting in watsonx.data?