单选题A SQL Azure database generates an error when a row is inserted into any table in the database. No error is generated when a row is deleted. You need to recommend an approach for locating the source of the errors. What should you recommend？（）A Use a Dynamic Management View to check for locks.B Use a Dynamic Management View to check for blocked queries.C Use a Dynamic Management View to check for long-running queries.D Use a Dynamic Management View to check the size and maximum size of the database.
单选题
A SQL Azure database generates an error when a row is inserted into any table in the database. No error is generated when a row is deleted. You need to recommend an approach for locating the source of the errors. What should you recommend？（）
A
Use a Dynamic Management View to check for locks.
B
Use a Dynamic Management View to check for blocked queries.
C
Use a Dynamic Management View to check for long-running queries.
D
Use a Dynamic Management View to check the size and maximum size of the database.
参考解析
解析：
暂无解析
相关考题：
A Windows Azure application connects to a SQL Azure database. The database size has increased significantly. Some queries in the application no longer complete. You need to recommend an approach for identifying queries that do not complete. What should you recommend？（）A、 Use the SQL Server Profiler to capture all SQL activities.B、 Use a Dynamic Management View to analyze performance.C、 Use the Database Engine Tuning Advisor to analyze the workload.D、 Use Microsoft SQL Server Management Studio to analyze the SQL logs.
SQL Server中进行数据库备份的SQL语句是（）。A、INSERT DATABASEB、BACKUP DATABASEC、RESTORE DATABASED、UPDATE DATABASE
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A、’SQL ALTER DATABASE OPEN’；B、SQL ALTER DATABASE ’OPEN’；C、OPEN DATABASE；D、DATABASE OPEN
ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '56_masterbin. 000003' position 684 Why did you receive this error?（）A、The slave SQL thread does not have DELETE privileges to execute on test.t1 table.sB、The table definition on the slave -litters from the masterC、Multi-threaded replication slaves can have temporary errors occurring for cross database updatesD、The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist
A Windows Azure application connects to a SQL Azure database. Connections to the database are being dropped due to throttling. You need to recommend an approach for identifying the root cause of the problem. Which two actions should you recommend？（）A、 Use Dynamic Management Views to analyze performance issues.B、 Decrease the connection timeout in the database connection string.C、 Make sure the application is closing database connections that are not needed.D、 Use SQL Profiler to analyze performance issues by configuring it to connect to SQL Azure.
An on-premise .NET application uses an on-premise Microsoft SQL Server 2008 database. The existing compute infrastructure is insufficient to support peak loads. You plan to move only the compute-intensive component of the application into Windows Azure. The component requires access to the on-premise database. The on-premise database cannot be accessed from outside the network boundary. You need to recommend a database topology. What should you recommend？（）A、 Use SQL Azure for the on-premise components and the compute-intensive component.B、 Configure merge replication with the on-premise database as publisher and the SQL Azure database as subscriber.C、 Configure snapshot replication with the on-premise database as publisher and the SQL Azure database assubscriber.D、 Configure snapshot replication with the SQL Azuredatabase as publisher and the on-premise database as subscriber.
You are planning the deployment of a SQL Azure database. Your company has a Volume Licensing Agreement for Microsoft SQL Server 2008. The SQL Azure database must maintain a monthly availability of 99.9%. You need to recommend an approach for minimizing the monthly expenses associated with the SQL Azure database. What should you recommend？（）A、 Add a processor license to the existing SQL Server licensing agreement.B、 Purchase a Windows Azure consumption platform subscription.C、 Purchase a SQL Server Services Provider Licensing Agreement （SPLA）.D、 Purchase a SQL Server Web license to extend the existing SQL Server licensing agreement.
An application connects to a SQL Azure database. The application occasionally loses the connection to the SQL Azure database. You need to recommend an approach for reliably completing data access operations. What should you recommend？（） A、 Use Microsoft ADO.NET connection pooling.B、 Pass exceptions to the user interface layer.C、 Implement a retry policy in the data access layer.D、 Begin a transaction before each data access operation.
You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2. You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure. What should you recommend？（）A、 Use the bcp utility.B、 Use the dta utility.C、 Use the SQL Server Import and Export Wizard.D、 Attach each SQL Server database to SQL Azure.
You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?（）A、Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.B、Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.C、Create a SQL Server Integration Services （SSIS） package to import， standardize， and cleanse the data.D、Create a CLR stored procedure to import the data into a staging table， to cleanse and standardize the data， and to insert the data into the database.
Multiple Windows Azure applications connect to multiple SQL Azure servers. On-premise users connect to the SQL Azure servers for a variety of purposes. You successfully deploy a new Windows Azure application with its own SQL Azure server. When on- premise users attempt to connect to the new SQL Azure server they receive connection errors. You need to recommend an approach for mitigating the connectivity issue. What should you recommend？ （）A、 Open port 1433 on the network firewall.B、 Use Security Support Provider Interface （SSPI）.C、 Disable the validation of the SSL certificate for the SQL Azure server through theconnection string.D、 Change the firewall rules of the new SQL Azure server to allow access by computers on the internalnetwork.
A SQL Azure database generates an error when a row is inserted into any table in the database. No error is generated when a row is deleted. You need to recommend an approach for locating the source of the errors. What should you recommend？（） A、 Use a Dynamic Management View to check for locks.B、 Use a Dynamic Management View to check for blocked queries.C、 Use a Dynamic Management View to check for long-running queries.D、 Use a Dynamic Management View to check the size and maximum size of the database.
You are designing a plan for migrating an existing Microsoft SQL Server 2008 database to SQL Azure.The database includes a SQL Server Agent job that cleans the application log table. You need to recommend an approach for ensuring that the SQL Server Agent job continues to run without modification. What should you recommend？（）A、 Use the SQL Azure Data Sync service.B、 Run the SQL Server Agent in SQL Azure.C、 Use SQL Server Integration Services （SSIS） to connect to SQL Azure.D、 Connect the existing on-premise SQL Server Agent jobs to SQL Azure.
You are designing a strategy for synchronizing a SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships. You need to recommend an approach for ensuring that all changes in the remote databases synchronize with the SQL Azure database. What should you recommend？（）A、 Use SQLAzure Data Sync Service.B、 Use SQL Server replication.C、 Use SQL Server backup and restore.D、 Use SQL Server database snapshots.
A Windows Azure application stores data in a SQL Azure database. The application will start an operation that includes three insert statements. You need to recommend an approach for rolling back the entire operation if the connection to SQL Azure is lost. What should you recommend？（）A、 Ensure that all statements execute in the same database transaction.B、 Create a stored procedure in the database that wraps the insert statements in a TRY CATCH block.C、 Create a stored procedure in the database that wraps the insertstatements in a TRANSACTION block.D、 Open a new connection to the database. Use a separate transaction scope to roll back the original operation.
A Windows Azure application retrieves data from SQL Azure. You need to recommend an approach for improving application query performance. What should you recommend？（）A、 Create a database view to retrieve the data.B、 Use a clustered index on the SQL Azure database tables.C、 Open a new database connection when an operation times out.D、 Create SQL Azure database table indexes basedon application queries
单选题Evaluate the following statement： Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement？（）A They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.B They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses.C They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses.D The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.
单选题A Windows Azure application stores data in a SQL Azure database. The application will start an operation that includes three insert statements. You need to recommend an approach for rolling back the entire operation if the connection to SQL Azure is lost. What should you recommend？（）A Ensure that all statements execute in the same database transaction.B Create a stored procedure in the database that wraps the insert statements in a TRY CATCH block.C Create a stored procedure in the database that wraps the insertstatements in a TRANSACTION block.D Open a new connection to the database. Use a separate transaction scope to roll back the original operation.
单选题You are designing a strategy for synchronizing a SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships. You need to recommend an approach for ensuring that all changes in the remote databases synchronize with the SQL Azure database. What should you recommend？（）A Use SQLAzure Data Sync Service.B Use SQL Server replication.C Use SQL Server backup and restore.D Use SQL Server database snapshots.
单选题A Windows Azure application retrieves data from SQL Azure. You need to recommend an approach for improving application query performance. What should you recommend？（）A Create a database view to retrieve the data.B Use a clustered index on the SQL Azure database tables.C Open a new database connection when an operation times out.D Create SQL Azure database table indexes basedon application queries
单选题You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2. You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure. What should you recommend？（）A Use the bcp utility.B Use the dta utility.C Use the SQL Server Import and Export Wizard.D Attach each SQL Server database to SQL Azure.
单选题ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '56_masterbin. 000003' position 684 Why did you receive this error?（）AThe slave SQL thread does not have DELETE privileges to execute on test.t1 table.sBThe table definition on the slave -litters from the masterCMulti-threaded replication slaves can have temporary errors occurring for cross database updatesDThe slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist
单选题You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers MODIFY （cust_nameVARCHAR2 （40）） / When you execute the command， it displays the following error message： ERROR at line 1： ORA-00054： resource busy and acquire with NOWAIT specified What could be the reason for the error message？（）AThe database instance is not available.BThe ALTER TABLE command does not have WAIT optionCThe table or a row in the table is currently locked by another user session.DThe database instance is busy processing other user sessions commands.EThe CUSTOMERS table has no long running query active at the time when this request is made.FThe server process executing the ALTER TABLE command is busy with another command execution
单选题An on-premise .NET application uses an on-premise Microsoft SQL Server 2008 database. The existing compute infrastructure is insufficient to support peak loads. You plan to move only the compute-intensive component of the application into Windows Azure. The component requires access to the on-premise database. The on-premise database cannot be accessed from outside the network boundary. You need to recommend a database topology. What should you recommend？（）A Use SQL Azure for the on-premise components and the compute-intensive component.B Configure merge replication with the on-premise database as publisher and the SQL Azure database as subscriber.C Configure snapshot replication with the on-premise database as publisher and the SQL Azure database assubscriber.D Configure snapshot replication with the SQL Azuredatabase as publisher and the on-premise database as subscriber.
单选题You are designing a Windows Azure application that will store data in two SQL Azure databases. The application will insert data in both databases as part of a single logical operation. You need to recommend an approach for maintaining data consistency across the databases. What should you recommend？（）A Execute database calls on parallel threads.B Wrap the database calls in a single transaction scope.C Use Microsoft Distributed Transaction Coordinator （MSDTC）.D Handle errors resulting from the database calls by using compensatory logic.
单选题A Windows Azure application connects to a SQL Azure database. The database size has increased significantly. Some queries in the application no longer complete. You need to recommend an approach for identifying queries that do not complete. What should you recommend？（）A Use the SQL Server Profiler to capture all SQL activities.B Use a Dynamic Management View to analyze performance.C Use the Database Engine Tuning Advisor to analyze the workload.D Use Microsoft SQL Server Management Studio to analyze the SQL logs.
多选题You are planning the migration of an existing application to Windows Azure and SQL Azure. The original application includes a Microsoft SQL Server 2008 database. You need to recommend an approach for ensuring that the database migrates successfully toSQL Azure. Which two actions should you recommend？（）ARemove all clustered indexes from the database.BRemove all dependencies on the Microsoft Distributed Transaction Coordinator （MSDTC） from the application.CUse SSL and SQL authentication to connect to the database.DUse SSL and Windows authentication to connect to the database.
单选题You are planning the deployment of a SQL Azure database. Your company has a Volume Licensing Agreement for Microsoft SQL Server 2008. The SQL Azure database must maintain a monthly availability of 99.9%. You need to recommend an approach for minimizing the monthly expenses associated with the SQL Azure database. What should you recommend？（）A Add a processor license to the existing SQL Server licensing agreement.B Purchase a Windows Azure consumption platform subscription.C Purchase a SQL Server Services Provider Licensing Agreement （SPLA）.D Purchase a SQL Server Web license to extend the existing SQL Server licensing agreement.