You have a Microsoft Azure SQL Database. You execute the following script: You add 1 million rows to Table1. Approximat
Posted: Mon Oct 17, 2022 4:50 pm
You have a Microsoft Azure SQL Database.
You execute the following script:
You add 1 million rows to Table1. Approximately 85 percent of all the rows have a null value for Column2.
You plan to deploy an application that will search Column2.
You need to create an index on Table1 to support the planned deployment. The solution must minimize the storage requirements.
Which code segment should you execute?
A. CREATE INDEX IX_Table1 ON Table1 (Column2) WITH FILLFACTOR=0
B. CREATE INDEX IX_Table1 OK Table1 (Column1) INCLUDE (Column2)
C. CREATE INDEX IX_Table1 ON Table1 (Column2) WHERE Column2 IS NULL
D. CREATE INDEX IX_Table1 ON Table1 (Column2) WHERE Column2 IS NOT NULL
You execute the following script:
You add 1 million rows to Table1. Approximately 85 percent of all the rows have a null value for Column2.
You plan to deploy an application that will search Column2.
You need to create an index on Table1 to support the planned deployment. The solution must minimize the storage requirements.
Which code segment should you execute?
- You Have A Micr 1 (28.9 KiB) Viewed 94 times
B. CREATE INDEX IX_Table1 OK Table1 (Column1) INCLUDE (Column2)
C. CREATE INDEX IX_Table1 ON Table1 (Column2) WHERE Column2 IS NULL
D. CREATE INDEX IX_Table1 ON Table1 (Column2) WHERE Column2 IS NOT NULL