• I think the correct answer should be worded slightly differently: "Either one can be appropriate" (italics used to emphasize changed part).

    If forced to make a choice based on the limited information given, my second choice would be a relational design with some XML columns for the less- and un-structured data.

    (My first choice would be to first read the documentation and conduct some interviews)


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/