70-458 무료 덤프문제 온라인 액세스

DRAG DROP
You are building a SQL Server Integration Services (SSIS) package to load product data sourced from aWindows Azure SQL Database database to a data warehouse. Before the product data is loaded, you create a batch record by using an Execute SQL task named Create Batch. After successfully loading the product data, you use another Execute SQL task named Set Batch Success to mark the batch as successful.

You need to create and execute an Execute SQL task to mark the batch as failed if either the Create Batch or Load Products taskfails.
Which three steps 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 are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day.
Referential integrity must be enforced declaratively.
You need to design a solution that can join a single time dimension to both fact tables.
What should you do?

• A.Create a time dimension that can join to both fact tables at their respective granularity.
• B.Join the two fact tables.
• C.Create a surrogate key for the time dimension.
• D.Create a view on the sales table.

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are developing a SQL Server Integration Services (SSIS) project that copies a large amount of rows from aWindows Azure SQL Database database. The project uses the PackageDeployment Model. This project is deployed to SQL Server on atest server.
You need to ensure that the project is deployed to the SSIS catalog on the production server.
What should you do?

• A.Open a command prompt and run the dtutil /copy command.
• B.use an msi file to deploy the package on the server.
• C.Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.
• D.Configure the SSIS solution to use the Project Deployment Model.
• E.Open a command prompt and run the gacutil command.
• F.create a reusable custom logging component and use it in the SSIS project.
• G.Open a command prompt and run the dtexec /rep /conn command.
• H.Add an OnError event handler to the SSIS project.
• I.Open a command prompt and run the dtexec /dumperror /conn command.
• J.Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
• K.Configure the output of a component in the package data flow to use a data tap.

You are the lead database administrator (DBA) of a Microsoft SQL Server 2012 environment.
All DBAs are members of the DOMAIN\JrDBAs Active Directory group. You grant DOMAIN\JrDBAs access to the SQL Server.
You need to create a server role named SpecialDBARole that can perform the following functions:
- View all databases.
- View the server state.
- Assign GRANT, DENY, and REVOKE permissions on logins.
You need to add DOMAIN\JrDBAs to the server role. You also need to provide the least level of privileges necessary.
Which SQL statement or statements should you use? Choose all that apply.

• A.GRANT VIEW DEFINITION TO [SpecialDBARole];
• B.CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION securityadmin;
• C.CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION setupadmin;
• D.GRANT VIEW SERVER STATE, VIEW ANY DATABASE TO [SpecialDBARole];
• E.ALTER SERVER ROLE [SpecialDBARole] ADD MEMBER [DOMAIN\JrDBAs];
• F.CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION serveradmin;

You administer a Windows Azure SQL Database database named Inventory that contains a stored procedure named p_AddInventory.
Users need to be able to SELECT from all tables in the database and execute the stored procedure. You need to grant only the necessary permissions.
What should you do?

• A.Create a new database role. Grant EXECUTE permission on p_AddInventory to the new role. Grant VIEW DEFINITION to to the role. Add all users to the role.
• B.Create a new database role. Grant EXECUTE permission on p_AddInventory to the newrole. Add all users to the role. Add all users to the db_datareader role.
• C.Add EXECUTE AS OWNER to the stored procedure. Add all users to the db_datareader role.
• D.Add all users to the db_datawriter role. Add all users to the db_datareader role.