070-473試験無料問題集「Microsoft Designing and Implementing Cloud Data Platform Solutions 認定」
Your company has a data warehouse that contains a database named DB1.
You plan to implement data encryption for DB1.
You need to configure DB1 to meet the following requirements:
* Prevent the system administrators of App1 from reading the Personally Identifiable Information (PII) stored in DB1.
* Ensue that all backups are Stored in an on-premises local drive for three days.
* Ensure that all backups are stored in a remote location for 10 days.
* Encrypt all backups.
All solution must support the ODBC Driver for Microsoft SQL Server 2012.
Which two solutions should you implement for DB1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You plan to implement data encryption for DB1.
You need to configure DB1 to meet the following requirements:
* Prevent the system administrators of App1 from reading the Personally Identifiable Information (PII) stored in DB1.
* Ensue that all backups are Stored in an on-premises local drive for three days.
* Ensure that all backups are stored in a remote location for 10 days.
* Encrypt all backups.
All solution must support the ODBC Driver for Microsoft SQL Server 2012.
Which two solutions should you implement for DB1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
正解：A,E
解答を投票する
You need to migrate DB2 to Azure.
Which utility should you use for each task? To answer, drag the appropriate utilities to the correct tasks. Each utility may be used once, more than once, or not at all. You made need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Which utility should you use for each task? To answer, drag the appropriate utilities to the correct tasks. Each utility may be used once, more than once, or not at all. You made need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
正解：
Explanation
Box 1: mysqldump
Use common utilities and tools such as MySQL Workbench, mysqldump, Toad, or Navicat to remotely connect and restore data into Azure Database for MySQL.
Box 2: azcopy
AzCopy is a command-line tool for copying data to or from Azure Blob storage, Azure Files, and Azure Table storage, by using simple commands. The commands are designed for optimal performance. You can copy data between a file system and a storage account, or between storage accounts.
App2 is developed by using third-party open source code that is updated frequently. The database for App2 is named DB2. App2 only supports MySQL.
Reference:
https://docs.microsoft.com/en-us/azure/mysql/concepts-migrate-import-export
https://docs.microsoft.com/en-us/azure/storage/common/storage-use-azcopy-migrate-on-premises-data?tabs=win
You have an application that uses a Microsoft SQL Server database on a Microsoft Azure virtual machine.
The application experiences performance issues, which you suspect are related to the connection pooling. The issues are prevalent only when there are more than 150 concurrent connections.
You need to identify whether the performance issues are related to the connection pooling.
Which dynamic management view should you query?
The application experiences performance issues, which you suspect are related to the connection pooling. The issues are prevalent only when there are more than 150 concurrent connections.
You need to identify whether the performance issues are related to the connection pooling.
Which dynamic management view should you query?
正解：A
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You have a Microsoft SQL Server 2014 instance on a Microsoft Azure virtual machine.
You need to ensure that all SQL Server audits are written to the Windows Security log.
Which two actions should you perform? Each correct answer presents part of the solution.
You need to ensure that all SQL Server audits are written to the Windows Security log.
Which two actions should you perform? Each correct answer presents part of the solution.
正解：B,C
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You need to identify which methods to use to migrate MovieReviewDB and CWDB.
Which method should you identify for each database? To answer, select the appropriate options in the answer area.
Which method should you identify for each database? To answer, select the appropriate options in the answer area.
正解：
Explanation
References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-cloud-migrate-compatible-using-ssms-mi
Topic 3, Contoso, Ltd.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 servers 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 of memory.
Once a day, database snapshots are taken on the mirror to provide ad hoc reporting and to load the data warehouse.
One report is used for ad hoc reporting by using the mirrored copy of the OLTP database.
Research Gen II is a Windows application that users currently access by using Remote Desktop.
Requirements
Business Goals
Contoso identifies the following business goals:
Planned changes
Contoso plans to implement the following changes:
Departmental Requirements
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 databases for the web applications have the requirements shown in the following table.
Technical Requirements
Contoso identifies the following technical requirements:
