PrepAway - Latest Free Exam Questions & Answers

Which steps should you take?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
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.

B.
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.

C.
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.

D.
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.


Leave a Reply