70-459試験無料問題集「Microsoft Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform 認定」
DRAG DROP
You have a SQL Azure database named Database1.
You need to design the schema for a table named table1. Table1 will have less than one million rows. Table1 will contain the following information for each row:
The solution must minimize the amount of space used to store each row. Which data types should you recommend for each column?
To answer, drag the appropriate data type to the correct column in the answer area.
You have a SQL Azure database named Database1.
You need to design the schema for a table named table1. Table1 will have less than one million rows. Table1 will contain the following information for each row:
The solution must minimize the amount of space used to store each row. Which data types should you recommend for each column?
To answer, drag the appropriate data type to the correct column in the answer area.
正解：
You have two SQL Server instances named SQLDev and SQLProd that have access to various storage media.
You plan to synchronize SQLDev and SQLProd.
You need to recommend a solution that meets the following requirements:
- The database schemas must be synchronized from SQLDev to SQLProd. - The database on SQLDev must be deployed to SQLProd by using a package. - The package must support being deployed to SQL Azure.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
You plan to synchronize SQLDev and SQLProd.
You need to recommend a solution that meets the following requirements:
- The database schemas must be synchronized from SQLDev to SQLProd. - The database on SQLDev must be deployed to SQLProd by using a package. - The package must support being deployed to SQL Azure.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
正解：E
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
DRAG DROP
You need to recommend a backup process for data warehouse database.
The solution must meet the following requirements:
- Ensure that if a hardware failure occurs, you can bring the database online without
losing more than 24 hours of transactions. - Minimize the amount of administrative effort required to restore any lost data. - Minimize the space used by transaction logs.
What should you include in the recommendation?
To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You need to recommend a backup process for data warehouse database.
The solution must meet the following requirements:
- Ensure that if a hardware failure occurs, you can bring the database online without
losing more than 24 hours of transactions. - Minimize the amount of administrative effort required to restore any lost data. - Minimize the space used by transaction logs.
What should you include in the recommendation?
To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
正解：
DRAG DROP
You plan to deploy SQL Server 2012.
You identify the following security requirements for the deployment:
- Users must be prevented from intercepting and reading the T-SQL statements sent from the clients to the database engine. - All database files and log files must be encrypted if the files are moved to another disk on another server.
You need to identify which feature meets each security requirement. The solution must minimize processor overhead.
Which features should you identify?
To answer, drag the appropriate feature to the correct requirement in the answer area.
You plan to deploy SQL Server 2012.
You identify the following security requirements for the deployment:
- Users must be prevented from intercepting and reading the T-SQL statements sent from the clients to the database engine. - All database files and log files must be encrypted if the files are moved to another disk on another server.
You need to identify which feature meets each security requirement. The solution must minimize processor overhead.
Which features should you identify?
To answer, drag the appropriate feature to the correct requirement in the answer area.
正解：
You are designing a database named DB1.
Changes will be deployed to DB1 every Wednesday night.
You need to recommend a strategy to deploy the changes to DB1. The strategy must meet
the following requirements:
The strategy must not disrupt backup operations.
DB1 must be online while the changes are deployed.
You must be able to undo quickly any changes made to objects.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
---
Changes will be deployed to DB1 every Wednesday night.
You need to recommend a strategy to deploy the changes to DB1. The strategy must meet
the following requirements:
The strategy must not disrupt backup operations.
DB1 must be online while the changes are deployed.
You must be able to undo quickly any changes made to objects.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
---
正解：D
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
