Explanation: In versions earlier than SQL Server 2012, the number of partitions was limited to 1,000 by default. 2. Point out the correct statement :
A. On x86-based systems, creating a table or index with more than 1000 partitions is possible
B. Compressing large tables or indexes can have manageability and performance benefit
C. Partitioning slow tables or indexes can have the following manageability and performance benefit
D. None of the mentioned
Answer:A
Explanation: In versions earlier than SQL Server 2012, the number of partitions was limited to 1,000 by default. 2. Point out the correct statement :
A. On x86-based systems, creating a table or index with more than 1000 partitions is possible B. Compressing large tables or indexes can have manageability and performance benefit C. Partitioning slow tables or indexes can have the following manageability and performance benefit D. None of the mentioned
Explanation:Partioning feature is not supported on x86 system. 3. __________ is a database object that defines how the rows of a table or index are mapped to a set of partitions based on the values of certain column