- Description
DAT 390 All Discussions
The Latest Version A+ Study Guide
**********************************************
DAT 390 All Discussions Link
https://hwsell.com/category/dat-390/
**********************************************
DAT 390 Wk 1 Discussion – Concurrent Transaction Execution and Concurrency Control
Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to classmates or your faculty member.
Due Thursday
Respond to the following in a minimum of 175 words:
- Explain three common problems with concurrent transaction execution and how concurrency control can be used to avoid them. Describe an example that illustrates either:
- A problem with concurrent transaction execution and its effects on the operational performance of the system
- The effectiveness of concurrency control
Due Monday
Post 2 replies to classmates or your faculty member. Be constructive and professional.
DAT 390 Wk 2 Discussion – U.S. Student Aid Initial Database Process
Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to classmates or your faculty member.
Due Thursday
Week 1 introduced the U.S. Student Aid Initial Database Schema assignment.
Respond to the following in a minimum of 175 words:
- What was your process for reviewing the data and preparing an initial database schema? What strategies can be used to help incorporate best practices for SQL queries and optimization?
- Share a question you have related to this discussion.
Due Monday
Post 2 replies to classmates or your faculty member. Be constructive and professional.
DAT 390 Wk 3 Discussion – Business Intelligence Components and Distributed Warehouses
Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to classmates or your faculty member.
Due Thursday
Review Table 13.2, Basic BI Architectural Components, in Ch. 13 of Database Systems: Design, Implementation, & Management.
Respond to the following in a minimum of 175 words:
- Select two of the Business Intelligence (BI) system components listed in Table 13.2. Describe an example of when you would use each BI component in conjunction with a distributed warehouse.
Due Monday
Post 2 replies to classmates or your faculty member. Be constructive and professional.
DAT 390 Wk 4 Discussion – U.S. Student Aid Database Warehouse Follow-up
Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to classmates or your faculty member.
Due Thursday
Respond to the following in a minimum of 175 words:
- What strategies did you use to transform your operational data structure and schema into a data structure and schema for a data warehouse?
- How can you assess your data warehouse data for accuracy and consistency?
- Share a question that you have related to this discussion.
Due Monday
Post 2 replies to classmates or your faculty member. Be constructive and professional.
DAT 390 Wk 5 Discussion – Analytics Databases and Data Warehouses
Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to classmates or your faculty member.
Due Thursday
IT professionals work with many non-IT business partners whose understanding and support are critical to ensuring that IT strategies are implemented, and goals are attained.
Imagine you are working with a non-IT partner who does not understand the differences between an analytics database and a data warehouse; nor does your partner understand the effect that the differences have on how you approach data analytics.
Respond to the following in a minimum of 175 words:
- Explain the key differences between an analytics database and a data warehouse and how those differences affect your selection of business intelligence tools and data analysis processes. In addition, explain to a non-IT professional the general process of assessing semi-structured data in relational DBMS.
Due Monday
Post 2 replies to classmates or your faculty member. Be constructive and professional.