Question 1
You are analyzing a known table with a five column primary key. You wish to confirm its uniqueness with minimal processing time.
Which steps should you take?
Select only the five columns and run Multi-column Primary Key Analysis with Multi-column option = Concatenate. Review Primary Key Analysis on the Multi-column tab.
Select only the five columns and run Multi-column Primary Key Analysis with Composite Key Maximum Columns = 5. Review Primary Key Analysis on the Multi-column tab.
Create a Virtual Column including only the five columns, select the Virtual Column and run Column Analysis. Review Primary Key Analysis for the Virtual Column on the Single column tab.
Create a Virtual Table including only the five columns, select the Virtual Table and run Multi-column Primary Key Analysis with Composite Key Maximum Columns = 1. Review Primary Key Analysis on the Multi-column tab.
Correct answer: C