Question 21 a company has an on premises microsoft

This preview shows page 27 - 30 out of 51 pages.

QUESTION 21 A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instanced. The environments host several customer databases. You host a local database and a Stretch database that has a table named Members for one specific customer. You need to provide the customer with information about the space used in the databases. In the table below, identify the query that provides the required information for each database. NOTE: Make only one selection in each column. Hot Area: Correct Answer: Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 27 / 51
Image of page 27
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download QUESTION 22 You are creating a database that will store usernames and passwords for an application. You need to recommend a solution to store the passwords in the database. What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer. A. One-way encryption B. Transparent Data Encryption (TDE) C. Encrypting File System (EFS) D. Reversible encryption Correct Answer: B 1. Transparent Data Encryption (TDE) is a special case of encryption using a symmetric key. TDE encrypts an entire database using that symmetric key called the database encryption key. The database encryption key is protected by other keys or certificates which are protected either by the database master key or by an asymmetric key stored in an EKM module. 2. SQL Server provides the following mechanisms for encryption: Transact-SQL functions Asymmetric keys Symmetric keys Certificates Transparent Data Encryption QUESTION 23 Overview Latest 70-764 Dumps | 70-764 PDF Dumps | 70-764 Practice Test 28 / 51
Image of page 28
2020 Latest pass4itsure 70-764 PDF and VCE dumps Download Application Overview Contoso, Ltd., is the developer of an enterprise resource planning (ERP) application. Contoso is designing a new version of the ERP application. The previous version of the ERP application used SQL Server 2008 R2. The new version will use SQL Server 2014. The ERP application relies on an import process to load supplier data. The import process updates thousands of rows simultaneously, requires exclusive access to the database, and runs daily. You receive several support calls reporting unexpected behavior in the ERP application. After analyzing the calls, you conclude that users made changes directly to the tables in the database. Tables The current database schema contains a table named OrderDetails. The OrderDetails table contains information about the items sold for each purchase order. OrderDetails stores the product ID, quantities, and discounts applied to each product in a purchase order. The product price is stored in a table named Products. The Products table was defined by using the SQL_Latin1_General_CP1_CI_AS collation.
Image of page 29
Image of page 30

You've reached the end of your free preview.

Want to read all 51 pages?

  • Fall '19
  • Microsoft SQL Server

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors