Identify the missing word(s) in the following azure video
dp-300-database-admin-assoc video for identify the missing word(s) in the following sentence within the context of Microsoft Azure. Index design is a little bit
Full Certification Question
Identify the missing word(s) in the following sentence within the context of Microsoft Azure. Index design is a little bit art and a little bit science. A narrow index with few columns in its key requires less time to update and has lower maintenance overhead; however it may not be useful for as many queries as a wider index that includes more columns. Columnstore indexes were introduced to offer improved performance for queries that run large aggregation workloads. This type of index was originally targeted at data warehouses, but over time they have been used in a number of other workloads in order to help solve query performance issues on large tables. [?] are typically used in two scenarios: When a column in the table has a data type that is not supported in a columnstore index. Most data types are supported but XML, CLR, sql_variant, ntext, text, and image are not supported in a columnstore index. Since a clustered columnstore always contains all the columns of the table (because it IS the table), a nonclustered is the only option. As a filtered index—this scenario is used in an architecture called hybrid transactional analytic processing (HTAP), where data is being loaded into the underlying table, and at the same time reports are being run on the table. By filtering the index (typically on a date field), this design allows for both good insert and reporting performance.