Ussqlrelational

This preview shows page 10 - 13 out of 23 pages.

References:- engine QUESTION 15 You plan to deploy Microsoft SQL Server on a Microsoft Azure virtual machine. The virtual machine will have two databases. Each database will reside on a separate VHD and will be between 600 and 800 GB. Each database will have the I/O requirements shown in the following table. You are evaluating whether to use the P30 storage disk type. What is the minimum number of disks required for each database when using P30 storage disk type? (Select two.) A. DB1: 0 B. DB1: 1 C. DB1:2 D. DB1: 3 E. DB1:4 F. DB2: 0 Latest 70-765 Dumps | 70-765 Practice Test | 70-765 Braindumps 10 / 23
Image of page 10
2020 Latest pass4itsure 70-765 PDF and VCE dumps Download G. DB2: 1 H. DB221 I. DB2: 3 J. DB24 Correct Answer: CG P30 stats: Disk size is 1024 GB (1 TB), IOPS per disk is 5000. Recommendation: Use a minimum of 2 P30 disks (1 for log files and 1 for data files and TempDB; or stripe two or more disks and store all files in a single volume). References: - performance-targets QUESTION 16 You need to configure the data entry and business intelligence databases. In the table below, identify the option that you must use for each database. NOTE: Make only one selection in each column. Hot Area: Correct Answer: Latest 70-765 Dumps | 70-765 Practice Test | 70-765 Braindumps 11 / 23
Image of page 11
2020 Latest pass4itsure 70-765 PDF and VCE dumps Download Data Entry: Geo-replicated database only From Contoso scenario: Each location database for the data entry application may have an unpredictable amount of activity. Data must be replicated to secondary databases in Azure datacenters in different regions. Business intelligence: Elastic database pools only From Contoso scenario: For the business intelligence application, corporate executives must be able to view all data in near real-time with low network latency. SQL DB elastic pools provide a simple cost effective solution to manage the performance goals for multiple databases that have widely varying and unpredictable usage patterns. References: QUESTION 17 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?
Image of page 12
Image of page 13

You've reached the end of your free preview.

Want to read all 23 pages?

  • Fall '19
  • Relational model, 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