Summer Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

P2090-011 Questions and Answers

Note! Following P2090-011 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

P2090-011 Questions and Answers

Question # 6

Which of the following replication methods is best suited for de-normalizing tables?

A.

Adaptive Apply

B.

Summarization

C.

Consolidation ?One-to-One

D.

Consolidation ?One-to-Many

Full Access
Question # 7

A CDC administrator is being asked to replicate warehouse data to a reporting server in order to facilitate generating daily, weekly, and monthly performance reports for the management. Which of the following setups, in your opinion, is considered a 'best practice'?

A.

Replicate all tables using "Refresh" mode but run them once a day, week, or month

B.

Replicate all tables using "Mirror Continuous" mode but run them once a day, week, or month

C.

Replicate all tables using "Mirror Continuous" method and run them continuously

D.

Replicate only "Summarized" data using "Mirror Continuous" method and run them once a day, week, or month as necessary

Full Access