Microsoft 70-765 Question Answer

Note: This questions is part of a series of questions that use the same or similar answer
choices. An answer choice may be correct for more than one question in the series. Each
question is independent of the other questions in this series. Information and details
provided in a question apply only to that question.
Your company has several Microsoft Azure SQL Database instances.
Data encryption should be allowed to be implemented by the client applications that access
the data. Encryption keys should not be made available to the database engine.
You need to configure the database.
What should you implement?

A. transport-level encryption
B. cell-level encryption
C. Transparent Data Encryption
D. Always Encrypted
E. Encrypting FileSystem
F. BitLocker
G. dynamic data masking

Answer: A



Note: This question is part of a series of questions that present the same scenario. Each
question in the series contains a unique solution. Determine whether the solution meets
stated goals.
You manage a Microsoft SQL Server environment with several databases.
You need to ensure that queries use statistical data and do not initialize values for local
variables.
Solution: You enable the LEGACY_CARDINALITY_ESTIMATION option for the databases.
Does the solution meet the goal?

A. Yes
B. No

Answer: B