Section 4: Sec Four (49 to 54)
Details: Case Study: 3 Overview
Contoso, Ltd. Is a national scientific research company that has sales, marketing. And
research departments. Contoso has a main office in Dallas and more than 20 satellite
offices across the United States. Some employees work off-site at customer locations.
Contoso is expected to double in size during the next two years.
Existing Environment
The Microsoft SQL server environment contains the server configured as shown in the
following table.
Contoso currently uses SQL Server 2008 R2 on all of the database servers, SQL01
currently requires six cores and 50 GB memory.
Once a day, database snapshots are taken on the mirror to provide ad hoc reporting and
to load data warehouse.
One report is used for ad hoc reporting by using the mirrored copy of the OLTP
database. Research Gen IT is a Windows application that users currently access by using
Remote Desktop. Business Goals
Contoso identifies the following business goals:
� Minimize the costs associated with purchasing hardware and software.
� Prevent any negative impact on performance when moving database platforms to the
cloud.
� Audit user access to and query execution on all of the database in the research
department. Planned Changes
� Upgrade SQL03 fromSQL Server 2008 R2 to SQL Server 2014 on Windows Server
2012 R2.
� IVIigrate SQL01 and SQL02 to Infrastructure as a Service (IAAS) on SQL Server
2014.
� Leverage cloud services fora disaster recovery location and for high availability.
� Replace Research Gen II with a cloud-based application named One Research. The
database for this application will be migrated to a cloud service.
Departmental R equirements
Senior research project leaders must be able to upload databases to the cloud. Initially,
the databases will be less than 3 GB. Some databases may grow to 50 GB. The databases
must be recoverable to any point during the past two weeks.
The research project leaders must monitor the performance of their databases. They must
view statistics, such as query performance and overall database performance.
The marketing department plans to use cloud services to host web applications for
marketing campaigns. The database for the web applications have the requirements
shown in the following table.
Technical Requirements
� Contoso identifies the following technical requirements:
� OLTP will be offloaded to Nlicrosoft Azure virtual machines.
� The data for One Report must not be more than 15 minutes old.
� All of the databases for the OLTP system must be implemented on solid state drives
(SSDs)
� A solution for the OLTP system must be created to provide disaster recovery and
repoting between SQL01 and SQL02.
� All databases, except for the research and marketing databases, must be recoverable to
any point during the last 30 days.
� A solution for the data warehouse system must be created to provide disaster recovery
between SQL03 and an Azure virtual machine named SQL04.
QUESTION: 49
You are designing the data warehouse.
You need to recommended a solution that meets the business goals and the technical
requirements. What should you recommend?
A. Create an AIwaysOn availability group between SQL03 and SQL04.
B. Host the data warehouse on an Azure Virtual machine.
C. Create an Azure HD|nsight cluster.
D. Create an Azure DocumentDB database.
Answer: B
QUESTION: 50
You are designing the data warehouse. You need to recommend a solution that meets the
business goals and the technical requirements. What should you recommend?
A. Create an AIwaysOn availability group between SQL03 and SQL04.
B. Host the data warehouse on an Azure virtual machine.
C. Create an Azure HD|nsight cluster.
D. Create an Azure Document DB database.
Answer: C
QUESTION: 51
You are evaluating the use of active geo-replication for one of the research department
databases. You need to identify which service tier to use for the database. The solution
must meet the department requirements and the business requirements.
What should you identify?
A. Premium P1
B. Premium P4
C. Standard S0 D.BaQc
Answer: D
QUESTION: 52
You need to ensure that the performance statistics for the research department are
collected. What should you enable?
A. Query Performance Insight
B. Scale and Configuration
C. Dynamic Data Masking
D. Index advisor
Answer: C
QUESTION: 53
You need to tell the research project leaders how to migrate their databases.
Which task should you instruct the leaders to use from SQL Server Management Studio?
A. Extract Data-tier Application
B. Deploy Database to a Microsoft Azure VM
C. Deploy Databaseto a Microsoft Azure SQL Database
D. Copy Database
Answer: B
QUESTION: 54
You need to recommend an auditing solution that meets the business goals.
Which three events should you include in the recommendation? Each correct answer
presents part of the solution.
A. Transaction Management
B. Stored Procedure
C. Plain SQL
D. Login
E. Failed Connections
Answer: D
For More exams visit https://killexams.com
�
Kill your exam at First Attempt....Guaranteed!
No comments:
Post a Comment