This page was exported from Lead2pass New Updated Exam Questions [ https://www.getfreevce.com ] Export date:Mon Dec 23 5:32:41 2024 / +0000 GMT ___________________________________________________ Title: [2018-3-16] Lead2pass Microsoft 70-764 Latest Exam Dumps Download (161-170) --------------------------------------------------- Lead2pass 2018 New Microsoft 70-764 Braindump Free Download.v.2018-3-16.332q: https://www.lead2pass.com/70-764.html QUESTION 161Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a data warehouse that stored 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 remove all clustered indexes, sort the transactions in the table, and create a clustered index on the table, so that the table is not a heap. Does the solution meet the goal? A.    YesB.    No Answer: AExplanation: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 162Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a data warehouse that stored 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 load the data in a heap table. Does the solution meet the goal? A.    YesB.    No Answer: BExplanation:It is better to use a clustered index.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 163Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a data warehouse that stored 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 generate a new certificate on new instance. Does the solution meet the goal? A.    YesB.    No Answer: BExplanation:Certificates are of no use in this scenario. QUESTION 164Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You attempt to restore a database on a new SQL Server instance and receive the following error message: "Msg 33111, Level 16, State 3, Line 2Cannot find server certificate with thumbprint`0x7315277C70764B1F252DC7A5101F6F66EFB1069D." You need to ensure that you can restore the database successfully. Solution: You add the backup set password to the restore command.Does this meet the goal? A.    YesB.    No Answer: BExplanation:The error is related to the certificate.References: https://dba.stackexchange.com/questions/3388/restore-encrypted-database-to-another-server?rq=1 QUESTION 165Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You attempt to restore a database on a new SQL Server instance and receive the following error message: "Msg 33111, Level 16, State 3, Line 2Cannot find server certificate with thumbprint`0x7315277C70764B1F252DC7A5101F6F66EFB1069D." You need to ensure that you can restore the database successfully. Solution: You restore the certificate on the new instance. Does this meet the goal? A.    YesB.    No Answer: AExplanation:The error is related to the certificate.References: https://dba.stackexchange.com/questions/3388/restore-encrypted-database-to-another-server?rq=1 QUESTION 166Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a database that includes a table named Candidate. You need to update the statistics for a column named Skills in the table and turn off automatic statistics updates for the column. Solution: You run the following query: Does this meet the goal? A.    YesB.    No Answer: AExplanation:FULLSCAN: Compute statistics by scanning all rows in the table or indexed view. FULLSCAN and SAMPLE 100 PERCENT have the same results.References: https://technet.microsoft.com/en-us/library/ms187348(v=sql.110).aspx QUESTION 167Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a database that includes a table named Candidate. You need to update the statistics for a column named Skills in the table and turn off automatic statistics updates for the column. Solution: You run the following query: Does this meet the goal? A.    YesB.    No Answer: AExplanation:The following example updates the Products statistics in the Product table, forces a full scan of all rows in the Product table, and turns off automatic statistics for the Products statistics.USE AdventureWorks2012;GOUPDATE STATISTICS Production.Product(Products)WITH FULLSCAN, NORECOMPUTE;Note: NORECOMPUTEDisable the automatic statistics update option, AUTO_UPDATE_STATISTICS, for the specified statistics. If this option is specified, the query optimizer completes this statistics update and disables future updates.To re-enable the AUTO_UPDATE_STATISTICS option behavior, run UPDATE STATISTICS again without the NORECOMPUTE option or run sp_autostats.References: https://docs.microsoft.com/en-us/sql/t-sql/statements/update-statistics-transact-sql QUESTION 168Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a database that includes a table named Candidate. You need to update the statistics for a column named Skills in the table and turn off automatic statistics updates for the column. Solution: You run the following query: Does this meet the goal? A.    YesB.    No Answer: BExplanation:RESAMPLE: Update each statistic using its most recent sample rate.References: https://docs.microsoft.com/en-us/sql/t-sql/statements/update-statistics-transact-sql QUESTION 169Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a server named Server1 that has Microsoft SQL Server installed. Server1 has SQL Server Audit configured to send audit even records to a file. You need to ensure that a database user named User1 can review the audit data. Solution: You grant the VIEW SERVER STATE permission to User1. Does this meet the goal? A.    YesB.    No Answer: AExplanation:Each feature and command for SQL Server Audit has individual permission requirements.Unless otherwise specified, viewing catalog views requires a principal to have one of the following:The VIEW SERVER STATE permission.The VIEW AUDIT STATE permission (gives only the principal access to the sys.server_audits catalog view).Membership in the sysadmin fixed server role.The CONTROL SERVER permission.The ALTER ANY AUDIT permission.A principal must have the VIEW SERVER STATE or ALTER ANY AUDIT permission to use the Dynamic Management Views.References: https://technet.microsoft.com/en-us/library/cc280665(v=sql.105).aspx QUESTION 170Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a server named Server1 that has Microsoft SQL Server installed. Server1 has SQL Server Adult configured to send audit even records to a file. You need to ensure that a database user named User1 can review the audit data. Solution: You assign the db_datareader role to User1. Does this meet the goal? A.    YesB.    No Answer: BExplanation:Each feature and command for SQL Server Audit has individual permission requirements.Unless otherwise specified, viewing catalog views requires a principal to have one of the following:The VIEW SERVER STATE permission.The VIEW AUDIT STATE permission (gives only the principal access to the sys.server_audits catalog view).Membership in the sysadmin fixed server role.The CONTROL SERVER permission.The ALTER ANY AUDIT permission.A principal must have the VIEW SERVER STATE or ALTER ANY AUDIT permission to use the Dynamic Management Views.References: https://technet.microsoft.com/en-us/library/cc280665(v=sql.105).aspx 70-764 dumps full version (PDF&VCE): https://www.lead2pass.com/70-764.html Large amount of free 70-764 exam questions on Google Drive: https://drive.google.com/open?id=0B3Syig5i8gpDUjBoM0pVQnlUTlU You may also need: 70-761 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDU2RSQnhzX2pIZVE 70-762 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDMW9NcjJrQXlsMGs 70-765 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDejczeWp0aURaSnM 70-767 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDdTF0R0taLWgxSmc 70-768 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDZ2pRQkV6Vnc4dHc --------------------------------------------------- Images: http://examgod.com/l2pimage/aa4bcfa9be73_C5CE/1661_thumb.png http://examgod.com/l2pimage/aa4bcfa9be73_C5CE/1671_thumb.png http://examgod.com/l2pimage/aa4bcfa9be73_C5CE/1681_thumb.png --------------------------------------------------- --------------------------------------------------- Post date: 2018-03-20 06:30:22 Post date GMT: 2018-03-20 06:30:22 Post modified date: 2018-03-20 06:30:22 Post modified date GMT: 2018-03-20 06:30:22 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com