Skip to content
DEP
Data Sharing and Federation
hard
Question 6 of 10

A data engineer configures Lakehouse Federation to expose a PostgreSQL database as a foreign catalog in Unity Catalog. After setting up the connection and creating the foreign catalog, a user runs SELECT * FROM postgresql_catalog.public.customers LIMIT 100. The query is slow despite the table being small. What is the most likely explanation and remediation?

A
B
C
D

This question requires Pro

Unlock all 10 questions in this certification

Written by certified professionals · Aligned to official exam objectives

View all Pro features

Educational Content — CertQnA practice questions are written against official exam objectives, covering the same domains tested on the real exam. All content is original and independent — not actual exam questions, not affiliated with any certification vendor. Learn more about our content policy