Describe the considerations and steps involved in designing and building a large format dataset for a semantic model. Discuss how you would ensure the dataset is scalable and performs well under heavy query loads.