700-104 - Business Edition 6000 for Account Managers (BE6KAM)

Go back to Cisco

Example Questions

Which three are Cisco differentiators when comparing with competitors in collaboration technology? (Choose three.) Which server virtualization technology is used with Cisco Business Edition 6000 to support multiple applications running on the same physical server? You have two tables named dbo.Products and dbo.PriceChange. Table dbo.Products contains ten products. Five products are priced at $20 per unit and have PriceIncrease set to 1. The other five products are priced at $10 per unit and have PriceIncrease set to 0. You have the following query: INSERT dbo.PriceChange (ProductID, Change, ChangeDate)SELECT ProductID, inPrice - delPrice, SYSDATETIME()FROM ( UPDATE dbo.Products SET Price *= 1.1 OUTPUT inserted.ProductID, inserted.Price, deleted.Price WHERE PriceIncrease = 1) p (ProductID, inPrice, delPrice); You need to predict the results of the query. Which results should the query produce? Which two statements are true about Cisco Validated Designs and Smart Business Architectures? (Choose two.) Which Cisco Unified Communications and Collaboration deployment option best fits the on- premises midmarket businesses with 500 to 1000 users? You have an application that is used by international clients. All clients connect by using Windows Authentication. You need to ensure that system and user-defined error messages are displayed in the localized language for the clients. What should you do? (Each correct answer represents part of the solution. Choose two.) Which Cisco Unified Communications application is designed to provide enhanced customer care capabilities with Cisco Business Edition 6000? Which Cisco online tool is designed to help Cisco partners quickly generate a bill of materials and estimate pricing for Cisco solutions, addressing the needs of small to midsize customers? You have two tables named Customer and SalesOrder. You need to identify all customers that have not yet made any purchases and those that have only made orders with an OrderTotal less than 100. Which query should you use? You need to build CREATE INDEX statements for all the missing indexes that SQL Server has identified. Which dynamic management view should you use? You work for an international charity organization. You are writing a query to list the highest 100 different amounts that were donated. You have written the following code segment: 01 SELECT *02 FROM (SELECT Customer.CustomerID, SUM(TotalDue) AS TotalGiven, 03 04 FROM Customer05 JOIN SalesOrder 06 ON Customer.CustomerID = SalesOrder.CustomerID07 GROUP BY Customer.CustomerID) AS DonationsToFilter08 WHERE FilterCriteria <= 100 You need to insert a Transact-SQL clause in line 03 to complete the query. Which Transact-SQL clause should you insert? You need to generate the following XML document. <ProductExport> <Product Price="99">Product1</Product> <Product Price="199">Product2</Product> <Product Price="299">Product3</Product> <Product Price="399">Product4</Product></ProductExport> Which query should you use? You need to identify which products will be inserted when you execute the following code block. BEGIN TRANSACTION INSERT INTO Product (ProductName) VALUES ('food') BEGIN TRANSACTION INSERT INTO Product (ProductName)) VALUES ('beverage') COMMIT TRANSACTIONROLLBACK TRANSACTION Which products will be inserted? You have the following XML document that contains Product information. DECLARE @prodList xml ='<ProductList xmlns="urn:Wide_World_Importers/schemas/Products"> <Product Name="Product1" Category="Food" Price="12.3" /> <Product Name="Product2" Category="Drink" Price="1.2" /> <Product Name="Product3" Category="Food" Price="5.1" /> ...</ProductList>'; You need to return a list of products that contains the Product Name, Category, and Price of each product. Which query should you use? You need to write a query that uses a ranking function that returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition. Which Transact-SQL statement should you use? You need to capture and record a workload for analysis by the Database Engine Tuning Advisor (DTA). Which tool should you use? You have a database that uses stored procedures to perform INSERT, UPDATE, DELETE, and SELECT statements. You are tasked with providing a recommendation of indexes to be created and dropped from the database. You need to select the appropriate method to accomplish the task. Which method should you use? Which two business impacts do Cisco collaborative technologies bring into employee innovation? (Choose two.) You are tasked to analyze blocking behavior of the following query: SET TRANSACTION ISOLATION LEVEL SERIALIZABLEWITH Customers AS ( SELECT * FROM Customer ),SalesTotal AS ( SELECT CustomerId, SUM(OrderTotal) AS AllOrderTotal FROM SalesOrder)SELECT CustomerId, AllOrderTotalFROM SalesTotalWHERE AllOrderTotal > 10000.00; You need to determine if other queries that are using the Customer table will be blocked by this query. You also need to determine if this query will be blocked by other queries that are using the Customer table. What behavior should you expect? You have two tables named Customer and SalesOrder. In the Customer table you have 1000 customers, of which 900 customers have orders in the SalesOrder table. You execute the following query to list all customers that have had at least one sale. SELECT *FROM CustomerWHERE Customer.CustomerID IN (SELECT SalesOrder.CustomerID FROM SalesOrder) You need to identify the results of the query. Which results will the query return? In which two ways does Cisco Business Edition 6000 protect its investment for midsize businesses that will grow to become enterprise businesses with more than 1000 users in the future? (Choose two.) You are writing a batch that contains multiple UPDATE statements to modify existing products. You have placed these updates into one explicit transaction. You need to set an option at the beginning of the transaction to roll back all changes if any of the updates in the transaction fail. Which option should you enable? Which three of these are major management pain points in relation to collaboration? (Choose three.) When selling a Cisco Business Edition 6000 solution to a customer that plans to upgrade from an old voice collaboration solution, which three of these are some of the key messages that you would need to present to the customer? (Choose three.) You have a table named Customers that has an XML column named CustomerData. There are currently no indexes on the table. You use the following WHERE clause in a query: WHERE CustomerData.exist ('/CustomerDemographic/@Age[.>="21"]') = 1 You need to create indexes for the query. Which Transact-SQL statements should you use? You are the administrator of a SQL Server database. Database table modifications and additions must occur only between 11:00 P.M. and midnight. You need to ensure that if database table modifications or additions are attempted at any other time, an error is raised and the attempt is not successful. Which Transact-SQL statement should you use? Which two statements are true when comparing Cisco and Microsoft unified communications solutions? (Choose two.) Which endpoints and clients are supported on applications that are included under the Cisco Business Edition 6000 umbrella? You have a table named ProductCounts that contains 1000 products as well as the number of units that have been sold for each product. You need to write a query that displays the top 5% of products that have been sold most frequently.Which Transact-SQL code segments should you use? You administer a Microsoft SQL Server 2008 database that contains two tables named Products and Suppliers. You want to implement referential integrity between the Products and Suppliers tables. You want to create a new Foreign Key constraint on the Products table. The new Foreign Key constraint must meet the following requirements: ·It must be created on the SupplierID column on the Products table to refer to the SupplierID column on the Suppliers table. ·It must prevent the deletion of rows from the Suppliers table whenever an attempt is made to delete a Supplier by using a SupplierID referenced by Foreign Keys in existing rows in the Products table. You need to be able to create a new Foreign Key constraint by using Microsoft SQL Server Management Studio. What should you do? (To answer, configure the appropriate option or options in the dialog box in the answer area.) Work Area You have a SQL Server database. The database contains two schemas named Marketing and Sales. The Marketing schema is owned by a user named MarketingManager. The Sales schema is owned by a user named SalesManager. A user named John must be able to access the Sales.Orders table by using a stored procedure named Marketing.GetSalesSummary. John is not granted a SELECT permission on the Sales.Orders table. A user named SalesUser does have SELECT permission on the Sales.Orders table. You need to implement appropriate permissions for John and the stored procedure Marketing.GetSalesSummary. What should you do? Where in the value chain do collaboration architecture solutions bring the highest value to businesses? You have a table named Orders. You have been tasked to modify your company's main database to remove all inactive order rows. You are developing a stored procedure that will enable you to delete these rows. You have written the following code segment to accomplish this task. 01 BEGIN TRY 02 DECLARE @RowCount INT = 1000 03 WHILE @RowCount = 1000 04 BEGIN 05 DELETE TOP (1000) FROM Orders WHERE Status = 'Inactive';06 SET @RowCount = @@ROWCOUNT 07 ...08 END 09 END TRY 10 BEGIN CATCH 11 PRINT ERROR_MESSAGE()12 END CATCH You need to insert a Transact-SQL statement that will notify you immediately after each batch of rows is deleted. Which Transact-SQL statement should you insert at line 07? In the Cisco Business Edition 6000 sales cycle, mapping the solution and its business benefits to the business initiatives is of essential importance. Where in the sales cycle does this mapping typically occur? Which Cisco Unified Communications application provides voice messaging capabilities with Cisco Business Edition 6000? You are updating a database table. You need to partition the table to store only the last 1000 rows of data in the table. What should you do? You have a table named Orders. OrderID is defined as an IDENTITY(1,1). OrderDate has a default value of 1. You need to write a query to insert a new order into the Orders table for CustomerID 45 with today's date and a cost of 89.00. Which statement should you use? You need to alter stored procedures to use the WITH RECOMPILE option. Which types of stored procedures should you alter? (Each correct answer represents a complete solution. Choose two.) You attempt to query sys.dm_db_index_usage_stats to check the status on the indexes in the Contoso database. The query fails and you receive the following error: "The user does not have permission to perform this action." You need to have the least amount of permissions granted to access the dynamic management views. Which permissions should be granted? You have a server named Contoso with multiple databases. You have been tasked to write a PowerShell script to determine which databases on the server are larger than 100GB. You open PowerShell from SQL Server Management Studio. You create two variables as follows: PS SQLSERVER:\SQL\Contoso> $MultipleOfGB = 1024 * 1024 PS SQLSERVER:\SQL\Contoso> $Server = Get-Item You need to determine which script will produce the desired list of databases. What script should you use? Your company uses an application that passes XML to the database server by using stored procedures. The database server has a large number of XML handles that are currently active. You determine that the XML is not being flushed from SQL Server memory. You need to identify the system stored procedure to flush the XML from memory. Which Transact-SQL statement should you use? You want to delete a User-Defined Function (UDF) named ufnGetProductListPrice from the AdventureWorks2008R2 database. You need to perform the following tasks before executing DROP FUNCTION on ufnGetProductListPrice: ·V iew a list of objects that depend on ufnGetProductListPrice. ·V iew a list of objects on which ufnGetProductListPrice depends. What should you do? (To answer, select the appropriate option or options in the answer area.) Work Area You are using TRY…CATCH error handling. You need to raise an error that will pass control to the CATCH block. Which severity level should you use? You are required to modify a table named Sales.SalesOrder. The table has change tracking enabled on it. You need to disable change tracking prior to modifying the Sales.SalesOrder table. Which Transact-SQL statement should you use? You have two views named Sales.SalesSummaryOverall and Sales.CustomerAndSalesSummary. They are defined as follows: CREATE VIEW Sales.SalesSummaryOverallAS SELECT CustomerId, SUM(SalesTotal) AS OverallTotal FROM Sales.SalesOrder GROUP BY CustomerIdGOCREATE VIEW Sales.CustomerAndSalesSummaryAS SELECT Customer.Name, SalesSummaryOverall.OverallTotal, (SELECT AVG(OverallTotal) FROM Sales.SalesSummaryOverall WHERE SalesSummaryOverall.CustomerId = Customer.CustomerId) AS avgOverallTotal, (SELECT MAX(OverallTotal) FROM Sales.SalesSummaryOverall WHERE SalesSummaryOverall.CustomerId = Customer.CustomerId) AS maxOverallTotal, FROM Sales.Customer LEFT OUTER JOIN Sales. Sales.SalesSummaryOverall ON SalesSummaryByYear.CustomerId = Customer.CustomerIdGO You have been tasked to modify the Sales.CustomerAndSalesSummary view to remove references to other views. You need to identify a feature to use in the modified version of the Sales.CustomerAndSalesSummary object to achieve the task. Which feature should you use? You have tables named Sales.SalesOrderDetails and Sales.SalesOrderHeader. You have been tasked to update the discount amounts for the sales of a particular salesperson. You need to set UnitPriceDiscount to .1 for all entries in Sales.SalesOrderDetail that only correspond to SalesPersonID 290. Which Transact-SQL statement should you use? You have two tables named dbo.CurrentProducts and dbo.ArchiveProducts. You have the following query: SELECT ProductID, Name FROM dbo.CurrentProductsUNION ALLSELECT ProductID, NameFROM dbo.ArchiveProducts; You need to predict the list of products that the query will produce. Which list of products should the query return? You notice that a database server is responding slowly to queries. You run the following dynamic management views (DMV) query on the server. SELECT TOP (10) wait_type, wait_time_msFROM sys.dm_os_wait_statsORDER BY wait_time_ms DESC; The query returns a top wait type of SOS_SCHEDULER_YIELD. You need to identify what is causing the server response issues. Which resource should you investigate first? Which statement best describes the Cisco collaboration architecture? You are given a database design to evaluate. All of the tables in this database should have a clustered index. You need to determine the tables that are missing a clustered index by using the system catalog views. Which Transact-SQL statement should you use?