- Home
- Microsoft
- Administering a SQL Database Infrastructure
- Microsoft.70-764.v2019-01-23.q241
- Question 224
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 224/241
Your company stored customer data, including credit card numbers, in a Microsoft SQL Server database.
The CreditCardNum column is configured as a varchar(16). When viewing the CreditCardNum column, only the last four digits of the card number should be displayed.
You have the following Transact-SQL statement. (Line numbers are included for reference only.)
You need to implement dynamic data masking for the CreditCardNum column.
Which Transact-SQL segment should you insert at line 05?
A:
B:
C:
D:
The CreditCardNum column is configured as a varchar(16). When viewing the CreditCardNum column, only the last four digits of the card number should be displayed.
You have the following Transact-SQL statement. (Line numbers are included for reference only.)
You need to implement dynamic data masking for the CreditCardNum column.
Which Transact-SQL segment should you insert at line 05?
A:
B:
C:
D:
Correct Answer: C
Explanation/Reference:
Explanation:
Example:
Using "partial" function
ALTER TABLE Ari_Users_Tbl ALTER COLUMN [CreditCard]
ADD MASKED WITH (FUNCTION = 'partial(0,"XXXX-XXXX-XXXX-",4)')
References: https://social.technet.microsoft.com/wiki/contents/articles/35003.sql-server-exposing-masked- data.aspx#Goal_2_Find_the_CreditCard_number_for_UserID_1
Explanation:
Example:
Using "partial" function
ALTER TABLE Ari_Users_Tbl ALTER COLUMN [CreditCard]
ADD MASKED WITH (FUNCTION = 'partial(0,"XXXX-XXXX-XXXX-",4)')
References: https://social.technet.microsoft.com/wiki/contents/articles/35003.sql-server-exposing-masked- data.aspx#Goal_2_Find_the_CreditCard_number_for_UserID_1
- Question List (241q)
- Question 1: You administer a Microsoft SQL Server 2016 database named Co...
- Question 2: Overview You are a database administrator for a company name...
- Question 3: Which feature should you enable and configure so session req...
- Question 4: You have configured Resource Governor with three resource po...
- Question 5: You plan to create a database. The database will be used by ...
- Question 6: You work as a Database Administrator (DBA) for a company nam...
- Question 7: You have two databases named DB1 and DB2 that are located on...
- Question 8: You create a stored procedure that retrieves all of the rows...
- Question 9: Background Corporate Information Fabrikam, Inc. is a retaile...
- Question 10: You are designing a database named DB1. Changes will be depl...
- Question 11: You manage a Microsoft SQL Server environment. You plan to e...
- Question 12: You administer a Microsoft SQL Server 2016 database. The dat...
- Question 13: Note: This question is part of a series of questions that pr...
- Question 14: You administer a Microsoft SQL Server 2016 database named Co...
- Question 15: You need to move a database in between servers. You need to ...
- Question 16: Note: This question is part of a series of questions that pr...
- Question 17: Note: This question is part of a series of questions that us...
- Question 18: You work as a Database Administrator (DBA) for a company nam...
- Question 19: You are a database administrator for a Microsoft SQL Server ...
- Question 20: Note: This question is part of a series of questions that pr...
- Question 21: You work as a Database Administrator (DBA) for a company nam...
- Question 22: Overview Application Overview Contoso, Ltd., is the develope...
- Question 23: You administer a Microsoft SQL Server 2016 failover cluster....
- Question 24: Overview Application Overview Contoso, Ltd., is the develope...
- Question 25: You are creating a database that will store usernames and cr...
- Question 26: Which feature should you enable and configure so session req...
- Question 27: Background Corporate Information Fabrikam, Inc. is a retaile...
- Question 28: Overview Application Overview Contoso, Ltd., is the develope...
- Question 29: You administer a Microsoft SQL Server 2012 instance. You nee...
- Question 30: Overview You are a database administrator for a company name...
- Question 31: You administer a SQL Server 2014 instance. Users report that...
- Question 32: Overview Application Overview Contoso, Ltd., is the develope...
- Question 33: Overview You are a database administrator for a company name...
- Question 34: Overview You are a database administrator for a company name...
- Question 35: Note: This question is part of a series of questions that us...
- Question 36: You want to simulate read, write, checkpoint, backup, sort, ...
- Question 37: You administer a Microsoft SQL Server 2016 default instance....
- Question 38: You administer a Microsoft SQL Server 2016 instance. You dis...
- Question 39: Note: This question is part of a series of questions that us...
- Question 40: You administer a Microsoft SQL Server 2016 database instance...
- Question 41: You administer a Microsoft SQL Server 2016 server that has S...
- Question 42: You have a query that is used by a reporting dashboard. User...
- Question 43: You administer a Microsoft SQL Server 2016 database. You wan...
- Question 44: You administer two Microsoft SQL Server 2012 servers. Each s...
- Question 45: You manage a Microsoft SQL Server environment. You plan to c...
- Question 46: Note: This question is part of a series of questions that us...
- Question 47: You have a SQL Server 2014 environment That includes four se...
- Question 48: You have a database that stores information for a shipping c...
- Question 49: Background Corporate Information Fabrikam, Inc. is a retaile...
- Question 50: Note: This question is part of a series of questions that us...
- Question 51: You have a database named DB1 that stores more than 700 giga...
- Question 52: You are creating an application that will connect to the Age...
- Question 53: You use a contained database named ContosoDb within a domain...
- Question 54: You have an SQL Server 2014 server named SQL1. You are desig...
- Question 55: Overview You are a database administrator for a company name...
- Question 56: You are designing a monitoring application for a new SQL Ser...
- Question 57: Overview Application Overview Contoso, Ltd., is the develope...
- Question 58: You work as a Database Administrator (DBA) at ABC.com. You a...
- Question 59: Note: This question is part of a series of questions that pr...
- Question 60: You are the new database administrator for a SQL Server 2014...
- Question 61: You deploy a database by using SQL Server 2014. The database...
- Question 62: Note: This question is part of a series of questions that pr...
- Question 63: You are a database administrator for a Microsoft SQL Server ...
- Question 64: You administer a Windows Azure SQL Database database named H...
- Question 65: You work as a Database Administrator (DBA) for a company nam...
- Question 66: You administer a Windows Azure SQL Database database named I...
- Question 67: You administer a Microsoft SQL Server 2016 database that con...
- Question 68: You deploy a database by using SQL Server 2012. The database...
- Question 69: You work as a Database Administrator (DBA) for a company nam...
- Question 70: Note: This question is part of a series of questions that us...
- Question 71: You administer a Microsoft SQL Server 2016 database that inc...
- Question 72: You administer a Microsoft SQL Server 2016 server. When tran...
- Question 73: You administer a Microsoft SQL Server 2016 database. You hav...
- Question 74: You work as a Database Administrator (DBA) for a company nam...
- Question 75: You administer a single server that contains a Microsoft SQL...
- Question 76: Note: This question is part of a series of questions that pr...
- Question 77: You administer a Microsoft SQL Server 2016 server that hosts...
- Question 78: You have two SQL Server 2012 instances named SQLDev and SQLP...
- Question 79: You administer a Microsoft SQL Server 2016 instance that has...
- Question 80: Note: This question is part of a series of questions that pr...
- Question 81: You administer a Microsoft SQL Server 2016 Enterprise Editio...
- Question 82: Your network contains an Active Directory domain that has tw...
- Question 83: You work as a Database Administrator (DBA) for a company nam...
- Question 84: You administer a Microsoft SQL Server 2016 environment. One ...
- Question 85: General Overview You are the Senior Database Administrator (...
- Question 86: You administer a Microsoft SQL Server 2016 database named Or...
- Question 87: You have a database named DB1 that contains two tables. You ...
- Question 88: You administer two instances of Microsoft SQL Server 2016. Y...
- Question 89: You are using dynamic management views to monitor an SQL Ser...
- Question 90: General Overview You are the Senior Database Administrator (...
- Question 91: You work as a Developer at ABC.com. All databases are hosted...
- Question 92: You need to ensure that a stored procedure fails if an INSER...
- Question 93: You want to reproduce the same SQL Server 2016 installation ...
- Question 94: You are designing a Windows Azure SQL Database for an order ...
- Question 95: You have 10 Microsoft SQL Server 2016 servers. You deploy a ...
- Question 96: Note: This question is part of a series of questions that pr...
- Question 97: You install a Microsoft SQL Server 2016 instance. The instan...
- Question 98: You administer all the deployments of Microsoft SQL Server 2...
- Question 99: You plan to implement a fault tolerance solution for a Micro...
- Question 100: Overview Application Overview Contoso, Ltd., is the develope...
- Question 101: Note: This question is part of a series of questions that pr...
- Question 102: Note: This question is part of a series of questions that us...
- Question 103: Note: This question is part of a series of questions that us...
- Question 104: Note: This question is part of a series of questions that pr...
- Question 105: Background Corporate Information Fabrikam, Inc. is a retaile...
- Question 106: Note: This question is part of a series of questions that us...
- Question 107: You are planning on deploying a server that will be dedicate...
- Question 108: You administer two Microsoft SQL Server 2016 servers named P...
- Question 109: You administer a Microsoft SQL Server 2016 server. One of th...
- Question 110: You administer a single server that contains a Microsoft SQL...
- Question 111: You have a SQL Server 2014 instance named SQL1. SQL1 creates...
- Question 112: You have a database that stores information for a shipping c...
- Question 113: Note: This question is part of a series of questions that pr...
- Question 114: You administer all the deployments of Microsoft SQL Server 2...
- Question 115: You are a database administrator at Contoso, Ltd. You are pr...
- Question 116: Background Corporate Information Fabrikam, Inc. is a retaile...
- Question 117: You administer a Microsoft SQL Server 2016 instance that has...
- Question 118: Note: This question is part of a series of questions that pr...
- Question 119: You are creating a database that will store usernames and pa...
- Question 120: Background Corporate Information Fabrikam, Inc. is a retaile...
- Question 121: Note: This question is part of a series of questions that pr...
- Question 122: You have a SQL Server instance on a server named Server1. Yo...
- Question 123: You administer a Microsoft SQL Server 2016 server that hosts...
- Question 124: You have a SQL Server 2012 database named DB1. You plan to i...
- Question 125: Note: This question is part of a series of questions that pr...
- Question 126: You work as a Database Administrator (DBA) for a company nam...
- Question 127: Overview You are a database administrator for a company name...
- Question 128: Note: This question is part of a series of questions that us...
- Question 129: You administer a Microsoft SQL Server 2016 instance. The ins...
- Question 130: You have a database named DB1. You plan to create a stored p...
- Question 131: You administer a Microsoft SQL Server 2016 database named Co...
- Question 132: You manage a Microsoft SQL Server environment. You plan to e...
- Question 133: You work as a Developer at ABC.com. All databases are hosted...
- Question 134: You need to validate rows before they are added to a table e...
- Question 135: Note: This question is part of a series of questions that pr...
- Question 136: A Microsoft SQL Server database named DB1 has two filegroups...
- Question 137: Overview Application Overview Contoso, Ltd., is the develope...
- Question 138: You have a customer who has several SQL Server 2012 database...
- Question 139: You manage a SQL Server 2014 instance that contains a databa...
- Question 140: You have a table that has grown in the past six months. A us...
- Question 141: You administer a Microsoft SQL Server 2016 database named Co...
- Question 142: You administer a Microsoft SQL Server 2016 instance. You nee...
- Question 143: You administer a Microsoft SQL Server 2016 database. You pro...
- Question 144: Background Corporate Information Fabrikam, Inc. is a retaile...
- Question 145: You administer a Microsoft SQL Server 2016 database that con...
- Question 146: You are the administrator for a SQL Server 2014 instance tha...
- Question 147: Your company has offices in Seattle and Montreal. The networ...
- Question 148: Your company has a SQL Azure subscription. You implement a d...
- Question 149: General Overview You are the Senior Database Administrator (...
- Question 150: You have a server that has SQL Server 2014 installed. The se...
- Question 151: You are building a stored procedure for a SQL Azure database...
- Question 152: You maintain a database named DB1 that has a nonpartitioned ...
- Question 153: Note: This question is part of a series of questions that pr...
- Question 154: You use Microsoft SQL Server 2016 to write code for a transa...
- Question 155: You create an availability group named HaContoso that has re...
- Question 156: You have two SQL Server instances named SQLDev and SQLProd t...
- Question 157: Note: This question is part of a series of questions that us...
- Question 158: Your company has offices in Seattle and Montreal. The networ...
- Question 159: You have an application that queries a database. Users repor...
- Question 160: You manage database servers in a high security environment. ...
- Question 161: You are designing a SQL Server database for an order fulfill...
- Question 162: You plan to integrate an on-premises Microsoft SQL Server en...
- Question 163: You install Microsoft SQL Server 2016 on a new server. After...
- Question 164: Note: This question is part of a series of questions that pr...
- Question 165: You are the lead database administrator (DBA) of a Microsoft...
- Question 166: You administer all the deployments of Microsoft SQL Server 2...
- Question 167: You have a database named DB1. Users report that a database ...
- Question 168: Note: This question is part of a series of questions that us...
- Question 169: You administer a Microsoft SQL Server 2016 database that inc...
- Question 170: You administer a Microsoft SQL Server 2016 database. Users r...
- Question 171: You administer a Microsoft SQL Server 2016 database. The dat...
- Question 172: Note: This question is part of a series of questions that pr...
- Question 173: You administer a Microsoft SQL Server 2016 server. You plan ...
- Question 174: You have a database hosted on SQL Server 2012 R2. The databa...
- Question 175: You deploy a SQL Server instance named SQLProd that uses SQL...
- Question 176: Overview You are a database administrator for a company name...
- Question 177: You create an availability group that has replicas named HA/...
- Question 178: You plan to create a database. The database will be used by ...
- Question 179: Overview You are a database administrator for a company name...
- Question 180: You plan to install a Microsoft SQL Server 2016 instance. Th...
- Question 181: You administer a Microsoft SQL Server 2016 instance. After a...
- Question 182: You have a SQL Server 2012 database named DB1. You have a ba...
- Question 183: You work as a Database Administrator (DBA) for a company nam...
- Question 184: You administer a Microsoft SQL Server 2016 database named Co...
- Question 185: You have a server named Server1 that has 2 processors. You p...
- Question 186: You are the administrator of a Microsoft SQL Server 2016 ser...
- Question 187: You administer several Microsoft SQL Server 2016 database se...
- Question 188: You administer a Microsoft SQL Server 2016 database. You nee...
- Question 189: Note: This question is part of a series of questions that us...
- Question 190: You administer all the deployments of Microsoft SQL Server 2...
- Question 191: You have a server named Server1 that has 16 processors. You ...
- Question 192: You administer a Microsoft SQL Server 2016 database that has...
- Question 193: Overview You are a database administrator for a company name...
- Question 194: You are migrating a database named Orders to a new server th...
- Question 195: You have a SQL Server 2014 environment That contains 20 serv...
- Question 196: Note: This question is part of a series of questions that pr...
- Question 197: You plan to install Microsoft SQL Server 2016 for a web host...
- Question 198: You use SQL Server 2014 to maintain the data used by applica...
- Question 199: Note: This question is part of a series of questions that pr...
- Question 200: You have four databases that are accessed by using an Online...
- Question 201: You are troubleshooting an application that runs a query. Th...
- Question 202: Background Corporate Information Fabrikam, Inc. is a retaile...
- Question 203: Overview Application Overview Contoso, Ltd., is the develope...
- Question 204: You work as a Database Administrator (DBA) at ABC.com. All d...
- Question 205: A company has an on-premises Microsoft SQL Server environmen...
- Question 206: You administer a Microsoft SQL Server 2016 database. Users r...
- Question 207: Note: This question is part of a series of questions that pr...
- Question 208: Overview Application Overview Contoso, Ltd., is the develope...
- Question 209: Note: This question is part of a series of questions that us...
- Question 210: Note: This question is part of a series of questions that pr...
- Question 211: You are implementing a SQL Server 2016 five-node failover cl...
- Question 212: You administer a SQL Server 2016 database instance. You need...
- Question 213: General Overview You are the Senior Database Administrator (...
- Question 214:
- Question 215: You administer a Microsoft SQL Server 2016 server. The MSSQL...
- Question 216: A company has an on-premises Microsoft SQL Server environmen...
- Question 217: General Overview You are the Senior Database Administrator (...
- Question 218: Note: This question is part of a series of questions that pr...
- Question 219: General Overview You are the Senior Database Administrator (...
- Question 220: Note: This question is part of a series of questions that us...
- Question 221: You administer a Microsoft SQL Server 2016 database that has...
- Question 222: You administer a Microsoft SQL Server 2016 database named Co...
- Question 223: Note: This question is part of a series of questions that us...
- Question 224: Your company stored customer data, including credit card num...
- Question 225: Overview You are a database administrator for a company name...
- Question 226: You administer a Microsoft SQL Server 2016 instance that con...
- Question 227: Note: This question is part of a series of questions that pr...
- Question 228: You have a database named DB1 that is configured to use the ...
- Question 229: You use SQL Azure to store data used by an e-commerce applic...
- Question 230: Overview Application Overview Contoso, Ltd., is the develope...
- Question 231: Overview Application Overview Contoso, Ltd., is the develope...
- Question 232: You administer a Microsoft SQL Server 2016 server that hosts...
- Question 233: General Overview You are the Senior Database Administrator (...
- Question 234: Note: This question is part of a series of questions that pr...
- Question 235: Note: This question is part of a series of questions that us...
- Question 236: You administer a Microsoft SQL Server database named Sales. ...
- Question 237: You administer a Microsoft SQL Server 2016 database instance...
- Question 238: You work as a Database Administrator (DBA) for a company nam...
- Question 239: You administer a Microsoft SQL Server 2016 database named Co...
- Question 240: You are troubleshooting an application that runs a query. Th...
- Question 241: You plan to migrate the db to azure. You verify that all obj...
