A scenario, in which the transactional record (Fact) would have come into the system but the corresponding Dimension/Contextual data is yet to come in, which could be due to various reasons like Improperly Designed Data Load Process, Failure in the ETL Process, and a Technical Glitch in the transactional system causing delay in pushing the Dimension Data.How is this situation handled by SSAS?

By creating an Unknown Member.
It generates an error during processing the dimension.
It generates an error while creating the dimension.
This should be taken care in during the ETL process and not while creating the cube.
Verified Answer
Correct Option - a

To get all Infosys Certified Microsoft SSAS Developer Exam questions Join Group https://bit.ly/infy_premium_group

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in