Câu 20: ACD301: Appian Certified Lead Developer

You are optimizing a database for a loan management system that has a large table named Loan_Handlers. The table has columns such as Ticket_Id, Employee_Id, Status, and File (stored as BLOB). The table is queried often on Ticket_Id in various places within the application. The Ticket_Id is currently stored as text, even though it only contains numeric values. The Employee_Id and Status columns have inconsistent data types across related tables in the schema. Users in the system also frequently upload files. Which two steps will improve the query performance on the Loan Handlers table? (Choose two.)

1. A. Ensure that Employee_Id and Status columns have the same data type across all related tables
2. B. Implement full-text indexing on the Ticket_Id column to speed up searches.
3. C. Convert the Ticket_Id column from text to an integer type — đáp án hiện tại
4. D. Store the File column in a separate table — đáp án hiện tại