Please check this microsoft learn link for the more details, it even mentions the limitations and impact on various services https://learn.microsoft.com/en-us/fabric/security/security-private-links-overview

@Orland Reyes no i have not implemented the private endpoints

As per my suggestion Azure Cognitive Search is a better choice for this, as it is mainly designed for this type of search functionality. and if you want to use the Fabric SQL you may need to transform your JSON documents into a relational format, which could add complexity.

To connect your Airflow jobs in the specified order within Microsoft Fabric, you can use the Apache Airflow Job feature. This allows you to create and manage Directed Acyclic Graphs DAGs that define the dependencies between tasks across different jobs. As much i am aware its a preview feature, you can try to use this.

@Liz Nwachukwu i am preparing for dp-600 and i think this can answer your question Column-Level Security (CLS) in Microsoft Fabric is a powerful feature that allows you to control access to specific columns within a table. 1.Protecting Sensitive Data: Restrict access to sensitive columns such as Social Security numbers, credit card information, or personal addresses to only those users who need it. 2.Departmental Access: Allow users from specific departments (e.g., HR, Finance) to access only the columns relevant to their roles, ensuring they don't see data outside their scope. 3.Compliance and Privacy: Ensure compliance with data privacy regulations by limiting access to personal or sensitive information based on user roles. 4.Simplified Data Views: Provide users with a simplified view of the data by hiding unnecessary columns, making it easier for them to focus on relevant information. Regarding your second question, CLS permissions can be assigned independently. Users do not need access to the entire table to benefit from CLS. You can grant or deny access to specific columns using the GRANT or DENY T-SQL statements. For example, you can allow a user to see only certain columns of a table while restricting access to others

i feel similar issue is solved in the microsoft community fabric forum. please check if this helps Solved: Re: Convert storage mode from direct query to impo... - Microsoft Fabric Community