- Home
- Microsoft
- Administering a SQL Database Infrastructure
- Microsoft.70-764.v2020-02-03.q100
- Question 29
Valid 70-764 Dumps shared by ExamDiscuss.com for Helping Passing 70-764 Exam! ExamDiscuss.com now offer the newest 70-764 exam dumps, the ExamDiscuss.com 70-764 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-764 dumps with Test Engine here:
Access 70-764 Dumps Premium Version
(452 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 29/100
You have a data warehouse that stores sales data. One fact table has 100 million rows.
You must reduce storage needs for the data warehouse.
You need to implement a solution that uses column-based storage and provides real-time analytics for the operational workload.
Solution: You implement a columnstore index on the fact table.
Does the solution meet the goal?
You must reduce storage needs for the data warehouse.
You need to implement a solution that uses column-based storage and provides real-time analytics for the operational workload.
Solution: You implement a columnstore index on the fact table.
Does the solution meet the goal?
Correct Answer: A
Explanation
Columnstore indexes are the standard for storing and querying large data warehousing fact tables. It uses column-based data storage and query processing to achieve up to 10x query performance gains in your data warehouse over traditional row-oriented storage, and up to 10x data compression over the uncompressed data size.
In SQL Server, rowstore refers to table where the underlying data storage format is a heap, a clustered index, or a memory-optimized table.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview
Columnstore indexes are the standard for storing and querying large data warehousing fact tables. It uses column-based data storage and query processing to achieve up to 10x query performance gains in your data warehouse over traditional row-oriented storage, and up to 10x data compression over the uncompressed data size.
In SQL Server, rowstore refers to table where the underlying data storage format is a heap, a clustered index, or a memory-optimized table.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview
- Question List (100q)
- Question 1: Background Corporate Information Fabrikam, Inc. is a retaile...
- Question 2: Note: This question is part of a series of questions that pr...
- Question 3: You administer a Microsoft SQL Server 2016 database that has...
- Question 4: You are planning the deployment of two new Always On Failove...
- Question 5: You are the database administrator for a Microsoft SQL Serve...
- Question 6: You have a SQL Azure database named Database1. You need to d...
- Question 7: Note: This question is part of a series of questions that pr...
- Question 8: You administer a Microsoft SQL Server 2016 instance. The ins...
- Question 9: Overview You are a database administrator for a company name...
- Question 10: You are a database administrator for Contoso, LTD, You confi...
- Question 11: Note: This question is part of a series of questions that us...
- Question 12: Note: This question is part of a series of questions that us...
- Question 13: You have a Microsoft SQL Server instance that hosts a databa...
- Question 14: You use SQL Server 2014. You need to create a single object ...
- Question 15: Note: This question is part of a series of questions that us...
- Question 16: Note: This question is a part of a series of questions that ...
- Question 17: You need to validate rows before they are added to a table e...
- Question 18: Overview General Overview ADatum Corporation has offices in ...
- Question 19: Note: This question is part of a series of questions that us...
- Question 20: Note: This question is part of a series of questions that us...
- Question 21: Note: This question is part of a series of questions that us...
- Question 22: Note: This question is part of a series of questions that pr...
- Question 23: You deploy a database by using SQL Server 2012. The database...
- Question 24: A Microsoft SQL Server database named DB1 has two filegroups...
- Question 25: You are designing an authentication strategy for a new serve...
- Question 26: Note: This question is part of a series of questions that pr...
- Question 27: You have a query that is used by a reporting dashboard. User...
- Question 28: You administer a Microsoft SQL Server 2016 database. You wan...
- Question 29: You have a data warehouse that stores sales data. One fact t...
- Question 30: You manage a Microsoft SQL Server instance that has a databa...
- Question 31: You have a database. The existing backups for the database a...
- Question 32: Background Corporate Information Fabrikam, Inc. is a retaile...
- Question 33: Note: This question is part of a series of questions that pr...
- Question 34: You have a server named Server1 that has 16 processors. You ...
- Question 35: Your company hosts Microsoft SQL Server instances for custom...
- Question 36: Note: This question is part of a series of questions that pr...
- Question 37: You need to recommend a backup process for an Online Transac...
- Question 38: Overview Application Overview Contoso, Ltd., is the develope...
- Question 39: Overview You are a database administrator for a company name...
- Question 40: You have two databases named DB1 and DB2 that are located on...
- Question 41: You use SQL Azure to store data used by an e-commerce applic...
- Question 42: You administer a Microsoft SQL Server 2016 database. You pro...
- Question 43: You are configuring log shipping for a Microsoft SQL Server ...
- Question 44: Overview General Overview ADatum Corporation has offices in ...
- Question 45: Note: This question is part of a series of questions that us...
- Question 46: You need to address the requirements for disc usage monitori...
- Question 47: You have a database named DB1. Users report that queries tha...
- Question 48: You have a database named DB1. DB1 contains a table named Sa...
- Question 49: Note: This question is part of a series of questions that pr...
- Question 50: Note: This question is part of a series of questions that us...
- Question 51: You are designing a database named DB1. Changes will be depl...
- Question 52: You are troubleshooting an application that runs a query. Th...
- Question 53: You define a table by using the following statement. (Exhibi...
- Question 54: You have four databases that are accessed by using an Online...
- Question 55: Note: This question is part of a series of questions that pr...
- Question 56: You work as a Database Administrator (DBA) for a company nam...
- Question 57: Note: This question is part of a series of questions that pr...
- Question 58: Note: This question is part of a series of questions that us...
- Question 59: You use Microsoft SQL Server 2016 to write code for a transa...
- Question 60: Note: This question is part of a series of questions that us...
- Question 61: You need to recommend the actions that are required to parti...
- Question 62: You use SQL Server 2014 to maintain the data used by applica...
- Question 63: You administer all the deployments of Microsoft SQL Server 2...
- Question 64: Your organization is developing a web application. The appli...
- Question 65: Note: This question is part of a series of questions that pr...
- Question 66: Note: This question is part of a series of questions that pr...
- Question 67: You plan to deploy a database by using SQL Server 2014. Your...
- Question 68: Note: This question is part of a series of questions that us...
- Question 69: Note: This question is part of a series of questions that pr...
- Question 70: You have five servers that run Microsoft SQL Server, Each se...
- Question 71: You plan to implement a fault tolerance solution for a Micro...
- Question 72: A company has an on-premises Microsoft SQL Server environmen...
- Question 73: General Overview You are the Senior Database Administrator (...
- Question 74: Note: This question is part of a series of questions that pr...
- Question 75: Note: This question is part of a series of questions that us...
- Question 76: An organization deploys Microsoft SQL Server instances at a ...
- Question 77: You are a database administrator at Contoso, Ltd. You are pr...
- Question 78: You have a Microsoft SQL Server database named DB1. Nested a...
- Question 79: Note: This question is part of a series of questions that pr...
- Question 80: General Overview You are the Senior Database Administrator (...
- Question 81: You administer a Microsoft SQL Server 2016 server. When tran...
- Question 82: You store Microsoft SQL Server backups at an off-site locati...
- Question 83: Note: This question is part of a series of questions that pr...
- Question 84: You have a table that contains a column named Department. Ea...
- Question 85: You work as a Database Administrator (DBA) at ABC.com. You a...
- Question 86: Note: This question is part of a series of questions that us...
- Question 87: Note: This question is part of a series of questions that us...
- Question 88: Note: This question is part of a series of questions that pr...
- Question 89: You have a Microsoft SQL Server instance that has database n...
- Question 90: You administer all the deployments of Microsoft SQL Server 2...
- Question 91: Note: This question is part of a series of questions that pr...
- Question 92: You are configuring a new Microsoft SQL Server Always On Ava...
- Question 93: Note: This question is part of a series of questions that us...
- Question 94: You have 10 Microsoft SQL Server 2016 servers. You deploy a ...
- Question 95: Note: This question is part of a series of questions that pr...
- Question 96: Note: This question is part of a series of questions that pr...
- Question 97: You work as a Database Administrator (DBA) for a company nam...
- Question 98: Which feature should you enable and configure so session req...
- Question 99: You have a Microsoft SQL Server instance that hosts a databa...
- Question 100: Note: This question is part of a series of questions that pr...
