최신 070-462 무료덤프 - Microsoft Administering Microsoft SQL Server 2012/2014 Databases
You administer a Microsoft SQL Server database.
You have a SQL Server Agent job instance that runs using the service account. You have a job step within the job that requires elevated privileges.
You need to ensure that the job step can run using a different user account.
What should you use?
You have a SQL Server Agent job instance that runs using the service account. You have a job step within the job that requires elevated privileges.
You need to ensure that the job step can run using a different user account.
What should you use?
정답: A
You administer a Microsoft SQL Server database.
Every Sunday afternoon, a process inserts a large volume of data. Users generate reports and modify additional data throughout the week.
You need to create a backup strategy that:
* minimizes the size of the transaction log,
* minimizes the size of the backups, and
* ensures a 24-hour recovery point objective (RPO).
Which strategy or strategies should you use? (To answer, drag the appropriate strategy or strategies to their corresponding task or tasks in the answer area. Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)
Every Sunday afternoon, a process inserts a large volume of data. Users generate reports and modify additional data throughout the week.
You need to create a backup strategy that:
* minimizes the size of the transaction log,
* minimizes the size of the backups, and
* ensures a 24-hour recovery point objective (RPO).
Which strategy or strategies should you use? (To answer, drag the appropriate strategy or strategies to their corresponding task or tasks in the answer area. Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)
정답:
Explanation
Recovery Model: Full recovery model
Only the Full recovery model provides a 24-hour recovery point objective.
Sunday backup: Full backup
Nightly backup: Transactional log backup
References:
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models-sql-server
You administer a Microsoft SQL Server environment. The environment contains a SQL Server Reporting Services (SSRS) instance.
You need to ensure that users can create subscriptions.
What should you configure?
You need to ensure that users can create subscriptions.
What should you configure?
정답: C
Which of the following is the default file extension for an SQL Server 2012 backup file?
정답: D
You administer several Microsoft SQL Server servers. Your company has a number of offices across the world connected by using a wide area network (WAN).
Connections between offices vary significantly in both bandwidth and reliability.
You need to identify the correct replication method for each scenario.
What should you do? (To answer, drag the appropriate replication method or methods to the correct location or locations in the answer area. Each replication method may be used once, more than once, or not at all.)
Connections between offices vary significantly in both bandwidth and reliability.
You need to identify the correct replication method for each scenario.
What should you do? (To answer, drag the appropriate replication method or methods to the correct location or locations in the answer area. Each replication method may be used once, more than once, or not at all.)
정답:
Explanation
References:
You have an index called Employee_IDX on the table Employees. Which of the following will rebuild this index online?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
What is the minimum recommended amount of RAM for SQL Server 2012 Enterprise?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
You develop an application that uses data from a Microsoft SQL Server database.
A stored procedure named MyProcedure experiences excessive blocking problems.
You need to enable row versioning. However, you do not want to force every connection to have row versioning enabled.
Which code segment or segments should you use to complete the Transact-SQL statements? To answer, drag the appropriate command or commands to the appropriate position or positions in the answer area to complete the Transact-SQL statements. Answer choices may be used once, more than once, or not at all. Answer targets may be used once. Additionally, you may need to drag the split bar between panes or scroll to view content.
A stored procedure named MyProcedure experiences excessive blocking problems.
You need to enable row versioning. However, you do not want to force every connection to have row versioning enabled.
Which code segment or segments should you use to complete the Transact-SQL statements? To answer, drag the appropriate command or commands to the appropriate position or positions in the answer area to complete the Transact-SQL statements. Answer choices may be used once, more than once, or not at all. Answer targets may be used once. Additionally, you may need to drag the split bar between panes or scroll to view content.
정답:
Explanation
Box 1: SET ALLOW_SNAPSHOT_ISOLATION ON
Database administrators control the database-level settings for row versioning by using the READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION database options in the ALTER DATABASE statement.
The following Transact-SQL statement will enable ALLOW_SNAPSHOT_ISOLATION:
ALTER DATABASE AdventureWorks2008R2
SET ALLOW_SNAPSHOT_ISOLATION ON;
Incorrect: Not READ_COMMITTED_SNAPSHOT
When setting the READ_COMMITTED_SNAPSHOT option, only the connection executing the ALTER DATABASE command is allowed in the database.
Box 2: SET TRANSACTION ISOLATION LEVEL SNAPSHOT
The ALLOW_SNAPSHOT_ISOLATION ON option transactions can specify the SNAPSHOT transaction isolation level.
References:
https://technet.microsoft.com/en-us/library/ms175095(v=sql.105).aspx
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-set-options
You administer a Microsoft SQL Server database.
You want to import data from a text file to the database.
You need to ensure that the following requirements are met:
* Data import is performed from a Windows batch file.
* Data is loaded as a unit and is minimally logged.
Which data import command and recovery model should you choose? (To answer, drag the appropriate data import command or recovery model to the appropriate location or locations in the answer area. Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all.
Additionally, you may need to drag the split bar between panes or scroll to view content.)
You want to import data from a text file to the database.
You need to ensure that the following requirements are met:
* Data import is performed from a Windows batch file.
* Data is loaded as a unit and is minimally logged.
Which data import command and recovery model should you choose? (To answer, drag the appropriate data import command or recovery model to the appropriate location or locations in the answer area. Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all.
Additionally, you may need to drag the split bar between panes or scroll to view content.)
정답:
Explanation
You administer a Microsoft SQL Server 2012 server that has multiple databases.
You need to ensure that users are unable to create stored procedures that begin with sp_.
Which three actions should you perform in sequence? (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 ensure that users are unable to create stored procedures that begin with sp_.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
정답:
Explanation
Step 1: Create a Condition named StoredProcNamingConvention by using the Stored Procedure facet that has a single expression. Set the Field to @Name, Operator to NOT LIKE, and Value to 'sp[_]%'.
Step 2: Create a Policy named StoredProcNamingPolicy Set the Check condition to StoredProcNamingConvention and Evaluation Mode to On Change: Prevent Step 3: Enable StoredProcNamingPolicy Policies are created and managed by using Management Studio. The process includes the following steps:
* Select a Policy-Based Management facet that contains the properties to be configured.
* Define a condition that specifies the state of a management facet.
* Define a policy that contains the condition, additional conditions that filter the target sets, and the evaluation mode.
* Check whether an instance of SQL Server is in compliance with the policy.
Evaluation modes
There are four evaluation modes, three of which can be automated:
* On demand. This mode evaluates the policy when directly specified by the user.
* On change: prevent. This automated mode uses DDL triggers to prevent policy violations.Important:If the nested triggers server configuration option is disabled, On change: prevent will not work correctly.
Policy-Based Management relies on DDL triggers to detect and roll back DDL operations that do not comply with policies that use this evaluation mode. Removing the Policy-Based Management DDL triggers or disabling nest triggers, will cause this evaluation mode to fail or perform unexpectedly.
* On change: log only. This automated mode uses event notification to evaluate a policy when a relevant change is made.
* On schedule. This automated mode uses a SQL Server Agent job to periodically evaluate a policy.
You administer several Microsoft SQL Server 2012 servers.
You want to run scheduled checks to confirm that the databases on the servers are not configured to AutoShrink.
You need to create a policy to check the condition.
What should you do? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
You want to run scheduled checks to confirm that the databases on the servers are not configured to AutoShrink.
You need to create a policy to check the condition.
What should you do? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
정답:
Explanation
The Evaluation Mode defines the combination of 1) when the policy will be evaluated and 2) what the system will do in case of policy violation. The following evaluation modes are supported:
You administer a Microsoft SQL Server failover cluster.
You need to ensure that a failover occurs when the server diagnostics returns query_processing error.
Which server configuration property should you set?
You need to ensure that a failover occurs when the server diagnostics returns query_processing error.
Which server configuration property should you set?
정답: C