Domain 3: Operation

IBM Certified Data Engineer - watsonx.data · 58 questions

• What is the first step when provisioning IBM watsonx.data on IBM Cloud?
• Which IBM Cloud IAM role grants a user the ability to administer watsonx.data resources including creating engines and catalogs?
• What is the primary operational reason for pausing a Presto engine in watsonx.data when it is not in use?
• Where in watsonx.data can an administrator monitor the status and resource usage of currently running Presto queries?
• How can administrators monitor running Spark jobs in IBM watsonx.data?
• What is the purpose of resource groups in IBM watsonx.data?
• How would you increase the processing capacity of a Presto engine in watsonx.data to handle a spike in query load?
• In watsonx.data; what is the recommended approach for protecting Iceberg table data against accidental deletion?
• A data engineer accidentally overwrites critical data in an Iceberg table. What operational procedure can restore the table to its previous state?
• A Presto query in watsonx.data is running significantly slower than expected on an Iceberg table. Which diagnostic step should be taken first?
• A Presto engine in watsonx.data fails with 'metastore connection failed' errors. What is the most likely cause?
• Which combination of practices most effectively reduces watsonx.data operational costs?
• In watsonx.data; which access control model governs who can query specific tables?
• A workload consists of short interactive BI queries that run frequently. Which Presto engine configuration is most appropriate?
• How are user identities managed in IBM watsonx.data on IBM Cloud?
• A Presto query fails with an 'Out of memory' error in watsonx.data. What is the most appropriate first response?
• Why is it important to collect table statistics for Iceberg tables in watsonx.data?
• Where would you look to diagnose a failed Presto query that returned an ambiguous error message in watsonx.data?
• In a watsonx.data deployment with both Presto and Spark engines; how is access control enforced consistently across both engines?
• What mechanism in watsonx.data/Iceberg would you configure to automatically remove data older than 90 days from a table?
• How would you upgrade the Presto engine version in a production watsonx.data environment with minimal disruption?
• An Iceberg table's object storage size has grown excessively over six months due to retained snapshots. What operation should be run?
• In watsonx.data; what happens when multiple users submit queries simultaneously and the engine reaches its concurrency limit?
• A consultant is advising a customer that wants a scalable implementation. Which approach best demonstrates Infrastructure Manager in a IBM Certified watsonx Data Lakehouse Engineer environment?
• A project lead is turning a proof of concept into a governed production workflow. The team is focused on Data manager. Which recommendation is most appropriate?
• An administrator is troubleshooting a pilot deployment and wants the most appropriate next step. What is the best way to handle Query workspace and history while staying aligned with the certification objectives?
• During a design review, an architect asks which choice best matches the IBM guidance. For IBM Certified watsonx Data Lakehouse Engineer, the topic is access control. What should the team do?
• A team is preparing a production rollout and needs to avoid a design mistake. The team is focused on Infrastructure Manager. Which recommendation is most appropriate?
• A senior engineer reviews the current plan and notices that one key control is missing. What is the best way to handle Data manager while staying aligned with the certification objectives?
• A consultant is advising a customer that wants a scalable implementation. For IBM Certified watsonx Data Lakehouse Engineer, the topic is Query workspace and history. What should the team do?
• A project lead is turning a proof of concept into a governed production workflow. Which approach best demonstrates access control in a IBM Certified watsonx Data Lakehouse Engineer environment?
• An administrator is troubleshooting a pilot deployment and wants the most appropriate next step. What is the best way to handle Infrastructure Manager while staying aligned with the certification objectives?
• During a design review, an architect asks which choice best matches the IBM guidance. For IBM Certified watsonx Data Lakehouse Engineer, the topic is Data manager. What should the team do?
• A team is preparing a production rollout and needs to avoid a design mistake. Which approach best demonstrates Query workspace and history in a IBM Certified watsonx Data Lakehouse Engineer environment?
• A senior engineer reviews the current plan and notices that one key control is missing. The team is focused on access control. Which recommendation is most appropriate?
• A consultant is advising a customer that wants a scalable implementation. For IBM Certified watsonx Data Lakehouse Engineer, the topic is Infrastructure Manager. What should the team do?
• A project lead is turning a proof of concept into a governed production workflow. Which approach best demonstrates Data manager in a IBM Certified watsonx Data Lakehouse Engineer environment?
• An administrator is troubleshooting a pilot deployment and wants the most appropriate next step. The team is focused on Query workspace and history. Which recommendation is most appropriate?
• During a design review, an architect asks which choice best matches the IBM guidance. What is the best way to handle access control while staying aligned with the certification objectives?
• A team is preparing a production rollout and needs to avoid a design mistake. Which approach best demonstrates Infrastructure Manager in a IBM Certified watsonx Data Lakehouse Engineer environment?
• A senior engineer reviews the current plan and notices that one key control is missing. The team is focused on Data manager. Which recommendation is most appropriate?
• A consultant is advising a customer that wants a scalable implementation. What is the best way to handle Query workspace and history while staying aligned with the certification objectives?
• A project lead is turning a proof of concept into a governed production workflow. For IBM Certified watsonx Data Lakehouse Engineer, the topic is access control. What should the team do?
• An administrator is troubleshooting a pilot deployment and wants the most appropriate next step. The team is focused on Infrastructure Manager. Which recommendation is most appropriate?
• During a design review, an architect asks which choice best matches the IBM guidance. What is the best way to handle Data manager while staying aligned with the certification objectives?
• A team is preparing a production rollout and needs to avoid a design mistake. For IBM Certified watsonx Data Lakehouse Engineer, the topic is Query workspace and history. What should the team do?
• A senior engineer reviews the current plan and notices that one key control is missing. Which approach best demonstrates access control in a IBM Certified watsonx Data Lakehouse Engineer environment?
• A consultant is advising a customer that wants a scalable implementation. What is the best way to handle Infrastructure Manager while staying aligned with the certification objectives?
• A project lead is turning a proof of concept into a governed production workflow. For IBM Certified watsonx Data Lakehouse Engineer, the topic is Data manager. What should the team do?
• An administrator is troubleshooting a pilot deployment and wants the most appropriate next step. Which approach best demonstrates Query workspace and history in a IBM Certified watsonx Data Lakehouse Engineer environment?
• During a design review, an architect asks which choice best matches the IBM guidance. The team is focused on access control. Which recommendation is most appropriate?
• A team is preparing a production rollout and needs to avoid a design mistake. For IBM Certified watsonx Data Lakehouse Engineer, the topic is Infrastructure Manager. What should the team do?
• A senior engineer reviews the current plan and notices that one key control is missing. Which approach best demonstrates Data manager in a IBM Certified watsonx Data Lakehouse Engineer environment?
• A consultant is advising a customer that wants a scalable implementation. The team is focused on Query workspace and history. Which recommendation is most appropriate?
• A project lead is turning a proof of concept into a governed production workflow. What is the best way to handle access control while staying aligned with the certification objectives?
• An administrator is troubleshooting a pilot deployment and wants the most appropriate next step. Which approach best demonstrates Infrastructure Manager in a IBM Certified watsonx Data Lakehouse Engineer environment?
• During a design review, an architect asks which choice best matches the IBM guidance. The team is focused on Data manager. Which recommendation is most appropriate?
• A team is preparing a production rollout and needs to avoid a design mistake. What is the best way to handle Query workspace and history while staying aligned with the certification objectives?